Data and AI Engineer (Mid-Level)

Description

Shannon & Wilson is a leading geotechnical engineering firm dedicated to delivering innovative solutions in infrastructure, transportation, and environmental projects. As part of our digital transformation journey, we are investing in modern data platforms and analytics capabilities to support better decision-making and operational excellence.

Job Summary:

We are seeking a Data Engineer to manage, optimize, and evolve our new Microsoft-based data platform (Microsoft Fabric, Azure SQL, Power BI, etc.). This role will be instrumental in ensuring that our engineers, supporting staff, and leadership have reliable, trusted access to data for project delivery, reporting, and strategic insights.

Responsibilities:

Platform Operations & Maintenance

- Administer and monitor Microsoft Fabric (or Azure Synapse/Lakehouse), Azure SQL Databases, and Power BI workspaces.

- Ensure data pipelines, notebooks, and scheduled refreshes run reliably and on time.

- Implement monitoring, alerting, and cost optimization strategies for the platform.

Data Engineering & Integration

- Build, maintain, and optimize ingestion pipelines from internal systems (ERP, project management software) and external data sources.

- Design and maintain clean, curated data models to support reporting and analytics needs.

- Collaborate with business analysts to ensure data structures meet business requirements.

Governance & Security

- Apply data governance standards for naming conventions, schema design, and access control.

- Work with IT to enforce security policies, manage permissions, and ensure compliance with client and regulatory requirements.

Continuous Improvement

- Stay current with Microsoft’s data platform capabilities (Fabric, Power BI, Azure Data Factory, etc.).

- Recommend new features, automation, or process improvements to enhance reliability and usability.

- Partner with stakeholders to identify and implement new use cases for analytics and reporting.

Requirements

• Bachelor’s degree in Computer Science, Data Engineering, or related field (or equivalent experience).
• 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) required.
• Hands-on experience with ETL/ELT pipelines and automation scheduling required.
• 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 (projects, cost, schedule) 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 (both technical and business-oriented).

Level Placement:

Typically, depending on an applicant’s education, experience, other qualifications they possess, if they are a fit for the company and local office culture, and the current business needs, a Mid-Level Data Engineer typically would be placed at a Shannon & Wilson Senior Professional I, II, or III level with annual compensation ranging from $110,000 - $145,000.

Shannon & Wilson is committed to providing a comprehensive total rewards package that includes the following benefits:

• Employee stock ownership
• Medical, prescription, vision, dental, long-term care and life insurance plans are offered to employees (and their families).
• Pre-tax health and daycare FSA
• Profit sharing and 401(k) plans with annual safe-harbor contributions
• 10 - 20 paid vacation days per year for full-time employees, based on years of experience (prorated for part-time employment)
• Sick leave accrues based on state requirements
• 9 paid holidays per year + 1 personal holiday
• Paid volunteer day
• Paid time off for bereavement and jury duty
• Two weeks of paid parental leave
• Lunch & Live wellness webinars and an Employee Assistance Program
• Mentorship Program
• Tuition Reimbursement
• Free parking

Shannon & Wilson is an Equal Opportunity Employer

Shannon & Wilson participates in the E-Verify program.

Please note that non-solicited resumes from external recruitment agencies will not be considered as introductions to our business, unless a preapproved agreement is in place and the external recruitment agency has been engaged to work on this specific vacancy.