Senior Data Engineer – Microsoft Fabric & Power Platform in Columbus
Career & Market Insight
Career Positioning: High-Demand Stack in a Growing Consulting Firm
This role sits at the intersection of Microsoft Fabric (one of the fastest-growing modern data platforms) and Power Platform — a combination that is increasingly rare and highly valued in enterprise environments. Microsoft Fabric expertise in particular is currently commanding premium salaries as adoption accelerates across financial services and industrial sectors.
Skills You'll Build:
- Medallion architecture design (Bronze/Silver/Gold) — a transferable, cloud-agnostic data modeling pattern.
- PySpark and Azure Data Factory orchestration — core enterprise data engineering credentials.
- CI/CD for data pipelines via Azure DevOps — bridges data engineering and DevOps, broadening your profile.
- Power Platform governance (DLP, Dataverse, environment strategy) — increasingly sought in large Microsoft-shop enterprises.
Work-Life Balance Signals: 100% remote, dedicated training time built into the work week, and a mentoring program suggest a culture that invests in engineer wellbeing. The small team size (2 engineers) means high ownership and visibility, but also limited redundancy — expect periods of high workload.
Green Flags: Zartis has a structured career development program with 360° feedback, a wellbeing platform, and a multicultural distributed culture — signs of a maturing consultancy with employee retention in mind.
Watch For: No salary range is disclosed, which is a yellow flag — negotiate firmly given the niche Microsoft Fabric + Power Platform combination. Also note this is a client-embedded role; long-term career growth depends on Zartis's pipeline of follow-on projects after this engagement ends.
Zartis is a global AI transformation and technology consulting partner where talented engineers and technologists work on cutting-edge innovation. We partner with ambitious organizations to design, build, and scale technology solutions that deliver real impact.
Our teams bring deep expertise in AI-driven platforms, secure API architectures, and cloud-native engineering. You will work on meaningful projects that accelerate the adoption of advanced technologies — from strategy and discovery through to full product delivery — helping turn complex challenges into measurable outcomes.
With engineering hubs across EMEA and LATAM, and long-term partnerships in financial services, healthcare and life sciences, and energy and climate, we offer opportunities to work on projects that truly matter. Here, you will not just build technology — you will drive business impact and grow your career alongside industry leaders.
We are looking for a Senior Data Engineer to work on a project in the industrial engineering services industry.
The Project
You will join the client's small data team, working alongside one existing Power Platform/data engineer as a peer. The role combines Power Platform development (Power Apps, Power Automate, Power BI) with hands-on data engineering using Python, SQL, Azure Data Factory, and Microsoft Fabric.
The immediate priority is data ingestion: helping migrate and ingest data from a variety of sources into a Fabric medallion architecture (Bronze/Silver/Gold). Once this priority workload is established, focus will shift to broader work including CI/CD pipeline hardening, development standards, and best practices across the team's Power Platform and Fabric estate. This is a hands-on technical role where you'll work day-to-day alongside the existing engineer, sharing knowledge and contributing equally to delivery.
What You Will Do
- Design, build, and maintain pipelines to ingest and migrate data from a variety of sources (on-prem databases, APIs, flat files, line-of-business systems) into Microsoft Fabric.
- Implement and maintain Fabric medallion architecture (Bronze/Silver/Gold layers), structuring transformation logic for data quality and consistency.
- Write Python (e.g. PySpark, notebooks) and SQL for data transformation, cleansing, and modelling within Fabric Lakehouses and Warehouses.
- Build and orchestrate pipelines using Azure Data Factory and/or Fabric Data Factory.
- Develop and maintain Power Apps (canvas and model-driven) for operational engineering use cases.
- Build Power Automate flows that integrate with Azure services and Fabric data.
- Develop Power BI reports and dashboards consuming curated Fabric (Gold layer) data.
- Maintain and extend Dataverse tables, relationships, and security models.
- Contribute to hardening CI/CD pipelines for both Power Platform solutions and Fabric/data engineering code, using Azure DevOps.
- Help establish and document development standards, naming conventions, and code review practices.
- Support governance activities including environment strategy, DLP policies, and Fabric workspace/capacity management.
- Liaise with engineering stakeholders to understand requirements for data, automation, and reporting needs.
- Provide ongoing support and troubleshooting for existing pipelines, flows, and apps.
What You Will Bring
- Hands-on development experience across Power Apps, Power Automate, and Power BI.
- Strong working proficiency in Python and SQL for data transformation and pipeline development.
- Practical experience with Microsoft Fabric, including medallion architecture (Bronze/Silver/Gold), Lakehouses, and Dataflows Gen2.
- Experience with Azure Data Factory (or Fabric Data Factory) for orchestrating data ingestion and transformation pipelines.
- Experience migrating or ingesting data from diverse sources (databases, APIs, files, legacy systems) into a modern data platform.
- Solid understanding of Dataverse, including table design, security roles, and relationships.
- Experience working in an engineering, manufacturing, or industrial sector.
- Comfortable working collaboratively as part of a small team, sharing knowledge and reviewing peers' work.
- Familiarity with Azure DevOps for source control and release management.
Nice to Have
- Microsoft certifications (e.g. PL-400, PL-300, DP-600, or DP-700).
- Experience with PySpark notebooks in Microsoft Fabric.
- Knowledge of CI/CD pipelines for Power Platform and data engineering solutions.
- Exposure to Copilot Studio or AI Builder.
- Experience working with engineering, manufacturing, or industrial data.
- Understanding of IoT or sensor data integration.
What We Offer
- 100% Remote Work
- WFH Allowance: Monthly payment as financial support for remote working.
- Career Growth: An established career development program accessible to all employees, with 360° feedback to guide your career progression.
- Training: Dedicated time during the week for tech training, with access to online courses (Pluralsight, Educative.io), English classes, books, conferences, and events.
- Mentoring Program: Become a mentor, receive mentorship, or both.
- Zartis Wellbeing Hub (Kara Connect): A platform providing sessions with mental health professionals, nutritionists, physiotherapists, fitness coaches, and professional webinars.
- Multicultural Working Environment: Tech events, webinars, parties, and online team-building games and contests.
Frequently Asked Questions
Is this role fully remote or is office attendance required?
What are the main technologies I'll be working with?
Is a salary range available for this position?
What kind of team will I be joining?
Are Microsoft certifications required for this role?
