Azure Data Warehouse Engineer | Synapse, ADF & Databricks

Veriipro; United States; On-site; USD 120,000 - 190,000; Full time

Job summary

Veriipro is seeking a data warehouse architect/engineer to design and implement scalable cloud data warehouse solutions on Azure Synapse, establishing a single source of truth across the enterprise.

You will optimize ETL/ELT pipelines with ADF and Databricks, integrate structured and unstructured data, modernize legacy systems, and drive CI/CD, collaboration with stakeholders, and technical leadership.

Qualifications

• Strong experience designing scalable cloud data warehouse solutions on Azure.
• Establish enterprise data warehouse architecture as a single source of truth.
• Develop dimensional models for BI reporting and analytics.
• Build ETL/ELT pipelines with Azure Data Factory and Azure Databricks.
• Ingest and transform data into Azure Data Lake and Synapse.
• Optimize SQL queries and performance with indexing and partitioning.
• Ensure high availability and scalability of data warehouses.
• Integrate structured and unstructured data within Azure.
• Modernize legacy mainframe systems (COBOL, JCL, CICS/IMS, DB2, VSAM).
• Implement CI/CD pipelines using Git, Jenkins, GitHub, or Azure DevOps.
• Provide release management and version control across data initiatives.
• Collaborate with stakeholders to translate requirements into scalable data solutions.

Responsibilities

• Design scalable cloud data warehouse solutions on Azure Synapse.
• Define enterprise DW architecture as a single source of truth.
• Develop dimensional models for BI reporting.
• Build ETL/ELT pipelines with ADF and Databricks.
• Ingest and transform data into Azure Data Lake and Synapse.
• Optimize SQL queries and performance via indexing and partitioning.
• Ensure high availability and scalability of DW solutions.
• Integrate structured and unstructured data in Azure.
• Modernize legacy mainframe systems (COBOL, JCL, CICS/IMS, DB2, VSAM).
• Implement CI/CD pipelines using Git/Jenkins/GitHub/Azure DevOps.
• Ensure automated deployments and release management.
• Collaborate with stakeholders to translate requirements into scalable data solutions.
• Provide technical leadership across data initiatives.

Skills

SQL performance tuning

Dimensional data modeling

Medallion architecture

Stakeholder management

Data integration

Analytical thinking

Mainframe modernization

Tools

Azure Synapse Analytics

Azure Data Factory

Azure Databricks

Azure Data Lake Storage Gen2

SSRS

Azure Analysis Services

Git

Jenkins

GitHub

Azure DevOps

Job description

Veriipro is seeking a data warehouse architect/engineer to design and implement scalable cloud data warehouse solutions on Azure Synapse, establishing a single source of truth across the enterprise.

You will optimize ETL/ELT pipelines with ADF and Databricks, integrate structured and unstructured data, modernize legacy systems, and drive CI/CD, collaboration with stakeholders, and technical leadership.