Sr. Data & Analytics Engineer at First Finish | A Shawmut Company in Boston, MA | Kablio

Role

Description

data pipelines

data architecture

data modeling

performance optimization

data quality

stakeholder collaboration

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

Requirements

python

sql

power bi

azure

spark

bachelor’s

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

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Founded with a mission to deliver high-quality construction services in a variety of sectors.
Focuses on interior and exterior finishing for both large-scale commercial and residential projects.
Experienced in the design and construction of multifamily housing, schools, healthcare facilities, and more.
Specializes in detailed craftsmanship, working on everything from drywall installation to flooring and cabinetry.
Offers innovative solutions to complex projects with a commitment to quality and efficiency.
Has worked with top-tier clients across the nation, contributing to notable infrastructure and commercial projects.
Known for their ability to tackle both large and small-scale projects with precision and excellence.

Culture + Values

We are a team that works together and collaborates with a shared goal.
Our values drive our approach to delivering quality work and building long-term relationships.
We are committed to the highest level of service, integrity, and responsibility.
Safety and quality are at the core of everything we do.
We value innovation and continuous improvement.

Environment + Sustainability

2050

Net Zero Emissions Target

The company aims to achieve net zero carbon emissions by 2050.

Commitment to reducing energy consumption across operations.
Implementing sustainable construction practices to minimize environmental impact.
Focusing on waste reduction through recycling and reusing materials.

Inclusion & Diversity

Articles

Role

Description

data pipelines

data architecture

data modeling

performance optimization

data quality

stakeholder collaboration

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

Requirements

python

sql

power bi

azure

spark

bachelor’s

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

Benefits

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

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found