Consultant Data Engineer (Microsoft Fabric & AI)

Artic Consulting; Redmond (WA); Presencial; USD 115.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

401k

Vacation

Annual review

Descripción de la vacante

Artic Consulting, Inc. is seeking a Data Engineer to design and implement scalable data solutions within the Microsoft Fabric ecosystem. The role focuses on Power BI reporting, ETL/ELT pipelines, and advanced SQL/KTQL queries across Fabric, Synapse SQL, and SQL Server environments.

You will integrate diverse data sources, build modern data models, and ensure governance and security policies are adhered to. This position is based in Redmond, WA, with a strong emphasis on performance, reliability,

Formación

• Bachelor's degree in computer science, information systems, engineering, or equivalent 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 certifications.

Responsabilidades

• Design, develop, and maintain Power BI reports, dashboards, KPIs, and scorecards.
• Build and orchestrate ETL/ELT workflows using Fabric Data Pipelines and Azure Data Factory.
• Write and tune T-SQL and KQL queries for performance in Synapse SQL and SQL Server.
• Implement star/snowflake data models and modern Data Warehousing/Lakehouse architectures with Fabric.
• Integrate structured and unstructured data sources and transform them using Fabric notebooks or Dataflows.
• Diagnose and resolve pipeline failures and performance bottlenecks across the lifecycle.
• Automate data processes using Azure Functions, Logic Apps, PowerShell, or Python in Fabric.
• Collaborate with stakeholders to translate requirements into scalable data solutions.
• Ensure data governance, privacy, and compliance standards are followed.

Herramientas

Power BI

Data Pipelines Gen2

Dataflows Gen2

OneLake

Notebooks

Azure Data Factory

Spark/PySpark

SQL Server

KQL

Descripción del empleo

About us:

Artic Consulting is a dynamic IT and consulting services firm, delivering digital transformation through innovative solutions in data, cloud, and business analytics. We are seeking a skilledData Engineerwith a strong focus on theMicrosoft Fabric ecosystemand Application Databasemanagement, who can design and implement scalable data solutions for our clients.

Key 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.

Required 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 Skills:

• 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.

Equal Employment Opportunity

Artic Consulting is an EEO and Affinitiive Action Employer of Females/Minorities/Veterans/Individuals with Disabilities.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

Artic is committed to providing veteran employment opportunities to our service men and women.

Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring.

Benefits

Join Artic and you will benefit from outstanding professional support and investment in your development. You will have the opportunity to learn from and be coached by the best in the business – supportive leaders and colleagues who can pass on their industry, technical and functional expertise.This also includes medical, dental, vision, and life insurance benefits, 401k,vacation,and annual review process.

Budget Range

Salary Range: $115,000–$120,000 USD annually (depending on experience, skills, location, and qualifications).