Shawmut Design and Construction · 1 week ago
Sr. Data & Analytics Engineer
US-MA-Boston
Full-time
Onsite
Mid, Senior Level
$125K/yr - $175K/yr
5+ years expShawmut Design and Construction is a 100% employee-owned company recognized for its workplace culture. The Senior Data & Analytics Engineer focuses on transforming project, financial, and operational data to enable real-time insights for project teams and executives.
Construction
Responsibilities
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
Qualification
Required
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
Education: bachelor's degree in computer science, data science, engineering, or related field required
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
Strong problem-solving skills, and the ability to think critically and analytically
Knowledge of ETL processes, data integration, and data warehousing concepts
Excellent communication skills to effectively collaborate with cross-functional teams and present insights to business stakeholders
Preferred
Experience with construction industry data and project-based analytics is desired
Experience with Apache Spark or Databricks
Familiarity with construction ERP system (CMiC), HCM (Workday), and CRM (Dynamics) integrations
Familiarity with data visualization tools such as Power BI
Benefits
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.
Company
Shawmut Design and Construction
At Shawmut Design and Construction, we promise our clients a better building experience.
1001-5000 employees
H1B Sponsorship
Shawmut Design and Construction has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2022 (2)
2020 (3)
Funding
Current Stage
Late StageLeadership Team
Reza Amirkhalili
Chief Operating Officer
Bianca Terenzi, MBA
Human Resources Business Partner
Recent News
Company data provided by crunchbase