Data and AI Engineer (Mid-Level)

Socket.dev; Seattle (WA); On-site; USD 110,000 - 145,000; Full time

Benefits offered by this job

Employee stock ownership

Health insurance

401(k) with match

Paid vacation

Paid holidays

Paid parental leave

Wellness webinars

Mentorship program

Tuition reimbursement

Free parking

Job summary

Shannon & Wilson is seeking a Data Engineer to manage and evolve a new Microsoft-based data platform, enabling reliable data access for project delivery, reporting, and leadership insights. You will work across data ingestion, modeling, governance, and platform improvements from Seattle, WA.

The role emphasizes hands-on SQL, data modeling, and ETL/ELT work using Fabric, Synapse, and Azure Data Factory, with a strong focus on security and collaboration with analysts and IT staff.

Qualifications

• 7–14 years of experience with Microsoft data stack (Azure SQL, Data Factory, Synapse, Power BI or Fabric).
• Strong SQL development skills and data modeling (star/snowflake).
• Hands-on 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 for data transformation preferred.
• Knowledge of DevOps/Git-based version control for data pipelines preferred.
• Strong collaboration with project managers, analysts, and IT staff.
• Excellent troubleshooting and problem-solving skills.
• Continuous improvement mindset with willingness to learn new technologies.

Responsibilities

• Platform Operations & Maintenance: Administer Microsoft Fabric/Azure SQL and Power BI workspaces; ensure pipelines and notebooks run reliably.
• Data Engineering & Integration: Build and optimize ingestion from ERP and project systems; maintain clean data models.
• Governance & Security: Apply naming conventions, schema design, access control; ensure compliance.
• Continuous Improvement: Stay current with Fabric, Power BI, and Data Factory; propose automation and features.

Skills

SQL

Data modeling

ETL/ELT pipelines

Python

Spark

DevOps/Git

Collaboration

Troubleshooting

Communication

Continuous improvement

Education

Bachelor’s degree in Computer Science, Data Engineering, or related field

Tools

Microsoft Fabric

Azure Synapse

Azure Data Factory

Power BI

Azure SQL Database

Job description

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.