Data Engineer

CFS; Brighton (CO); On-site; USD 110,000 - 120,000; Full time

Job summary

CFS is seeking a Data Engineer for an onsite Denver, CO role to lead a high-visibility data modernization initiative affecting enterprise reporting and architecture.

The position focuses on rebuilding ETL processes, standardizing dashboards, and documenting critical business systems, with significant ownership and autonomy.

The ideal candidate will design scalable data pipelines, implement Power BI governance with DAX and row-level security, and transition from legacy platforms.

Qualifications

• Advanced ETL architecture, design, and documentation experience.
• Strong experience rebuilding or modernizing data environments.
• Advanced Power BI expertise.
• Deep knowledge of DAX calculations and report design.
• Experience implementing row-level security within Power BI.
• Strong technical documentation and process-mapping skills.
• Ability to work independently and navigate ambiguity.
• Experience evaluating existing systems and recommending improvements.

Responsibilities

• Lead two critical initiatives and oversee transition from legacy systems.
• Design and implement a new ETL framework, scalable data pipelines, and secure reporting.
• Standardize Power BI reports and establish a base report library.
• Develop implementation plans and technical specifications for data modernization.
• Build and deploy the new ETL environment and ensure governance.
• Support API and data integration efforts with legacy systems.

Skills

ETL architecture

Data modernization

Power BI expertise

DAX calculations

Row-level security (Power BI)

Technical documentation

Independent work

Systems evaluation

Job description

Overview

Onsite: Denver, CO

Our client is seeking a Data Engineer to lead a high-visibility data modernization initiative focused on rebuilding ETL processes, standardizing reporting, and documenting critical business systems. This role offers significant ownership, autonomy, and the opportunity to impact enterprise-wide decision-making through improved data architecture and reporting.

The organization is seeking a self-driven professional who enjoys solving complex data challenges with minimal oversight.

Core Responsibilities

As the Data Engineer, you will be responsible for driving two business-critical initiatives and ensuring a successful transition away from legacy systems.

Key Functional Tasks & Estimated Time Allocation

• Current-State ETL Analysis & Documentation


• Assess and document existing ETL processes and data flows


• Identify process conflicts, redundancies, and dependencies


• Work with subject matter experts to understand legacy architecture


• Create detailed technical documentation to support future-state planning


• ETL Architecture, Design & Rebuild


• Design and architect a new ETL framework to replace legacy processes


• Establish scalable, secure, and maintainable data pipelines


• Develop implementation plans and technical specifications


• Build and deploy the new ETL environment


• Power BI Reporting Standardization


• Evaluate existing reports and dashboards


• Establish a standardized reporting framework and base report library


• Develop and refine DAX calculations


• Implement row-level security and scalable reporting access


• Integration & Transition Projects


• Support legacy platform transition efforts


• Participate in API and data integration initiatives


• Assist with knowledge transfer and future-state readiness planning

Required Qualifications

The successful Data Engineer will possess:

• Advanced ETL architecture, design, and documentation experience


• Strong experience rebuilding or modernizing data environments


• Advanced Power BI expertise


• Deep knowledge of DAX calculations and report design


• Experience implementing row-level security within Power BI


• Strong technical documentation and process-mapping skills


• Ability to work independently and navigate ambiguity


• Experience evaluating existing systems and recommending improvements

Preferred Qualifications

• API integration experience


• Experience working with legacy system migrations


• Knowledge of Salesforce data structures


• Exposure to financial services, operations, leasing, or data-intensive environments


• Familiarity with enterprise reporting governance

Core Competencies

The Data Engineer Will Bring

• Strong curiosity and investigative problem-solving skills


• Ability to prioritize multiple large-scale initiatives


• Independent decision-making and execution capabilities


• Effective communication with technical and non-technical stakeholders


• Passion for building scalable, long-term solutions

Work Environment and Compensation

• Onsite role in Denver, CO


• Business casual culture, including casual Fridays


• Collaborative team focused on innovation, continuous improvement, and practical problem-solving


• $110,000 to $120,000 annual salary


• Performance-based compensation growth opportunities

Why Consider This Opportunity?

This Data Engineer opportunity offers ownership of foundational data initiatives that directly impact business operations and executive decision-making. You will help modernize critical systems, replace legacy processes, establish reporting standards, and shape the future data architecture of a growing organization.

The ideal Data Engineer thrives when solving complex data puzzles, building scalable solutions, and creating order from highly customized legacy environments.

#INAUG2026