Data Engineer at Capco

Capco

US - Houston·6d ago

Mid LevelFull-timePythonAzureData ScienceCI/CDGit

Salary Range

$102,000 - $138,000 /year

Estimated

This salary is estimated based on similar roles. The actual salary may vary.

About the Role

Capco is seeking a Data Engineer to join their global management and technology consultancy. You will work across different domains to develop solutions using the Microsoft data ecosystem, creating analytics reporting and providing data-driven insights to drive client transformation.

Key Responsibilities

→Translate business objectives into scalable data architectures leveraging Microsoft Fabric
→Define data models 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
→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
→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

Requirements

✓3–7+ years in data engineering with the Microsoft stack
✓Hands-on experience with Microsoft Fabric components
✓Strong proficiency in SQL, PySpark/Python, and data modeling for analytics
✓Experience with ingestion & transformation patterns (CDC, SCD, incremental ETL/ELT)
✓Performance tuning, partitioning strategies, and file formats
✓Experience with Azure Data Lake Storage, Azure Synapse, Azure Data Factory, Azure Key Vault, Event Hub/IoT Hub
✓CI/CD and DevOps practices: Git, deployment pipelines, environment strategies
✓Excellent communication skills with client-facing experience
✓Prior management consulting experience preferred