> Markdown version of [/jobs/ext/2638082-data-and-ai-engineer-mid-level](https://www.wearedevelopers.com/jobs/ext/2638082-data-and-ai-engineer-mid-level). 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).

---

# Data and AI Engineer (Mid-Level)

- **Company:** Shannon& Wilson
- **Location:** Seattle, WA, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Artificial Intelligence, Cloud Database, Databases, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Structures, DevOps, Python (Programming Language), Microsoft Data Access Components, SQL Azure, Power BI, Standard Sql, Data Ingestion, Azure Data Factory, Apache Spark, Git, Microsoft Fabric, Data Analytics, Star Schema, Data Management, Azure Synapse Analytics, Software Version Control, Data Pipelines
- **Published:** August 7, 2026
- **Apply:** https://us.experteer.com/career/view-jobs/data-and-ai-engineer-mid-level-seattle-wa-usa-58854858

## About the Role

business and analytics * Collaborate with business analysts to ensure data structures meet requirements * Apply data governance standards for naming conventions, schema design, and access control * Work with IT to enforce security policies, manage permissions, and ensure regulatory compliance * Stay current with Microsoft data platform capabilities and advocate improvements * Partner with stakeholders to identify and implement new analytics use cases Tasks * 7 to 14 years of experience with Microsoft data stack (Azure SQL Database, Azure Data Factory, Synapse, Power BI, or Fabric) * Strong SQL development skills and experience with data modeling (star/snowflake schema) * Hands-on experience with ETL/ELT pipelines and automation scheduling * Familiarity with cloud-based data security and access control practices * Experience with Microsoft Fabric Lakehouse and Mirrored Databases preferred * Familiarity with engineering or construction industry data preferred * Python or Spark experience
for data transformation preferred * Knowledge of DevOps/Git-based version control for data pipelines preferred * Strong collaboration skills - able to work with project managers, analysts, and IT staff * Excellent troubleshooting and problem-solving skills * Continuous improvement mindset with willingness to learn and adopt new technologies * Clear communication skills (technical and business-oriented) Key requirements * Employee stock ownership * Medical, prescription, vision, dental, long-term care and life insurance * Pre-tax health and daycare FSA * Profit sharing and 401(k) with annual safe-harbor contributions * Paid vacation days per year * 9 paid holidays + 1 personal holiday

## Description

Experteer Overview As a Data Engineer, you will manage and evolve Shannon & Wilson's Microsoft-based data platform to provide reliable access to data for project delivery and leadership insights. You'll work within a digital transformation context, ensuring robust pipelines and trusted analytics for engineers, staff, and decision-makers. This role blends platform operations, data engineering, and governance to enable data-driven decisions in infrastructure projects. You will partner with cross-functional teams to advance analytics and usability of data platforms. Compensation / Benefits * Administer and monitor Microsoft Fabric/Azure Synapse, Azure SQL, and Power BI workspaces * Ensure data pipelines, notebooks, and scheduled refreshes run reliably and on time * Implement monitoring, alerting, and cost optimization for the platform * Build, maintain, and optimize ingestion pipelines from internal and external data sources * Design and maintain clean, curated data models to support reporting and analytics * Collaborate with business analysts to ensure data structures meet requirements * Apply data governance standards for naming conventions, schema design, and access control * Work with IT to enforce security policies, manage permissions, and ensure regulatory compliance * Stay current with Microsoft data platform capabilities and advocate improvements * Partner with stakeholders to identify and implement new analytics use cases Tasks * 7 to 14 years of experience with Microsoft data stack (Azure SQL Database, Azure Data Factory, Synapse, Power BI, or Fabric) * Strong SQL development skills and experience with data modeling (star/snowflake schema) * Hands-on experience with ETL/ELT pipelines and automation scheduling * Familiarity with cloud-based data security and access control practices * Experience with Microsoft Fabric Lakehouse and Mirrored Databases preferred * Familiarity with engineering or construction industry data preferred * Python or Spark experience for data transformation preferred * Knowledge of DevOps/Git-based version control for data pipelines preferred * Strong collaboration skills - able to work with project managers, analysts, and IT staff * Excellent troubleshooting and problem-solving skills * Continuous improvement mindset with willingness to learn and adopt new technologies * Clear communication skills (technical and business-oriented) Key requirements * Employee stock ownership * Medical, prescription, vision, dental, long-term care and life insurance * Pre-tax health and daycare FSA * Profit sharing and 401(k) with annual safe-harbor contributions * Paid vacation days per year * 9 paid holidays + 1 personal holiday


## Related Videos

- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [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)
- [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)
- [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews)

## Related Articles

- [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift)