Remote EDW Engineer - Data Platform & Pipelines

Evolving Solution Services; Idaho; On-site; USD 115,000 - 130,000; Full time

Benefits offered by this job

Health insurance

Paid time off

Vision insurance

401(k)

Job summary

BlueAngle is seeking an Enterprise Data Warehouse Engineer to design, build, and operationalize data warehouse infrastructure and pipelines in a remote US delivery model. You will translate business requirements into scalable architecture, craft production-grade pipelines, and share knowledge with client and partner teams across the engagement lifecycle.

The role emphasizes client-facing delivery, governance, and performance optimization, with a focus on Azure data services, data modelling, and

Qualifications

• 8–12 years data engineering experience with at least 4 years on the Azure data stack (Synapse, Data Factory, SQL, Python or Scala).
• Strong SQL and data modelling — dimensional modelling, normalization, and/or data vault.
• Familiarity with medallion / lakehouse architecture where relevant to the target platform.
• Direct experience modelling ERP data (D365 F&O, AX, or SAP).
• At least one full-lifecycle ERP implementation where they led the warehouse / reporting layer.
• Performance tuning, query optimization, partitioning, clustering, and cost management on the target platform.
• Understanding of cloud storage patterns (data lake, blob/storage) and their interaction with the warehouse layer.
• Experience building data quality frameworks — validation rules, reconciliation, exception reporting.
• Ability to translate technical concepts for non-technical client stakeholders.
• Strong written English — formal documentation, runbooks, and client-facing deliverables will be produced in English.
• Experience working in MSP, consulting, or client-embedded delivery contexts is strongly preferred.

Responsibilities

• Lead source system analysis and data profiling across all in-scope systems.
• Design the target data model — dimensional (star/snowflake), data vault, or medallion architecture.
• Define schema standards, naming conventions, and conformed dimension frameworks for downstream BI and analytics consumers.
• Produce logical and physical data model documentation as a formal deliverable (D2).
• Build, test, and schedule ingestion pipelines from all identified source systems (D3).
• Develop the curated/conformed transformation layer per the agreed architecture (D4).
• Implement orchestration using [dbt / Azure Data Factory / Airflow / SSIS / other] — to be confirmed with client environment.
• Apply CI/CD practices for pipeline versioning, testing, and deployment where the environment supports it.

Skills

Azure data stack

SQL

Data modelling

ERP data modelling

Data quality

Tools

Azure Synapse

Azure Data Factory

dbt Fundamentals

Python

Job description

BlueAngle is seeking an Enterprise Data Warehouse Engineer to design, build, and operationalize data warehouse infrastructure and pipelines in a remote US delivery model. You will translate business requirements into scalable architecture, craft production-grade pipelines, and share knowledge with client and partner teams across the engagement lifecycle.

The role emphasizes client-facing delivery, governance, and performance optimization, with a focus on Azure data services, data modelling, and