Data Engineer
About The Position
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.
Requirements
- Bachelor’s degree in Computer Science, Data Engineering, or related field (or equivalent experience).
- Must have 3+ 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.
- 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).
Nice To Haves
- 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.
Responsibilities
- 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.
- 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.
- 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.
- 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.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Number of Employees
101-250 employees
