Description

You will design and develop systems for ETL processes, business intelligence, and the maintenance of the Data Asset Program.

Responsibilities

• Design and support DW database and table schemas for new and existing data sources within the data hub and warehouse.
• Develop ETL processes and data integration solutions to support business intelligence needs.
• Collaborate with data analysts, data scientists, and business consumers to gather and populate data hub requirements.
• Manage and maintain data assets, ensuring effective integration across diverse data stores.

Required Skills

• 10+ years of experience delivering business data analysis artifacts.
• Expertise in IBM DataStage, Erwin, and SQL Server (SSIS, SSRS, SSAS).
• Advanced proficiency in Oracle and T-SQL.
• Hands-on experience with Azure SQL Database and Azure SQL Datawarehouse.
• Strong knowledge of data warehousing architectures, including Kimball and Inmon.
• Experience with ETL, data warehousing, and business intelligence tools such as PowerBI and Tableau.
• Proficiency in scripting with Python, Windows, or Linux Shell.
• Experience with Azure Data Factory v2, Data Lake Store, Data Lake Analytics, Azure Analysis Services, and Azure Synapse.
• Experience with enterprise data management and reporting systems including data lakes and data marts.

Preferred Skills

• Advanced understanding of data integration and database architectures.
• Experience ingesting spatial data using ESRI ArcGIS.

Key Skills

Education

Any Graduate