Description

You will support Data Integration and Analytics teams by delivering a large-scale database migration project.

Responsibilities

• Execute assigned data migrations on daily and weekly schedules within defined scopes and timelines.
• Design, develop, test, and maintain ELT processes to consolidate data from multiple sources into a single warehouse.
• Collaborate with architects, engineering teams, and business stakeholders to build accurate information products.
• Maintain data warehouse and pipeline platform operations to ensure high availability and performance.
• Provide production support on a rotating basis.

Required Skills

• 5+ years of experience with SQL, specifically in an analytics and reporting capacity.
• 2+ years of experience with Python.
• Advanced data modeling skills, including star schemas, snowflake schemas, and slowly changing dimensions.
• Deep understanding of relational structures, dimensional modeling, and ELT processing.
• Proficiency with SQL window functions, scalar/aggregate functions, joins, and set operations.
• Experience with source code management using Git, GitHub, or GitLab.
• Ability to test and document data accuracy efficiently.
• Strong understanding of primary/foreign keys, indexes, tables, and views.
• BS or MS in Computer Science, Mathematics, Statistics, or a related discipline.

Preferred Skills

• Experience with Snowflake.
• Prior experience performing data warehouse migrations.
• Experience working in an Agile environment.

Key Skills

Education

Any Graduate