ETL Developer

You will design and develop integrations for the Enterprise Data Asset program, focusing on ETL processes and business intelligence.

Responsibilities

• Develop data engineering processes leveraging cloud architecture and migrate existing data pipelines to these environments.
• Design and support DW database and table schemas for new and existing data sources within the data hub and warehouse.
• Build and develop Data Marts to support business requirements.
• Partner with data modelers, architects, analysts, and scientists to refine requirements and optimize table structures for reporting.

Required Skills

• 5+ years of experience in ETL development and data warehousing.
• Extensive experience with Data Factory v2, Data Lake Store, and Data Lake Analytics.
• Proficiency with Azure Analysis Services and Azure Synapse.
• Hands-on experience with Snowflake and Azure SQL Data Warehouse.
• Strong command of Python and Linux shell scripting.
• Experience with SQL Server (SSIS, SSRS, SSAS), Oracle, and T-SQL.
• Knowledge of Kimball and Inmon data warehousing architectures.
• Familiarity with HDFS, Azure Data Lake Store, Azure Blob Storage, and Databricks.
• Experience using IBM DataStage, Erwin, and MS Team Foundation Server.
• Proficiency in Business Objects, Power BI, or Tableau.

Preferred Skills

• Understanding of Agile methodologies and processes.
• Advanced knowledge of analytical and dimensional modeling.