> Markdown version of [/jobs/ext/2843454-principal-microsoft-data-ai-engineer](https://www.wearedevelopers.com/jobs/ext/2843454-principal-microsoft-data-ai-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Principal Microsoft Data & AI Engineer

- **Company:** American CyberSystems
- **Location:** Minneapolis, MN, United States
- **Salary:** $166,400.0 - $187,200.0
- **Contract:** Permanent contract
- **Skills:** HTML, Microsoft Excel, Application Programming Interfaces (APIs), Artificial Intelligence, Data Analysis, Automation of Tests, Microsoft Azure, Databases, Continuous Integration, Extract Transform Load (ETL), Data Transformation, Data Mining, Database Queries, Github, JSON, Python (Programming Language), Microsoft Data Access Components, Microsoft SQL Server, SQL Azure, Parsing, Performance Tuning, Windows PowerShell, Power BI, Azure Data Lake, SQL Stored Procedures, SQL Databases, Unstructured Data, Extensible Markup Language (XML), Data Ingestion, Microsoft Power Automate, Azure Data Factory, Sql Optimization, Apache Spark, Powerquery, Microsoft Fabric, Data Lakes, Pyspark, Enterprise Integration, Data Pipelines, Powerapps, Databricks
- **Published:** September 11, 2026
- **Apply:** https://public-rest34.bullhornstaffing.com/rest-services/2WXP1S/query/JobBoardPost?where=id=1024231&fields=id,title,publishedCategory(id,name),address(city,state),employmentType,dateLastPublished,publicDescription,isOpen,isPublic,isDeleted

## About the Role

* Experience in Microsoft Fabric Lakehouse, Warehouse, Data Factory, Dataflows Gen2, notebooks, semantic models.
 * Experience in Azure SQL, Azure Data Lake Storage, Azure Data Factory.
 * Experience with Python, PySpark, PowerShell, or other data transformation/automation languages.
 * Experience with Power BI (semantic models, DAX, Power Query, performance optimization, executive reporting).
 * Experience with Power Apps / Power Automate.
 * Experience with Databricks, Delta Lake, Spark, Medallion architecture, or comparable lakehouse experience.
 * Experience supporting both BI and AI?based analysis.
 * Experience in APIs, JSON, XML, HTML parsing, browser automation, or web data extraction.
 * Experience with confidential/sensitive data in regulated environments.
 * Experience with GitHub, Azure DevOps, CI/CD, automated testing.

## Description

Principal Microsoft Data & AI Engineer, You will:

 * Design, build, test, deploy, and support scalable data ingestion, transformation, and integration solutions using Microsoft SQL Server and Microsoft Fabric.
 * Develop reusable ETL/ELT pipelines for governed analytical data stores and semantic models.
 * Write and optimize advanced SQL (complex queries, stored procedures, performance?tuned routines).
 * Design relational, dimensional, semantic, and analytical data models supporting Power BI, Excel, and AI?assisted analysis.
 * Integrate structured, semi?structured, and unstructured data from diverse sources (databases, Excel, APIs, reports, web?based inputs).
 * Profile data, identify quality issues, and implement remediation or monitoring controls.
 * Build curated, analysis?ready datasets and semantic models for analysts and AI tools.
 * Use approved generative AI tools to assist with SQL/code development, documentation, testing, and troubleshooting.
 * Validate AI?generated outputs to ensure accuracy and compliance.
 * Translate business needs into clear technical designs and usable data products.
 * Follow applicable governance, privacy, security, risk, and compliance requirements.


## Related Videos

- [The Resilience of the World Wide Web](https://www.wearedevelopers.com/videos/1281-the-resilience-of-the-world-wide-web)
- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [NoLoJS - Avoiding JavaScript Cruft with HTML and CSS - Aaron T. Grogg](https://www.wearedevelopers.com/videos/1806-nolojs-avoiding-javascript-cruft-with-html-and-css-aaron-t-grogg)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)
- [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)