Be an Early Applicant
Articulating Business Goals into Successful Solutions while building our team.
The Role
The Senior Data Engineer will design and implement scalable data solutions, focusing on Power BI, ETL workflows, and data modeling using the Microsoft Fabric ecosystem.
Summary Generated by Built In
Overview :
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 skilled Data Engineer with a strong focus on the Microsoft Fabric ecosystem, who can design and implement scalable data solutions for our clients.
Key Responsibilities:
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 skilled Data Engineer with a strong focus on the Microsoft Fabric ecosystem, 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.
- Bachelor's or master's degree in computer science, Information Systems, or related field.
- Minimum 3 years of 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.
- Work with cutting-edge Microsoft technologies in a dynamic and collaborative environment.
- Flexible work culture with opportunities for growth and certifications.
- Be part of a mission to deliver impactful digital transformation for clients globally.
Top Skills
Azure Data Factory
Azure Functions
Dax
Kql
Logic Apps
Microsoft Fabric
Power BI
Powershell
Pyspark
Spark
SQL Server
T-Sql
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Artic is passionate about people and impact, delivering global consulting services that provide solutions by understanding the business need, pulling an incredible team together, then executing and delivering amazing results. Currently, Artic specializes in Business Management Services, Custom Application and Systems Engineering, and Data and Business Insights.
