Consigli Construction

Consigli Construction

Senior Data Engineer

Milford, Massachusetts, United States · Senior · Full-time

Sponsorship not specified$100k-$120kDetected 27 days ago
PythonSQLDatabricksAzureCI/CDMachine LearningData EngineeringCybersecurityIncident ResponseCRMERPHRISCommunicationCollaborationProblem SolvingCritical Thinking

About the role

  • Help refactor business logic from dashboards or ad‑hoc SQL into governed transformations and reusable metrics.
  • Contribute to scaling master data domains (Project, Vendor, Budget, People, etc.) and stewarding data definitions.
  • Participate in defining SLAs, tracking reliability, and executing incident response playbooks.

Responsibilities

  • The Senior Data Engineer supports the design, build, and optimization of our analytical data environment, including pipelines, semantic models, data quality controls, and governed access patterns.
  • / Essential Functions Data Platform & Architecture Support Contribute to the design and evolution of Consigli's lakehouse architecture (Databricks, Azure, Fabric).
  • Support ingestion, transformation, and serving patterns across Databricks notebooks, Empower and related tools.
  • Maintain environments, workspaces, and CI/CD patterns with guidance from senior technical leaders.
  • Data Modeling & Semantic Layer Support the development and maintenance of subject-area models, conformed dimensions, and governed metrics used across reporting and dashboards.
  • Partner with business and project teams to align and standardize KPIs for cost, schedule, risk, and operational reporting.
  • Pipelines, Quality & Reliability Build, maintain, and document pipelines and datasets that are versioned, code-reviewed, and tested.
  • Implement data validation rules, anomaly detection (rule-based or ML-assisted), monitoring, and error-handling procedures.
  • Governance, Security & Compliance Assist with applying data classification, masking, access controls, and privacy-by-design principles.
  • Partner with security and platform teams to support compliance audits and maintain documentation.

Requirements

  • 5+ years in data architecture, data engineering, analytics engineering, or a similar development role within a modern cloud environment.
  • Experience with Databricks, MS Fabric, Delta Lake, or similar platforms.
  • Experience with CLI's and AI-assisted workflows (Claude desktop, Databricks Genie, or equivalent) Familiarity with enterprise systems such as Sage 300/CMiC (ERP), Workable/SagePeople (HRIS), and Cosential/Unanet (CRM) is a plus.
  • Required Experience 5+ years in data architecture, data engineering, analytics engineering, or a similar development role within a modern cloud environment.

Nice to have

  • Experience with construction or project-based analytics is a plus.

Skills

  • Technical Skills Strong SQL and Python skills.
  • Proficiency with Azure-based tools (Data Factory, Fabric/Lakehouse, OneLake) or Databricks equivalents.
  • Deep understanding of data lineage, cataloging, governance, data quality frameworks, and security best practices.
  • Professional Skills Excellent communication skills with the ability to translate complex technical concepts for business teams.
  • Strong critical thinking, problem-solving, and analytical abilities.

Compensation

  • $100,000 - $120,000 Consigli is strengthening its Data & Analytics capabilities to provide reliable, real‑time, and predictive insights to project teams and business leaders.
Apply directly at Consigli Construction →Create a free account for alerts like thisView Consigli Construction immigration profile

This listing is sourced directly from Consigli Construction's careers page and normalized into a canonical job model.