Sr. Data & Analytics Engineer

At Shawmut Design and Construction, we take pride in the culture we’ve built as a 100% employee-owned company—one that’s been recognized with more than 85 Best Place to Work awards. We’ve been honored as a National Fortune Best Workplace, a Fortune Best Workplace for Women, Millennials, and Parents, and one of America’s Best Employers by Forbes—along with numerous regional recognitions across our 11 offices nationwide.

Here’s a glimpse into what we offer:

• Health, Dental, and Vision Insurance.
• Employee Stock Ownership Plan (ESOP) – Be an employee-owner!
• 401(K) with Company Match – Receive a company match up to 4% of your eligible pay.
• Generous Paid Time Off – vacation and sick time, 12 holidays, summer Fridays, and a yearly volunteer day.
• The Extras – Cell phone, laptop, tuition reimbursement, pet insurance, financial planning services, and more.

The Senior Data & Analytics Engineer focuses on ingesting and transforming project, financial, and operational data for construction projects. Designs and maintains pipelines and models within Microsoft Fabric ecosystem (Data Factory, Notebooks, Lakehouse, Power BI) to enable real-time insights for project teams and executives.

• Delivers well-defined, transformed, tested, documented, and code-reviewed datasets for analysis
• Designs the structure and layout of data systems, including databases, warehouses, and lakes
• Builds and optimizes pipelines using Azure Data Factory, Fabric Pipelines and Notebooks
• Creates robust data models and architectures to support analytics initiatives
• Collaborates with business stakeholders to understand their analytics needs and deliver comprehensive models and datasets
• Defines and manages standards, guidelines, and processes to ensure data quality
• Identifies and implements optimizations to continually enhance query performance, reduce processing time, and increase overall productivity
• Designs, develops and maintains data pipelines to ensure efficient and reliable ETL processes
• Collaborates with project teams to standardize KPIs for cost, schedule, and risk
• Ensures data quality and accuracy by implementing data validation, monitoring, and error-handling processes

• Experience: A minimum of 5 years of experience in data analytics, data engineering, software engineering, or a similar role.
  • Expertise in data modeling, ETL development, and data analysis
  • Experience with construction industry data and project-based analytics is desired
  • Experience with Apache Spark or Databricks
• Education: bachelor’s degree in computer science, data science, engineering, or related field required.
• Additional Role Specific Skills:
  • Strong ability in SQL for data extraction and manipulation, and proficiency in data warehousing concepts/tools specifically Microsoft Fabric components (Data Factory, Lakehouse, OneLake)
  • Familiarity with Azure-based data platforms for data storage and processing
  • Substantial programming ability using languages/tools such as Python, Scala, SQL for data manipulation and scripting
  • Solid understanding of relevant data governance, data quality, and data security best practices
  • Familiarity with construction ERP system (CMiC), HCM (Workday), and CRM (Dynamics) integrations
  • Strong problem-solving skills, and the ability to think critically and analytically
  • Knowledge of ETL processes, data integration, and data warehousing concepts
  • Familiarity with data visualization tools such as Power BI
  • Excellent communication skills to effectively collaborate with cross-functional teams and present insights to business stakeholders

Shawmut prohibits discrimination against any staff member or applicant on the basis of race, color, sex, sexual orientation, gender identity/expression, age, religion, national origin, marital status, veteran status, pregnancy, physical or mental disability, genetic information, disability, creed, citizenship status, or any other legally protected characteristic.

Boston Base Salary Range: $125,000 - $175,000 The range stated is specific to Boston.  Placement within the listed range depends on many factors including, but not limited to years of experience, project size capability (for Construction & Field roles) and internal company equity.