Job Summary
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 EDA team is looking for a Senior Data Engineer to help advance our goals to build a world class data-driven enterprise.
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 Senior Data Engineer 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
- Responsible for leading & coordinating the technical aspects of major projects across teams and business partners
- Assists with advanced design on EDA data models, applications, & solutions
- Subject matter expert on EDA technologies and processes
- Responsible for code review, story planning, and mentoring of other engineers
Skills & Experience
Required
- Bachelor's Degree in Computer Science, MIS or related field or equivalent experience
- Overall, 6-8 years IT experience with 3+ years using database technologies like SQL Server, Teradata, Oracle, etc.
- 1+ years of using data lake platforms such as Hadoop, Snowflake, or related technologies
- Advanced understanding and using of ETL tools like Informatica, SSIS, Talend, etc.
- Solid understanding of systems analysis and design, SDLC
- Very well versed in SQL and database concepts
- Demonstrable experience with at least multiple 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
- Advanced work 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
- Advanced experience with performance tuning of SQL queries, processing statements, and pipeline applications
- Knowledge of financial and loan management systems
#LI-BJ1