Senior Data Engineer

Employment Type:???Full-Time FSLA:??Salary/Exempt Division:??Information Technology Department:?Enterprise Systems & Data Reports to:??Senior Manager, Enterprise Systems & Data Supervisory Duties:?No Salary Range: $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. 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.?This role serves as both a?hands?on?technical contributor and a coordinator of data?management?activities?partnering with project teams, security, and analytics stakeholders to ensure our data products are trusted, well-modeled, and ready for advanced reporting and AI use cases.

Responsibilities /?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.?

• 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.?

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.?

• Participate in defining SLAs, tracking reliability, and executing incident response playbooks.?

• Continuously?identify?opportunities to improve pipeline performance and processing efficiency.?

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.?

Collaboration & Enablement?

• 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.?

Key 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.?

• 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.?

Professional Skills?

• 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.?

Required Experience??

• 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.?