Data Engineer
About the Role
Are you passionate about data and eager to make a real impact? We're looking for a Data Engineer to join our growing team and play a key role in the ongoing customization, enhancement, and support of Carma's best-in-class network and digital infrastructure platform. You'll design, develop, and maintain robust data solutions that drive business operations and analytics, owning the full journey from source extraction through transformation to final load.
Day to day, you'll write SQL and Python, build ETL scripts, map source-to-target data flows, and create clear documentation that keeps customers and internal teams aligned. You'll work closely with cross-functional teams, enjoy the freedom to work independently, and build on your leadership skills in a collaborative setting. If you love rolling up your sleeves on data challenges and take pride in the pipelines you've built, we'd love to hear from you!
Job Type: Full Time
Location: Denver, CO
Start date: Immediate
Compensation: $130-$160k, annual bonus based on performance, group health insurance, 401k, RTD Ecopass, onsite gym membership
What You'll Do
Data Solutions and Pipeline Development
Design and build scalable, efficient ETL/ELT pipelines to extract data from customer source systems, transform it to meet Carma's schema requirements, and load it into our data warehouse
Write and maintain SQL queries and Python scripts for data extraction, cleansing, transformation, and validation
Collaborate with teammates to design and implement data flows between data lakes, staging environments, and production warehouses
Optimize data processing and query performance, and ensure data quality and integrity through rigorous testing and validation
Implement data governance and security best practices across production environments
Documentation and Client Deliverables
Create and maintain Entity Relationship Diagrams (ERDs) for customer data models
Build source-to-target mapping documents that clearly define how data moves from origin systems to Carma's platform
Create reports that customers and engagement managers can use to validate migration accuracy
Produce project status reports, milestone documentation, and deliverable summaries for engineering managers and clients
Develop data models and schemas to support business intelligence and reporting
Project Execution and Leadership
Take ownership of your project timelines, balancing deadlines across multiple customer engagements
Partner with engagement managers, business analysts, and customers to gather requirements, understand data needs, and validate results
Keep the team informed: share blockers, risks, and progress updates so everyone stays aligned
Inspire others and foster strong relationships within a collaborative team setting
Innovate and invite a best-practice culture in method, tools, and approach for project work and IP solutions
Required Skills and Experience
What We Need From You
5+ years of professional experience in data engineering, data migration, or data warehousing
Strong proficiency in both SQL and Python — you're comfortable using both daily and writing production-grade code in each
Proven experience building ETL/ELT pipelines from scratch, not just maintaining existing ones
Hands-on experience with data lakes and data warehouse architectures (design, load patterns, optimization)
A track record of creating customer-facing documentation: ERDs, source-to-target maps, data dictionaries
Superior analytical, quantitative, and conceptual thinking skills to tackle complex data challenges
Strong communication and interpersonal abilities to ensure successful client projects and team performance
Comfortable managing project deadlines and delivering documentation to engineering managers and clients
Deep knowledge of data centers and/or telecom industries. Knowledge of the OSI Model or Power & Cooling are highly beneficial. Understanding current technology used in delivery of services.
Technical Requirements
Advanced proficiency with SQL and Spark for large-scale data processing
Working knowledge of Azure cloud services (Azure Data Factory, Azure SQL, ADLS, or similar)
Experience with Databricks or similar data platform (Spark based)
Microsoft BI tools (Power BI or similar) for reporting and data visualization
Proficiency with the Microsoft Office suite (Word, Excel, PowerPoint, Outlook)
Proficiency with source control (Git), CI/CD tools, and development environments (VS Code, Azure DevOps)
Strong understanding of data warehousing and data modeling concepts — star schema, snowflake schema, normalization, denormalization
Experience with data ingestion tools and technologies (Python, Power BI)
Knowledge of data quality and validation best practices
Strong written communications, especially related to articulating expectations and results
Preferred Skills
Familiarity with Agile/Scrum delivery methodologies
Experience with data visualization tools (Power BI or similar)
Familiarity with Microsoft Flow, Power Automate, and Microsoft Common Data Service configuration migration
Previous work on building data warehouse’s with teams of five or more people
Why Join Us
Be part of a close-knit, dynamic team where your contributions are visible and valued from day one
Every project brings something new. You'll work with diverse customer datasets and source systems, so no two engagements are the same.
Your work has direct customer impact. The pipelines you build and the documentation you create are the deliverables our clients rely on
We're a forward-thinking team that values creativity, innovation, and supports each other's growth
Denver-based, full-time, with real opportunities to expand your skills and grow into senior technical or leadership roles