Senior Data Warehouse Engineer

Algoworks

www.algoworks.com

About the Company

We are a global team of engineers, architects, designers, researchers, operators and innovators who share a passion for achieving client goals. Our engineering services help businesses thrive at the intersection of technology and people. From the latest AI implementations to legacy platform migrations and everything in between, our services span the enterprise technology spectrum. Our world class experience transformation playbook elevates digital success and increases ROI with a relentless focus on the human experience. Our customer base includes Fortune 500 companies around the globe. We've got the skills and insights and we're also fun to work with. Our global team spans a diverse cultural spectrum, with wide ranging interests, enabling us to bring personality and depth to every engagement.

Follow the video below to know about US!

Candidate Video

Job Title: Senior Data Warehouse Engineer

Experience Level

68 years of hands-on data warehouse development experience, with strong expertise in Azure Synapse Dedicated SQL Pool.

Role Overview

The Senior DWH Developer will be responsible for implementing and maintaining Gold layer data warehouse objects in Azure Synapse Dedicated SQL Pool. This role focuses on building performance-optimized tables, views, and stored procedures, and implementing Silver Gold transformations to support BI, reporting, and data sharing use cases.

The developer will work under the guidance of the DWH Architect and collaborate closely with ETL and BI teams.

Key Responsibilities

Synapse Development

Develop Synapse Dedicated SQL Pool objects including:

o Tables

o Views

o Stored procedures

Implement Gold layer schemas as per architectural standards.

Manage schema changes and deployments.

Silver Gold Transformations

Implement ELT transformations from Silver layer to Gold layer using T-SQL.

Apply business rules and aggregation logic for reporting.

Ensure data accuracy, consistency, and reconciliation.

Performance & Query Optimization

Develop high-performance T-SQL optimized for MPP execution.

Apply appropriate distribution, indexing, and partitioning strategies.

Tune queries to support BI and reporting workloads.

Reporting & Data Sharing

Support reporting teams with optimized SQL views and datasets.

Implement Azure Data Share mappings for external data consumers.

Develop downstream export logic and data extracts as required.

Testing & Operations

Perform data validation and reconciliation checks.

Support production deployments and issue resolution.

Follow coding standards and version control best practices.

Required Skills & Experience

Experience

68 years of experience in data warehouse development.

Strong experience building Gold layer warehouses in MPP environments.

Hands-on experience with Azure Synapse Dedicated SQL Pool.

Technical Skills

Strong proficiency in T-SQL.

Hands-on experience with Synapse Dedicated SQL Pool.

Experience developing views and stored procedures.

Strong knowledge of performance tuning in MPP systems.

Experience with ELT-based data transformations.

Familiarity with data sharing and downstream export patterns.

Tools & Practices

Experience with SQL deployment and version control.

Familiarity with SQL pipelines or orchestration tools.

Strong data validation and testing skills.

Soft Skills

Strong analytical and problem-solving abilities.

Ability to work independently on complex SQL workloads.

Good collaboration and communication skills.

Nice to Have

Experience supporting Power BI or enterprise reporting tools.

Exposure to Azure Data Share and external data distribution.

Experience working in large-scale enterprise data programs.