Senior Data Engineer — Microsoft Fabric & AI

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

Job summary

Artic Consulting, Inc. is seeking a skilled Data Engineer to design and implement scalable data solutions within the Microsoft Fabric ecosystem. You will focus on Data Pipelines, Dataflows Gen2, and integration with SQL Server and Synapse.

This role emphasizes Power BI development, T-SQL/KQL, and building modern data warehouses and lakehouse architectures. Collaboration with clients and governance are essential.

Qualifications

• Bachelor's degree in computer science, information systems, engineering, or equivalent professional experience.
• Strong experience in Power BI development and data engineering.
• Strong expertise in T-SQL and KQL, with demonstrated query optimization skills.
• Proficiency with Microsoft Fabric tools: Data Pipelines, Dataflows Gen2, OneLake, Notebooks.
• Hands-on experience with Spark/PySpark and data integration from varied sources.
• Microsoft Power BI certification (PL-300) or equivalent Microsoft certifications.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, DAX expressions, KPIs, and scorecards using both Import and Direct Query modes.
• Build and orchestrate scalable ETL/ELT workflows using Fabric Data Pipelines, Dataflows Gen2, and Azure Data Factory.
• Write and tune complex T-SQL and KQL queries, stored procedures, and views for performance in Synapse SQL and SQL Server environments.
• Implement data models based on star/snowflake schemas and support modern data warehousing and Lakehouse architectures using Microsoft Fabric.
• Integrate structured and unstructured data sources (e.g., SQL, Excel, APIs, Blob Storage), and transform them efficiently using Fabric Notebooks (Spark/PySpark) or Dataflows.
• Diagnose and resolve pipeline failures, logic errors, and performance bottlenecks across the data engineering lifecycle.
• Automate repetitive data processes using Azure Functions, Logic Apps, PowerShell, or Python scripting within the Fabric ecosystem.
• Collaborate with stakeholders to gather business requirements and translate them into scalable data solutions.
• Ensure data governance, privacy, and compliance standards (e.g., GDPR, HIPAA, ISO) are adhered to, including sensitive data handling policies.
• Apply best practices for item-level security, workspace-based access models, and data lineage using Microsoft One Lake and Fabric tools.

Skills

Power BI development

Data engineering

T-SQL

KQL

Query optimization

Spark/PySpark

Education

Bachelor's degree in CS/IS/Engineering

Tools

Data Pipelines (Fabric)

Dataflows Gen2

OneLake

Notebooks

Job description

Artic Consulting, Inc. is seeking a skilled Data Engineer to design and implement scalable data solutions within the Microsoft Fabric ecosystem. You will focus on Data Pipelines, Dataflows Gen2, and integration with SQL Server and Synapse.

This role emphasizes Power BI development, T-SQL/KQL, and building modern data warehouses and lakehouse architectures. Collaboration with clients and governance are essential.