Data Engineer
Location: Houston, Texas, US | Practice Area: Technology & Engineering | Type: Permanent
Build scalable data platforms that power transformation across Financial Services and Energy.
The RoleCapco 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.
What You’ll Do- 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.
Use of Artificial Intelligence in Talent AcquisitionAt 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.
What the Team is Saying
Capco Compensation & Benefits Highlights
-
Healthcare Strength — Health, dental, and vision coverage are described as solid with low copays and a good variety of choices, complemented by mental‑health resources, an EAP, and wellbeing events. Company materials emphasize global availability of these supports.
-
Parental & Family Support — Enhanced maternity, paternity, adoption, and shared parental leave are highlighted, with several months of maternity leave noted in the U.S. in some accounts. Additional paid leave is called out for life events such as pregnancy loss, fertility treatment, menopause, and bereavement.
-
Wellbeing & Lifestyle Benefits — A global wellbeing program, coaching/mentoring, mental‑health initiatives, and wellness reimbursements (e.g., gym, fitness) are positioned as core parts of the offering. Flexible working is emphasized alongside regionally tailored wellbeing events.
Capco Insights
Similar Jobs
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance, and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent. TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients. DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success. DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions. ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
