Senior Data Engineer

Location: Providence, RI (onsite). Salary: USD 100,000 - 120,000 per year. Experience: 5+ years. This onsite Senior Data Engineer role at Consigli Construction offers a hands-on opportunity to shape the organization’s analytical data environment and governance practices.

Responsibilities

• Contribute to the evolution of the lakehouse architecture using Databricks, Azure, and Fabric.
• Support ingestion, transformation, and serving patterns across Databricks notebooks, Empower and related tools.
• Maintain environments, workspaces, and CI/CD patterns under guidance from senior technical leaders.
• Support 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.
• 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 steward data definitions.
• 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.
• Define SLAs, track reliability, and participate in incident response playbooks.
• Identify opportunities to improve pipeline performance and processing efficiency.
• Assist with applying data classification, masking, access controls, and privacy-by-design principles.
• Collaborate with security and platform teams to support compliance audits and maintain documentation.
• Work with project teams and business stakeholders to understand data needs and deliver reliable, well-modeled datasets.
• Promote data literacy by helping teams access and use trusted analytics assets.
• Provide clear communication, documentation, and best-practice guidance in data modeling, quality, and governance.

Requirements

• 5+ years in data architecture, data engineering, analytics engineering, or a similar development role within a modern cloud environment.
• Strong experience designing data models, building ETL/ELT pipelines, and managing lakehouse or warehouse environments.
• Experience with Databricks, MS Fabric, Delta Lake, or similar platforms.
• Experience with construction or project-based analytics is a plus.

Technologies

• Databricks
• Azure
• Fabric
• OneLake
• Data Factory
• Empower
• Databricks Genie
• Claude desktop
• Delta Lake
• MS Fabric
• Sage 300/CMiC (ERP)
• Workable/SagePeople (HRIS)
• Cosential/Unanet (CRM)

Key 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
• Experience with CLI 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
• Excellent communication skills with the ability to translate complex technical concepts for business teams
• Strong critical thinking, problem-solving, and analytical abilities
• Demonstrated ability to collaborate cross-functionally and drive adoption of data best practices