Capco · 15 hours ago
Data Engineer
US - New York
Full-time
Onsite
Mid, Senior Level
$125K/yr - $143K/yr
3+ years expCapco is a global management and technology consultancy specializing in Finance and Energy markets. As a Data Engineer, you will leverage the Microsoft data ecosystem to create analytics reporting and provide data-driven insights that help drive transformation for clients.
ConsultingFinanceFinancial ServicesInsurance
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
Qualification
Required
3–7+ years in data engineering with the Microsoft stack
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
CI/CD and DevOps practices: Git, deployment pipelines, environment strategies
Excellent communication skills with client-facing experience in consulting or similar environments
Preferred
Hands-on experience with Microsoft Fabric components such as OneLake, Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, Spark Notebooks, Shortcuts, KQL
Experience with Azure Data Lake Storage, Azure Synapse (or legacy SQL DW), Azure Data Factory, Azure Key Vault, Event Hub/IoT Hub
Prior management consulting experience
Benefits
Medical, dental and vision insurance
A 401(k) plan
Tuition reimbursement
Company
Capco
Capco is a technology and management consulting firm that provides consulting for the financial services and energy industries.
5001-10000 employees
H1B Sponsorship
Capco has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (10)
2024 (5)
2023 (8)
2022 (15)
2021 (2)
2020 (14)
Funding
Current Stage
Late StageTotal Funding
$80MKey Investors
Thomas Weisel Partners
2021-03-04Acquired
2000-05-24Private Equity· $80M
Leadership Team
Anne-Marie Rowland
Chief Executive Officer
Andrew McGinn
Partner - Digital, Data & Technology
Recent News
Company data provided by crunchbase