Senior Data & AI Platform Architect

Openkrill; United States; Remote; USD 140,000 - 210,000; Full time

Job summary

OrderYOYO is seeking a Senior Data & AI Platform Engineer to own the modern data platform during a scalable phase, migrating to a governed Microsoft Fabric platform and delivering AI-enabled data capabilities. You will lead data pipelines, semantic models and reporting, mentoring engineers and shaping governance across the stack.

The role focuses on becoming the governance and AI-enablement backbone for reporting, BI and analytics, with collaboration across finance, product, marketing and

Qualifications

• 6+ years in modern data warehousing, analytics engineering or data platform engineering.
• Strong Microsoft Fabric capability, or deep Azure Synapse / Databricks experience.
• Expert SQL/T-SQL plus strong Python or PySpark, with a track record of building maintainable ELT/ETL pipelines and analytical data models.
• Strong Power BI and DAX experience, including semantic modelling, incremental refresh, performance tuning, model governance and capacity/cost awareness.
• Experience leading legacy-to-modern data platform migrations, including metric parity, stakeholder validation, change control and safe decommissioning.
• Experience operating production data systems: monitoring, alert design, incident triage, root-cause analysis, data-quality checks, lineage and runbooks.
• Comfortable with Git-based data engineering workflows, pull requests, release discipline and standards for notebooks, pipelines and semantic model changes.
• Practical experience using AI or automation to improve data engineering, reporting, documentation, testing, monitoring, migration or developer productivity.

Responsibilities

• Lead hands-on Microsoft Fabric architecture across lakehouse, warehouse, notebooks, semantic models, Git-backed delivery and production governance.
• Drive migration from legacy reporting and metric tooling into a governed Fabric semantic layer, including parity testing, stakeholder sign-off and safe decommissioning.
• Own and improve data pipelines across APIs, files, events and operational stores; establish robust orchestration, monitoring, alerting, data-quality checks and incident response.
• Use AI and automation to accelerate ETL/ELT development, data mapping, documentation, testing, report generation, monitoring and data-quality management.
• Design high-quality Power BI semantic models, DAX measures and reusable metric definitions for leadership, finance, commercial, product, marketing, payments and support reporting.
• Support CRM and operational data integrations, including outbound data feeds, identity mapping, schema mapping, reverse-ETL patterns and monitoring.
• Create reliable ingestion and modelling patterns for acquired businesses, so future integrations are repeatable, auditable and faster to execute.
• Set data-engineering standards: definition of ready/done, code review, release discipline, documentation, runbooks and platform change governance.
• Mentor engineers and analysts and translate business-critical data needs into pragmatic technical delivery.
• Build automated reporting and insight-generation capabilities that reduce manual analysis and improve decision speed.

Skills

SQL/T-SQL

Python

PySpark

Power BI

Databricks

Azure Fabric

Azure Synapse

Data modelling

ETL/ELT pipelines

Git workflows

Tools

Microsoft Fabric

Azure Synapse

Databricks

Power BI

Git

Job description

OrderYOYO is seeking a Senior Data & AI Platform Engineer to own the modern data platform during a scalable phase, migrating to a governed Microsoft Fabric platform and delivering AI-enabled data capabilities. You will lead data pipelines, semantic models and reporting, mentoring engineers and shaping governance across the stack.

The role focuses on becoming the governance and AI-enablement backbone for reporting, BI and analytics, with collaboration across finance, product, marketing and