Senior Data Engineer, Databricks
COLASAbout the role
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.
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.
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
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.
RESPONSIBILITIES
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.
- Define enterprise data modeling standards: conformed dimensions, gold-layer star schemas, slowly changing dimensions, grain, and naming.
- Partner with the Enterprise Architect on the data governance framework, JD Edwards data strategy, and enterprise integration patterns.
Build & Migration
- 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.
- Drive migration of legacy workloads (SQL Server procedures, SSIS, Synapse, ADF, Qlik Replicate) wi
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s