← Back to jobsJob ID col-cmvl8ta6201n2s3ct0qsl4iob

Artic ConsultingPosted 28 days ago

Data Engineer (Microsoft Fabric & AI)

Full-time
On-site
Mid level
$115K – $120K/yr
Posted 28 days ago

Artic Consulting is hiring a Data Engineer focused on Microsoft Fabric and application database management. The role designs and maintains scalable data solutions, including BI reporting, ETL/ELT workflows, data models, and secure data governance for clients.

Posted
28 days ago
Source
articconsulting.applytojob.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

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 in 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

Preferred

  • Experience debugging and optimizing advanced SQL queries, database objects, and legacy components
  • Ability to implement database security models and data protection policies
  • Expertise in implementing row-level security, dynamic data masking, and role-based access control within Microsoft Fabric and Power BI environments
  • Familiarity with Microsoft OneLake architecture, including data cataloging, lineage tracking, item-level security, and workspace-based access management
  • Proven ability to operate effectively in dynamic, client-facing environments, delivering scalable and compliant data solutions with a focus on performance and quality

Required skills

Data EngineeringData IntegrationDataflows Gen2Fabric NotebooksKQLMicrosoft Fabric Data PipelinesOneLakePL-300Power BIQuery OptimizationSpark/PySparkT-SQL

Full job description

Artic Consulting is hiring a Data Engineer focused on Microsoft Fabric and application database management. The role designs and maintains scalable data solutions, including BI reporting, ETL/ELT workflows, data models, and secure data governance for clients.

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

Preferred

  • Experience debugging and optimizing advanced SQL queries, database objects, and legacy components
  • Ability to implement database security models and data protection policies
  • Expertise in implementing row-level security, dynamic data masking, and role-based access control within Microsoft Fabric and Power BI environments
  • Familiarity with Microsoft OneLake architecture, including data cataloging, lineage tracking, item-level security, and workspace-based access management
  • Proven ability to operate effectively in dynamic, client-facing environments, delivering scalable and compliant data solutions with a focus on performance and quality
  • Advanced SQL
  • SQL Query Debugging
  • SQL Query Optimization
  • Database Objects
  • Legacy Components
  • Database Security Models
  • Data Protection Policies
  • Row-Level Security
  • Dynamic Data Masking
  • Role-Based Access Control
  • Power BI
  • Microsoft OneLake
  • Data Cataloging
  • Data Lineage Tracking
  • Item-Level Security
  • Workspace Access Management
  • Scalable Data Solutions
  • Compliant Data Solutions
  • Performance Optimization
  • Adaptability
  • Client-Facing Communication
  • Quality Focus

Benefits

  • Outstanding professional support and investment in your development.
  • Opportunity to learn from and be coached by supportive leaders and colleagues who can pass on their industry, technical and functional expertise.
  • Medical, dental, vision, and life insurance benefits.
  • 401k.
  • Vacation.
  • Annual review process.

Company

  • Business management consulting, custom application engineering, and data insights services.
  • Sammamish, Washington, USA
  • https://www.articconsulting.com/
  • Founded in 2018
  • 11-50 employees

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 in 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
  • Experience debugging and optimizing advanced SQL queries, database objects, and legacy components
  • Ability to implement database security models and data protection policies
  • Expertise in implementing row-level security, dynamic data masking, and role-based access control within Microsoft Fabric and Power BI environments
  • Familiarity with Microsoft OneLake architecture, including data cataloging, lineage tracking, item-level security, and workspace-based access management
  • Proven ability to operate effectively in dynamic, client-facing environments, delivering scalable and compliant data solutions with a focus on performance and quality

Required skills

  • Data Engineering, Data Integration, Dataflows Gen2, Fabric Notebooks, KQL, Microsoft Fabric Data Pipelines, OneLake, PL-300, Power BI, Query Optimization, Spark/PySpark, T-SQL

Experience

  • Mid level

Job details

Employment type

Full-time

Seniority level

Mid level

Date posted

Oct 23, 2026

Work mode

On-site

Job source

articconsulting.applytojob.com

Company

Artic Consulting

Information Technology & AI

Business management consulting, custom application engineering, and data insights services.

  • Sammamish, Washington, USA
  • Information Technology & AI
  • 11-50 employees
  • Founded 2018
  • articconsulting.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in Redmond

Lending

Today

New

Data Engineer

Full-timeOn-siteCoppell, TXCompetitive

RoundPoint Mortgage Servicing LLC is hiring a Data Engineer to develop and deliver data solutions and maintain its enterprise data warehouse.

Why similarSame roleData Engineering

LTM

4d ago

Senior Specialist - Data Engineering

Full-timeOn-siteBellevue, WACompetitive

LTIMindtree is seeking a Technical Program Manager to lead strategic marketing programs for personalized, data-driven customer engagement.

Why similarSame rolePower BIBellevue

Woven by Toyota

Today

New

Software Engineer II, Data Labeling

Full-timeHybridAnn Arbor, MICompetitive

Woven by Toyota is enabling Toyota’s transformation into a mobility company through autonomous driving, software-defined vehicles, mobility infrastructure, and cloud and AI technologies.

Why similarSame roleData Engineering

Get new Data Engineer jobs in Redmond by email

Create job alert

Data Engineer (Microsoft Fabric & AI)

Artic Consulting · $115K – $120K/yr

Apply on company site