Senior Data Engineer — Fabric, AI & Data Pipelines

Artic Consulting; Redmond (WA); On-site; USD 115,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401k

Vacation and annual review

Job summary

Artic Consulting seeks a skilled Data Engineer specializing in the Microsoft Fabric ecosystem to design scalable data solutions and modern data platforms in Redmond, WA. You will build Power BI reports, orchestrate Fabric-based ETL/ELT pipelines, and optimize T-SQL/KQL across Synapse SQL environments.

The role emphasizes data governance, privacy, and compliance, with hands-on work on notebooks, dataflows Gen2, and OneLake.

Qualifications

• Bachelor's degree or equivalent professional experience in CS/IS/Engineering.
• Strong Power BI development and data engineering experience.
• Expertise in T-SQL and KQL with query optimization skills.
• Proficiency with Microsoft Fabric tools: Data Pipelines Gen2, OneLake, Notebooks.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, KPIs, and scorecards.
• Build ETL/ELT workflows using Fabric Data Pipelines, Dataflows Gen2, and Azure Data Factory.
• Write and optimize complex T-SQL and KQL queries for Synapse SQL and SQL Server.
• Model data with star/snowflake schemas for modern data warehousing and Lakehouse architectures.
• Integrate structured and unstructured data sources and transform with Fabric Notebooks or Dataflows.
• Diagnose pipeline failures and optimize performance across the data lifecycle.
• Automate repetitive data processes using Azure Functions, Logic Apps, or Python within Fabric.
• Collaborate with stakeholders to translate requirements into scalable data solutions.
• Ensure data governance, privacy, and compliance including data lineage and security.

Skills

Power BI development

Data engineering

T-SQL

KQL

Spark/PySpark

Data integration

Education

Bachelor's degree in computer science, information systems, engineering, or equivalent

Tools

Microsoft Fabric tools: Data Pipelines Gen2

OneLake

Fabric Notebooks

Job description

Artic Consulting seeks a skilled Data Engineer specializing in the Microsoft Fabric ecosystem to design scalable data solutions and modern data platforms in Redmond, WA. You will build Power BI reports, orchestrate Fabric-based ETL/ELT pipelines, and optimize T-SQL/KQL across Synapse SQL environments.

The role emphasizes data governance, privacy, and compliance, with hands-on work on notebooks, dataflows Gen2, and OneLake.