Description

Build and maintain the data warehouse by ingesting and aggregating data from internal and external sources.

This role is on-site.

Responsibilities

• Design conceptual, logical, and physical data models including ODS, Enterprise Data Warehouses, and Data Marts.
• Build and maintain ETL processes and data lakes using Azure Data Factory and SQL VMs.
• Develop and optimize complex T-SQL stored procedures.
• Apply data warehousing and business intelligence design principles to solve complex analytical problems.
• Mentor and guide developers with less experience.

Required Skills

• 5+ years of experience in Data Warehousing and Business Intelligence.
• Expert-level T-SQL programming skills and 5+ years with SSIS and stored procedures.
• 5+ years of experience with Azure Data Factory and SQL VMs for ETL and data lake maintenance.
• 3+ years of BI development leveraging Microsoft SQL Server 2014+.
• 2+ years of experience with Power BI.
• 2+ years of experience with Azure Data Warehouse (Synapse).
• Strong understanding of relational database design and data modeling.

Preferred Skills

• Experience using GitHub.

Bachelor's degree, preferably in computer science, information sciences, or business.

Key Skills

Education

Bachelor's degree