What are the responsibilities and job description for the Data Warehouse Engineer position at Centraprise?
Data Warehouse Engineer
Remote/ Draper UT
Fulltime
Position Summary:
Role - Data Warehouse Engineer
Experience Required - 10 Years
Must Have Technical/Functional Skills
- 10 years of experience SSRS , Databricks, Data Lake Storage Gen2, Azure Analysis Services
- CI/CD, Git, Jenkins/GitHub/Azure DevOps pipelines
- Strong communication, stakeholder management, and problem-solving skills.
Roles & Responsibilities:
Architecture & Strategy
- Designing and implementing cloud-based data warehouses using Azure Synapse Analytics (formerly SQL DW) to create a single source of truth.
- Building pipelines with Azure Data Factory (ADF) or Azure Databricks to ingest, transform, and load data from diverse sources into the warehouse.
- Developing dimensional models (fact and dimension tables) within the Gold layer of the Medallion architecture to enable efficient BI reporting.
- Tuning SQL queries, managing indexes, partitioning, and scaling Synapse compute resources to maintain high performance.
- Integrating structured relational data with unstructured data from Azure Data Lake
- Analyze COBOL programs, copybooks, JCL workflows, CICS/IMS transactions, DB2 schemas, and VSAM files.