Data Engineer

Capco • Houston, TX

12d

About The Position

As a member of our Data Team, you will work across Capco’s different domains and solution offerings to help break down large problems, develop approaches and solutions using the Microsoft data ecosystem. As a Data Engineer, you will create analytics reporting and provide data-driven strategic insights, trends, and perspective to help drive transformation for our clients.

Requirements

• 3–7+ years in data engineering with the Microsoft stack
• Hands-on experience with Microsoft Fabric components such as OneLake, Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, Spark Notebooks, Shortcuts, KQL (nice to have), and Power BI integration
• Strong proficiency in SQL (T-SQL), PySpark/Python, and data modeling for analytics. Ingestion & transformation patterns (CDC, SCD, incremental ETL/ELT)
• Performance tuning, partitioning strategies, and file formats
• Experience with Azure Data Lake Storage, Azure Synapse (or legacy SQL DW), Azure Data Factory, Azure Key Vault, Event Hub/IoT Hub (plus)
• CI/CD and DevOps practices: Git, deployment pipelines, environment strategies
• Excellent communication skills with client-facing experience in consulting or similar environments

Nice To Haves

• KQL
• Prior management consulting experience preferred

Responsibilities

• Translate business objectives into scalable data architectures leveraging Microsoft Fabric (OneLake, Lakehouses, Data Warehouses, Pipelines, Spark, Shortcuts)
• Define data models (star/snowflake, data vault) and patterns for batch and streaming ingestion.
• Establish governance, security, and cost-optimized design on Azure and Fabric
• Build robust ingestion and transformation pipelines using Fabric Data Pipelines, Dataflows Gen2, PySpark/SQL in Fabric Notebooks, and Azure Data Factory / Azure Synapse where applicable
• Develop reusable frameworks for data quality, schema management, and metadata-driven processing
• Implement CDC, SCD, and incremental processing in Lakehouse layers
• Curate conformed and semantic layers to power Power BI and downstream analytics
• Collaborate with analytics teams to optimize DAX, semantic models, and performance
• Support data science workloads with feature stores and performant query layers
• Set up CI/CD, orchestration, observability, and cost monitoring for Fabric assets and Azure components (e.g., Git integration, deployment pipelines)
• Enforce data governance with Microsoft Purview, security roles, and PII protection patterns
• Lead workshops, assess current-state maturity, and propose target-state roadmaps
• Estimate effort, manage deliverables, and communicate progress to client executives

Benefits

• We offer highly competitive benefits, including medical, dental and vision insurance, a 401(k) plan, tuition reimbursement, and a work culture focused on innovation and creation of lasting value for our clients and employees

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 1,001-5,000 employees