Description

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

Responsibilities

• Design and support data warehouse database and table schemas for new and existing data sources within the data hub and warehouse.
• Collaborate with data analysts, data scientists, and business consumers to gather and populate data hub requirements.
• Develop and maintain data integrations and ingest spatial data.
• Manage and prioritize multiple complex data projects and tasks.
• Negotiate and resolve technical conflicts during system implementation.

Required Skills

• 10+ years of experience in data warehousing architectures, specifically Kimball and Inmon methodologies.
• 10+ years of expertise in Azure Cloud engineering, including Data Factory v2, Data Lake Store, Data Lake Analytics, Azure Analysis Services, and Azure Synapse.
• 10+ years of experience with IBM DataStage, Erwin, and SQL Server (SSIS, SSRS, SSAS).
• 10+ years of experience with Oracle, T-SQL, Azure SQL Database, and Azure SQL Datawarehouse.
• 10+ years of experience with Windows and Unix operating system environments.
• 10+ years of scripting experience using Python, Windows, or Linux Shell.
• Proficiency in MS Office suite (Word, PowerPoint, Excel), MS Project, MS Visio, and MS Team Foundation Server.

Preferred Skills

• Bachelor's degree in Computer Science.

Key Skills

Education

Bachelor's degree in Computer Science