Capco · 7 hours ago
Data Analyst - Retail Energy
Houston, TX
Full-time
Hybrid
Mid Level
3+ years expCapco is a consultancy firm specializing in financial services, and they are seeking a Data Analyst to join their Data Team within the retail energy group. The role involves analyzing large datasets, building ETL pipelines, and contributing to data migration projects for retail energy providers.
ConsultingFinanceFinancial ServicesInsurance
Responsibilities
Analyze large datasets from retail energy providers, including customer usage, pricing, products, transactions, invoices, and operational metrics
Build and maintain ETL pipelines using SSIS or Azure Data Factory to stage and migrate data
Write advanced SQL to cleanse, join, and transform data within staging databases
Collaborate with client SMEs to document field-level mappings and transformation logic
Perform unit testing, reconciliations, and exception reporting to ensure accuracy and completeness
Populate client-specified load templates and prepare data for platform imports
Identify data issues and suggest improvements to enhance migration quality and efficiency
Qualification
Required
3+ years in data migration or data analytics, retail energy experience required
Strong SQL skills and experience with ETL tools (SSIS, ADF/Azure Data Factory)
Familiarity with Python, R, or similar scripting languages
Knowledge of retail energy data (customers, pricing, transactions)
Effective communicator and collaborative team player
Bachelor's or Master's degree in a technical or analytical field
Preferred
consulting experience preferred
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