General Summary:
The EDA team is looking for a Data Engineer II to help advance our goals to build a world class data-driven enterprise. The Enterprise Data and Analytics (EDA) team at Elevate is responsible for delivering the data strategy, enterprise reporting and data lake capabilities to our business partners. Our master data and EDW platforms are used by multiple business processes and underpin key facets of our operations.
The right candidate will have the opportunity to work in an exciting, dynamic, and collaborative workplace. They will be solving challenging problems, working with leading-edge technologies, and collaborating with a team of talented professionals. We have great organizational vision and leadership and have built an environment to grow and nurture top talent. We offer competitive compensation, benefits, and perks. We pride ourselves on our entrepreneurial culture, our passion for innovation and hard work and we also remember to have fun.
Principal Duties and Responsibilities:
The EDA Data Engineer II will be primarily responsible for:
- Create data integration processes for our operational, EDW and data lake repositories on our Snowflake cloud data platform
- Profile and analyze data sources to help build custom metrics, data pipelines, datamarts, and extracts
- Design and implement data strategies, target data models and ETL/ELT processes for real-time and batch strategies
- Address performance and data quality issues
- Build upon existing data design concepts and integrate solutions within EDA's long-term data strategy
- Develop monitoring and operational proficiencies throughout the data lifecycle process
- Help troubleshoot and support data structures and processes
- Work with business partners & cross-functional teams to gather requirements and collaborate over business solutions
Skills & Experience:
Required:
- Bachelor's Degree in Computer Science, MIS or related field or equivalent experience
- Overall, 2-6 years IT experience with 2+ years using database technologies like SQL Server, Teradata, Oracle, etc.
- Solid understanding and using of ETL tools like Informatica, SSIS, Talend, etc.
- Thorough understanding of systems analysis and design, SDLC
- Very well versed in SQL and database concepts
- Demonstrable experience with at least one programming/scripting language such as Python, Bash, PowerShell, Java, or .NET
- Strong data analysis and profiling skills
- Excellent communication skills, ability to collaborate with business as well as technical people
- Comfortable working in a fast-paced and dynamic environment as well as ability to work on multiple initiatives independently
- Passion for data
Desirable:
- 1+ years of using data lake platforms such as Hadoop, Snowflake, or related technologies
- Experience with multiple programming/scripting languages
- Having worked with semi-structured data or document processing with XML & JSON formats
- Working knowledge of data warehouse concepts including the use of dimensional modeling and schema designs
- Experience working with EDW or Master Data (MDM) systems
- Knowledge of financial and loan management systems
#LI-BJ1
#LI-Hybrid