Data Engineer

Data Engineer
Location: Houston, Texas, US | Practice Area: Technology & Engineering | Type: Permanent

Build scalable data platforms that power transformation across Financial Services and Energy.

Capco is a global technology and business consultancy focused on the Financial Services and Energy sectors. We combine innovative thinking with deep domain expertise to help our clients navigate complex transformation initiatives, modernize technology landscapes, and unlock value through data.

As a Data Engineer within our Technology & Engineering practice, you will work with clients to design, build, and optimize modern data platforms using the Microsoft data ecosystem. You will play a key role in delivering scalable, cloud-native solutions that enable advanced analytics, reporting, and data-driven decision-making across enterprise environments.

This is an opportunity to work on high-impact transformation programs while collaborating with multidisciplinary teams in a fast-paced consulting environment.

• Design and implement scalable data architectures leveraging Microsoft Fabric, including OneLake, Lakehouses, Warehouses, Pipelines, Spark, and Shortcuts
• Build and optimize ingestion and transformation pipelines using Fabric Data Pipelines, Dataflows Gen2, PySpark, SQL, Azure Data Factory, and Azure Synapse
• Develop reusable frameworks for data quality, metadata-driven processing, schema management, and incremental ETL/ELT patterns
• Collaborate with analytics and business teams to deliver performant semantic models, reporting solutions, and Power BI integrations
• Support client engagements through workshops, roadmap development, effort estimation, and stakeholder communication

• 3–7+ years of experience in data engineering using Microsoft and Azure-based technologies
• Strong hands-on expertise with Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Pipelines, Spark Notebooks, and Power BI integration
• Advanced proficiency in SQL, T-SQL, PySpark/Python, and modern data modeling techniques such as star schema, snowflake, and data vault
• Experience implementing CDC, SCD, incremental processing, partitioning strategies, and performance optimization for large-scale data environments
• Excellent communication and stakeholder management skills with experience working in consulting or client-facing environments

• Experience with Azure Event Hub, IoT Hub, Microsoft Purview, and Azure Key Vault
• Exposure to CI/CD and DevOps practices including Git integration and deployment pipelines
• Knowledge of streaming ingestion and real-time analytics architectures
• Experience supporting data science workloads and feature store implementations
• Previous management consulting experience within Financial Services or Energy sectors

• Deliver high-impact technology solutions for Tier 1 financial institutions and global energy organizations
• Work in a collaborative, flat, and entrepreneurial consulting culture
• Access continuous learning, training, and industry certifications
• Be part of a team shaping the future of digital financial services
• Help shape the future of digital transformation across FS & Energy

• Medical, Dental, Vision, and 401(k) match
• Maternity and paternity leave plus dependent care support
• Tuition reimbursement and wellness reimbursement programs
• HSA, FSA, and commuter benefits
• Access to Working Advantage employee discounts marketplace

We’re committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know – we’ll be happy to help. We value each person’s unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration – a mindset that shapes how we work with clients and each other every day.

At Capco, we use artificial intelligence (AI) tools to support and enhance several parts of talent acquisition. This includes using AI-enabled features within LinkedIn to help source potential candidates, speeding up routine recruitment communications such as emails and creating compelling and brand-aligned job postings that accurately reflect role requirements, and AI-scheduling applications to improve the efficiency of interview coordination.

AI is used as a support tool only. All hiring decisions are made by talent acquisition and hiring teams.