Description

Lead data integration, warehousing, and modeling efforts within an Agile environment.

Responsibilities

• Analyze existing data sources to determine migration requirements.
• Document source-to-target (S2T) mapping documents.
• Design and apply data modeling using star-schema models and data architecture techniques.
• Develop and maintain ETL/ELT pipelines using Python and other scripting languages.
• Communicate technical requirements and findings between technical and non-technical teams.

Required Skills

• 10+ years of experience in data integration, data warehousing, and data modeling.
• 8+ years of experience with relational database technologies such as SQL Server, Oracle, or Teradata.
• 7+ years of experience with ETL/ELT tools including Apache Spark, Informatica, SSIS, or AWS Glue.
• Expert knowledge of SQL (T-SQL, MSSQL, NoSQL) including programmability and performance optimization.
• Proficiency in Python for custom ETL/ELT and scripting.
• Experience developing in a Public Cloud environment, specifically Snowflake.
• Experience working with large datasets and big data technologies.
• Familiarity with data visualization platforms like Tableau or Power BI.
• Experience using source control tools and working within Agile delivery frameworks.

Preferred Skills

• Experience migrating data from SQL to Snowflake.
• Management consulting experience.

Key Skills

Education

Any Graduate