Description

Design and develop ETL processes, spatial data pipelines, and data engineering workflows within a new cloud architecture.

This role is on-site.

Responsibilities

• Design and develop ETL processes, data marts, and systems for the Data Asset Program and Data Hub.
• Build and migrate data pipelines to a new cloud architecture using Azure services.
• Design DW database and table schemas for new and existing data sources.
• Profile source data, including spatial components, to identify conflicts and resolve semantic issues.
• Decompose requirements into Epics, Features, and user stories while assisting the Product Owner with backlog maintenance.

Required Skills

• 10+ years of experience delivering business data analysis artifacts.
• 5+ years of experience as an Agile Business Analyst using Scrum methodology.
• Expertise in writing complex SQL queries for SQL Server and Oracle.
• Hands-on experience with Azure Databricks, Azure Data Factory, and Snowflake.
• Experience with ESRI ArcGIS and enterprise data management.
• Proficiency with reporting systems including operational data stores, data warehouses, data lakes, and data marts.
• Technical proficiency with SQL Server (SSIS, SSRS, SSAS), ETL, Data Warehousing, and Data Lake technologies.
• Strong experience in data profiling, entity resolution, and metadata management.
• Advanced use of Microsoft Office suite, including Visio and Project Server.

Preferred Skills

• Advanced understanding of data integrations and database architectures.
• Strong analytical, problem-solving, and conflict-resolution skills.

Key Skills

Education

Any Graduate