Description

You will design and develop ETL processes, data engineering workflows, and systems for the Data Asset Program and Data Hub.

Responsibilities

• Design and develop ETL processes for standard and spatial data, including maintenance of the Data Hub.
• Build new data engineering processes leveraging cloud architecture and migrate existing pipelines as required.
• Design and support DW database schemas, table structures, and Data Marts optimized for reporting.
• Collaborate with data scientists and analysts to populate data warehouse structures.
• Decompose business requirements into Epics, Features, and user stories while managing the product backlog.
• Perform quality analyst functions including defining test objectives, plans, and executing test cases.

Required Skills

• 10+ years of experience delivering business data analysis artifacts.
• 5+ years of experience as an Agile Business Analyst with strong Scrum methodology knowledge.
• Exceptional experience 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 in managing operational data stores, data warehouses, data lakes, and data marts.
• Experience with Molap, Rolap, SSIS, and SSRS.
• Experience with Azure Data Lake Store, Azure Blob Storage, and Azure SQL Data Warehouse.
• Proficiency in Python and Linux Shell Scripting.

Preferred Skills

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

Key Skills

Education

Any Gradute