Principal Microsoft Data & AI Engineer :: Minneapolis, MN strongly preferred; Chandler, AZ; Irving, TX; Charlotte, NC (Hybrid - 3 days onsite / 2 days remote)

Title: Principal Microsoft Data & AI Engineer

Location: Minneapolis, MN strongly preferred; Chandler, AZ; Irving, TX; Charlotte, NC



Work Model: Hybrid 3 days onsite / 2 days remote



Experience: 7+ years

LinkedIn must be 5-6 years old

Position Summary

Seeking a senior, hands-on Principal Microsoft Data & AI Engineer with strong expertise in Microsoft SQL Server, Microsoft Fabric, data engineering, data wrangling, analytical modeling, and generative AI tools .

The role focuses on designing and delivering trusted data products for workforce analytics, operational reporting, executive decision-making, and AI-assisted analysis.

Core Platforms

• Microsoft SQL Server
• Microsoft Fabric
• Azure
• Power BI
• Microsoft Excel
• Databricks expected Q1 2027

Primary Responsibilities

• Design, build, test, deploy, and support scalable data ingestion, transformation, and integration solutions using SQL Server and Microsoft Fabric.
• Develop reusable ETL/ELT pipelines for governed analytical data stores and semantic models.
• Write and optimize advanced SQL, including complex queries, stored procedures, views, and performance-tuned processes.
• Design relational, dimensional, semantic, and analytical data models.
• Apply repository-driven standards and Medallion methodology to create governed, analytics-ready data assets.
• Integrate structured, semi-structured, and unstructured data from databases, Excel, CSV files, email-delivered files, APIs, exported reports, and authorized web sources.
• Develop validation, reconciliation, traceability, and error-handling processes for nonstandard data sources.
• Perform data profiling, validation, reconciliation, and data quality analysis.
• Build curated datasets and semantic models for Power BI, Excel, analysts, and approved AI tools.
• Use approved generative AI tools for data analysis, SQL/code development, documentation, testing, and troubleshooting.
• Validate AI-generated SQL, code, calculations, summaries, and analytical conclusions.
• Translate business requirements into technical designs and usable data products.
• Follow data governance, privacy, security, risk, and compliance requirements.

Required Qualifications

• 7+ years of experience in data engineering, database engineering, analytics engineering, data integration, or related fields.
• Advanced hands-on Microsoft SQL Server and complex SQL development experience.
• Experience designing and delivering ETL/ELT pipelines.
• Hands-on Microsoft Fabric experience or strong experience with a comparable modern cloud data platform.
• Strong knowledge of relational, dimensional, semantic, and analytical data modeling.
• Experience with repository-driven enterprise data modeling and Medallion methodology.
• Experience integrating data from Excel, files, APIs, email-delivered data, exported reports, and authorized web sources.
• Strong data profiling, validation, reconciliation, and data quality experience.
• Advanced Excel skills, including Power Query, Data Models, PivotTables, advanced formulas, and external data connections.
• Experience preparing data for Power BI, Excel, analysts, or AI-assisted analytical workflows.
• Working knowledge of source control, code review, testing, release management, and production support.
• Strong communication skills and ability to explain technical concepts to nontechnical stakeholders.
• Ability to work independently and manage ambiguity in a complex enterprise environment.

AI Experience

Experience with AI-assisted engineering or productivity tools such as:

• Microsoft 365 Copilot
• GitHub Copilot
• Claude Code
• Microsoft Cowork
• Devin
• Visual Studio Code with approved AI extensions
• Other enterprise-approved LLM tools

Experience should include:

• Prompt development for data discovery, analysis, SQL generation, testing, documentation, and result interpretation.
• Providing schema context, definitions, examples, constraints, and expected output formats.
• Validating AI-generated SQL, calculations, code, summaries, and conclusions.
• Identifying hallucinations, unsupported conclusions, incorrect assumptions, and data leakage risks.
• Creating reusable prompt templates or AI-assisted workflows.

Preferred Qualifications

• Microsoft Fabric Lakehouse, Warehouse, Data Factory, Dataflows Gen2, notebooks, or semantic models.
• Azure SQL, Azure Data Lake Storage, Azure Data Factory, or related Azure services.
• Python, PySpark, PowerShell, or similar data transformation and automation languages.
• Power BI, including semantic models, DAX, Power Query, performance optimization, and executive reporting.
• Power Apps or Power Automate.
• Databricks, Delta Lake, Spark, Medallion Architecture, or comparable lakehouse experience.
• Experience supporting traditional BI and AI-based analysis.
• Experience with APIs, JSON, XML, HTML parsing, browser automation, or approved web data extraction.
• Experience working with confidential or sensitive data in a regulated environment.
• GitHub, Azure DevOps, ServiceNow, CI/CD, or automated testing experience.

Skill Priority

1. Microsoft SQL Server & Advanced SQL
2. Microsoft Fabric & Modern Data Engineering
3. Enterprise Data Modeling & Medallion Methodology
4. ETL/ELT, Data Integration & Data Quality
5. AI-Assisted Development & Prompt Engineering
6. Advanced Microsoft Excel
7. Power BI
8. Azure Data Services
9. Power Apps / Power Automate
10. Databricks

Akshit Sisonia - Sr. Technical Recruiter

Email - View email address on us.fitly.work

LinkedIn - linkedin.com/in/akshit-s-97297125a

STELLENT IT A Nationally Recognized Minority Certified Enterprise

" Happiness can be found, even in the darkest of times, if one only remembers to turn on the light ."
- JK Rowling