Pay
In line with similar jobs
$119K–$146K against $127K–$190K, the middle half of what similar US postings state.
From 2,383 postings in the last year. Stated ranges, not salaries paid.
Denver, United States
Actively hiring, first seen by us 8 days agoCOMPENSATION & BENEFITS Compensation*: $119,340.00 – $145,860.00 USD *Estimated target starting compensation; final compensation will be determined based on an assessment of an individual’s qualifications, education, and experience relevant to the role.Read the full posting
Design the ERDW.Next lakehouse, including medallion layers and gold-layer star schemas
Build and optimize pipelines in PySpark, Spark SQL and Delta Live Tables
Ingest data from JD Edwards, BMS, CMS, Cority, HCSS, Intelex and Anaplan
Migrate legacy SQL Server, SSIS, Synapse, ADF and Qlik Replicate workloads
Implement Unity Catalog governance, entitlements, lineage and audit
Own the technical design of the ERDW.Next lakehouse: medallion layering, Delta table design, and the gold layer that feeds Power BI.
Build and optimize pipelines in PySpark, Spark SQL, and Delta Live Tables, orchestrated through Databricks Workflows.
Engineer ingestion from JD Edwards, BMS, CMS, Cority, HCSS, Intelex, and Anaplan using CDC, Auto Loader, and MERGE.
Drive migration of legacy workloads (SQL Server procedures, SSIS, Synapse, ADF, Qlik Replicate) with a defensible parallel-run and cutover approach.
Design and implement the Unity Catalog governance model: catalog structure, entitlements, lineage, classification, and audit.
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field; or equivalent practical experience.
SQL: Expert SQL / T-SQL, including the ability to read and re-engineer large, complex legacy stored procedures.
Communication Skills: Ability to convey complex technical concepts and architectural trade-offs to technical and non-technical stakeholders, including leadership.
5+ years of hands-on experience building production data platforms on Databricks / Apache Spark, backed by 8+ years of overall experience in data engineering, data warehousing, and business intelligence.
Ownership & Bias for Action: Comfortable acting as the go-to technical authority and driving decisions to closure while the platform is still being defined.
Demonstrated ownership of the technical design of at least one enterprise data warehouse or lakehouse platform end to end—from target-state design through production delivery—rather than solely executing a design set by others.
EXPERIENCE - Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field; or equivalent practical experience. - 5+ years of hands-on experience building production data platforms on Databricks / Apache Spark, backed by 8+ years of overall experience in data engineering, data warehousing, and business intelligence.
Actively hiringFirst seen by us 8 days ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
In line with similar jobs
$119K–$146K against $127K–$190K, the middle half of what similar US postings state.
From 2,383 postings in the last year. Stated ranges, not salaries paid.
Day 8
Similar jobs usually come down between day 6 and day 56.
From 13,974 similar postings that came down. Coming down is not always a hire.
2 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Databricks Platform: Expert across Databricks SQL, Workflows / Jobs, Delta Live Tables, Unity Catalog, Auto Loader, Photon, and cluster / SQL warehouse configuration (must-have). - Spark & Python: Advanced PySpark and Spark SQL, writing modular, tested, reusable code rather than one-off notebooks (must-have). - Delta Lake: Deep proficiency—MERGE / upserts, time travel, OPTIMIZE, Z-ORDER, liquid clustering, partitioning, VACUUM, and schema evolution.
Colas is one of North America’s largest road and infrastructure groups, and Colas ISS provides the technology and data services that keep the business running. Databricks is our long-term data platform, and we are looking for a Senior Data Engineer to build and own it. Our current major initiative is ERDW.Next, the migration of our Enterprise Reporting & Data Warehouse onto Databricks; when that lands, this role continues as the technical owner of the platform and of every new data domain we bring onto it. This is a hands-on, build-first role, and deliberately more than a tools role. We want an engineer who brings architect-level thinking to enterprise data—target-state design, modeling and governance standards, and a sequenced migration path off our legacy SQL Server / Synapse / SSRS estate—and who then writes the production code that makes it real. Design authority here is earned by building: most of your time will be spent engineering, not advising. You own the data platform’s architecture and are accountable for it working in production, within the enterprise direction set by our Enterprise Architect. This is a senior individual-contributor role with no direct reports; delivery priorities and partner direction sit with the Manager, Application Development & Data Engineering. You will work directly with our Power BI developers, Data Engineers, business users and citizen developers across finance, construction, equipment, and safety, and our offshore delivery partners.
- Stay hands-on in the codebase, writing and reviewing production pipelines as the primary way you set technical standards. - Build and optimize pipelines in PySpark, Spark SQL, and Delta Live Tables, orchestrated through Databricks Workflows. - Engineer ingestion from JD Edwards, BMS, CMS, Cority, HCSS, Intelex, and Anaplan using CDC, Auto Loader, and MERGE.
- Engineer ingestion from JD Edwards, BMS, CMS, Cority, HCSS, Intelex, and Anaplan using CDC, Auto Loader, and MERGE. - Drive migration of legacy workloads (SQL Server procedures, SSIS, Synapse, ADF, Qlik Replicate) with a defensible parallel-run and cutover approach. Running the Platform
Legacy Estate, Partners & Communication - Provide senior-level support and change-request delivery on the legacy ERDW estate (T-SQL, SSRS, Synapse, ADF) while it remains in service. - Hold the engineering quality bar across offshore partner work (Datavail, Birlasoft) through design and code reviews and a clear definition of done.
- Currently hands-on in code and intending to remain so. This is not a design-only, advisory, or oversight position; candidates seeking to move away from day-to-day engineering will not be a fit. - Proven track record migrating legacy on-premises or first-generation cloud warehouse workloads (SQL Server, SSIS, Synapse, ADF) to a modern lakehouse architecture. - Experience sourcing data from ERP and operational systems (JD Edwards strongly preferred) and delivering finance and operational reporting at enterprise scale.
- Platform Design & Data Strategy: Able to define a target-state design and a sequenced migration roadmap, and to defend the trade-offs to both engineers and executives (must-have). - Databricks Platform: Expert across Databricks SQL, Workflows / Jobs, Delta Live Tables, Unity Catalog, Auto Loader, Photon, and cluster / SQL warehouse configuration (must-have). - Spark & Python: Advanced PySpark and Spark SQL, writing modular, tested, reusable code rather than one-off notebooks (must-have).
- Enterprise & Dimensional Data Modeling: Star schema, conformed dimensions, slowly changing dimensions, and grain design—including a gold layer purpose-built for a Power BI semantic layer (must-have). - SQL: Expert SQL / T-SQL, including the ability to read and re-engineer large, complex legacy stored procedures. - Data Governance: Unity Catalog, access control and entitlements, lineage, data classification, data quality frameworks, and master data / metric definition.
- BI Integration: Solid understanding of Power BI semantic models and of Direct Lake / DirectQuery / import trade-offs, plus Microsoft Fabric and OneLake. - Legacy Estate: Working capability across SQL Server, SSIS, SSRS / paginated reporting, Synapse, and ADF to support the existing ERDW platform during transition. - AI-Assisted Delivery: Fluent use of agentic coding assistants in day-to-day engineering, paired with the judgment to know when the output is wrong.
- Experience reviewing the work of offshore or partner development teams and holding a consistent quality bar across them. - Preferred certifications: Databricks Certified Data Engineer Professional and / or Databricks Certified Data Architect; Azure DP-203 or AZ-305 a plus. PROFESSIONAL SKILLS
- Self-Service Enablement: Making certified data usable by business users and citizen developers through documentation, guardrails, and coaching rather than gatekeeping. - Azure Data Platform: ADLS Gen2, Azure Data Factory, Azure Synapse, Key Vault, Entra ID, and the networking fundamentals behind secure data services. - Ingestion & Replication: CDC and replication tooling (Qlik Replicate or equivalent), API and file-based ingestion, and Structured Streaming concepts.
- Ingestion & Replication: CDC and replication tooling (Qlik Replicate or equivalent), API and file-based ingestion, and Structured Streaming concepts. - DevOps & CI/CD: Git, Azure DevOps or GitHub Actions, Databricks Asset Bundles / Repos, automated testing, and infrastructure as code (Terraform a plus). - Performance & Cost Optimization: Job and query tuning, cluster right-sizing, workload isolation, and demonstrable cloud cost management.
MISSION Colas is one of North America’s largest road and infrastructure groups, and Colas ISS provides the technology and data services that keep the business running. Databricks is our long-term data platform, and we are looking for a Senior Data Engineer to build and own it. Our current major initiative is ERDW.Next, the migration of our Enterprise Reporting & Data Warehouse onto Databricks; when that lands, this role continues as the technical owner of the platform and of every new data domain we bring onto it. This is a hands-on, build-first role, and deliberately more than a tools role. We want an engineer who brings architect-level thinking to enterprise data—target-state design, modeling and governance standards, and a sequenced migration path off our legacy SQL Server / Synapse / SSRS estate—and who then writes the production code that makes it real. Design authority here is earned by building: most of your time will be spent engineering, not advising.
- Engineer reliability: data quality expectations, restartable pipelines, monitoring, and dependable SLAs through month-end close. - Establish and maintain CI/CD: Git-based development, Databricks Asset Bundles, promotion across environments, and automated testing. Governance & Trusted Data
Self-Service & AI Enablement - Curate Databricks Genie Agents over the gold layer: datasets, example queries, business semantics, and verified answers. - Work directly with business users and citizen developers across finance, construction, equipment, and safety.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field; or equivalent practical experience. - 5+ years of hands-on experience building production data platforms on Databricks / Apache Spark, backed by 8+ years of overall experience in data engineering, data warehousing, and business intelligence. - Demonstrated ownership of the technical design of at least one enterprise data warehouse or lakehouse platform end to end—from target-state design through production delivery—rather than solely executing a design set by others.
- Data Governance: Unity Catalog, access control and entitlements, lineage, data classification, data quality frameworks, and master data / metric definition. - Conversational & Agentic Analytics: Curating natural-language query layers over governed data—dataset selection, business semantics, synonyms, verified answers, and evaluation. Databricks Genie experience a plus. - Self-Service Enablement: Making certified data usable by business users and citizen developers through documentation, guardrails, and coaching rather than gatekeeping.
Platform Architecture & Design - Own the technical design of the ERDW.Next lakehouse: medallion layering, Delta table design, and the gold layer that feeds Power BI. - Set the platform roadmap and defend pattern-level decisions — batch vs. streaming, Delta Live Tables vs. Workflows, where transformation logic belongs.
- Own the technical design of the ERDW.Next lakehouse: medallion layering, Delta table design, and the gold layer that feeds Power BI. - Set the platform roadmap and defend pattern-level decisions — batch vs. streaming, Delta Live Tables vs. Workflows, where transformation logic belongs. - Define enterprise data modeling standards: conformed dimensions, gold-layer star schemas, slowly changing dimensions, grain, and naming.
- Spark & Python: Advanced PySpark and Spark SQL, writing modular, tested, reusable code rather than one-off notebooks (must-have). - Delta Lake: Deep proficiency—MERGE / upserts, time travel, OPTIMIZE, Z-ORDER, liquid clustering, partitioning, VACUUM, and schema evolution. - Enterprise & Dimensional Data Modeling: Star schema, conformed dimensions, slowly changing dimensions, and grain design—including a gold layer purpose-built for a Power BI semantic layer (must-have).
This is a hands-on, build-first role, and deliberately more than a tools role. We want an engineer who brings architect-level thinking to enterprise data—target-state design, modeling and governance standards, and a sequenced migration path off our legacy SQL Server / Synapse / SSRS estate—and who then writes the production code that makes it real. Design authority here is earned by building: most of your time will be spent engineering, not advising. You own the data platform’s architecture and are accountable for it working in production, within the enterprise direction set by our Enterprise Architect. This is a senior individual-contributor role with no direct reports; delivery priorities and partner direction sit with the Manager, Application Development & Data Engineering. You will work directly with our Power BI developers, Data Engineers, business users and citizen developers across finance, construction, equipment, and safety, and our offshore delivery partners. COMPENSATION & BENEFITS
- Make certified data the easiest path to use and raise their capability, rather than gatekeeping behind a request queue. - Partner with Power BI developers on the serving layer beneath their semantic models, deciding what belongs where. AI-Assisted Engineering
- Delta Lake: Deep proficiency—MERGE / upserts, time travel, OPTIMIZE, Z-ORDER, liquid clustering, partitioning, VACUUM, and schema evolution. - Enterprise & Dimensional Data Modeling: Star schema, conformed dimensions, slowly changing dimensions, and grain design—including a gold layer purpose-built for a Power BI semantic layer (must-have). - SQL: Expert SQL / T-SQL, including the ability to read and re-engineer large, complex legacy stored procedures.
- Performance & Cost Optimization: Job and query tuning, cluster right-sizing, workload isolation, and demonstrable cloud cost management. - BI Integration: Solid understanding of Power BI semantic models and of Direct Lake / DirectQuery / import trade-offs, plus Microsoft Fabric and OneLake. - Legacy Estate: Working capability across SQL Server, SSIS, SSRS / paginated reporting, Synapse, and ADF to support the existing ERDW platform during transition.
- Azure Data Platform: ADLS Gen2, Azure Data Factory, Azure Synapse, Key Vault, Entra ID, and the networking fundamentals behind secure data services. - Ingestion & Replication: CDC and replication tooling (Qlik Replicate or equivalent), API and file-based ingestion, and Structured Streaming concepts. - DevOps & CI/CD: Git, Azure DevOps or GitHub Actions, Databricks Asset Bundles / Repos, automated testing, and infrastructure as code (Terraform a plus).
Complete your application on joining.bouygues.com. The employer’s form will show what is required.
Already applied? Track this application
Colas IS Support is the information technology arm of the North America business for Colas and is based in Denver, Colorado. Colas ISS strives to make Colas an industry leader through developing custom mobile applications and business intelligence tools, supporting core applications, maintaining our infrastructure, and much more. Through a partnership with the Colas Companies in the USA & Canada Colas IS Support helps empower our employees for success while also providing direct contact with users and other innovators across the organization. To learn more about Colas IS Support visit www.colasiss.com/.
The Colas USA Family of Companies provides competitive pay, outstanding benefits, career advancement opportunities, professional education, and extensive training for every employee. We pride ourselves on upholding the highest standards of safety, environmental conservation, and ethical conduct as we strive to grow our infrastructure products and services through empowering and developing our people, fostering innovation, utilizing new technology, and maximizing vertical integration at all levels of the company’s value chain. To learn more about the Colas USA Family of Companies, please visit www.colasusa.com.
Colas is one of North America’s largest road and infrastructure groups, and Colas ISS provides the technology and data services that keep the business running. Databricks is our long-term data platform, and we are looking for a Senior Data Engineer to build and own it. Our current major initiative is ERDW.Next, the migration of our Enterprise Reporting & Data Warehouse onto Databricks; when that lands, this role continues as the technical owner of the platform and of every new data domain we bring onto it.
This is a hands-on, build-first role, and deliberately more than a tools role. We want an engineer who brings architect-level thinking to enterprise data—target-state design, modeling and governance standards, and a sequenced migration path off our legacy SQL Server / Synapse / SSRS estate—and who then writes the production code that makes it real. Design authority here is earned by building: most of your time will be spent engineering, not advising.
You own the data platform’s architecture and are accountable for it working in production, within the enterprise direction set by our Enterprise Architect. This is a senior individual-contributor role with no direct reports; delivery priorities and partner direction sit with the Manager, Application Development & Data Engineering. You will work directly with our Power BI developers, Data Engineers, business users and citizen developers across finance, construction, equipment, and safety, and our offshore delivery partners.
Compensation*: $119,340.00 – $145,860.00 USD
*Estimated target starting compensation; final compensation will be determined based on an assessment of an individual’s qualifications, education, and experience relevant to the role.
Benefits: Full-time salaried exempt employees are eligible for Colas Group benefits, as outlined in the plan documents. Available benefits include medical, dental, and vision insurance, term life insurance, supplemental life insurance, 401(K) with company match, short- and long-term disability. Other benefits include paid holidays, paid sick leave, accrued vacation time off, and paid parental leave.
Other Compensation: This position may be considered for annual bonus compensation.
Platform Architecture & Design
Build & Migration
Running the Platform
Governance & Trusted Data
Self-Service & AI Enablement
AI-Assisted Engineering
Legacy Estate, Partners & Communication
This job description is not intended to be an exhaustive list of duties, responsibilities, or qualifications and may be amended to meet business needs.
Colas Inc. and its subsidiaries are an Equal Opportunity Employer. For details on the specifics of this commitment, please click here to view the EEO document. If you are an individual with a disability and require a reasonable accommodation to:
Please contact Colas Inc. at 973-290-9082 or send an email to ColasRecruiter@colasinc.com.
New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
COMPENSATION & BENEFITS Compensation*: $119,340.00 – $145,860.00 USD *Estimated target starting compensation; final compensation will be determined based on an assessment of an individual’s qualifications, education, and experience relevant to the role.
Denver, United States
Working pattern and location restrictions need checking in the full posting.
This is a hands-on, build-first role, and deliberately more than a tools role. We want an engineer who brings architect-level thinking to enterprise data—target-state design, modeling and governance standards, and a sequenced migration path off our legacy SQL Server / Synapse / SSRS estate—and who then writes the production code that makes it real. Design authority here is earned by building: most of your time will be spent engineering, not advising. You own the data platform’s architecture and are accountable for it working in production, within the enterprise direction set by our Enterprise Architect. This is a senior individual-contributor role with no direct reports; delivery priorities and partner direction sit with the Manager, Application Development & Data Engineering. You will work directly with our Power BI developers, Data Engineers, business users and citizen developers across finance, construction, equipment, and safety, and our offshore delivery partners. COMPENSATION & BENEFITS
- Curate Databricks Genie Agents over the gold layer: datasets, example queries, business semantics, and verified answers. - Work directly with business users and citizen developers across finance, construction, equipment, and safety. - Make certified data the easiest path to use and raise their capability, rather than gatekeeping behind a request queue.
More relevant text appears in the full description.