Overview Capco’s Data Team helps our clients transform every aspect of their business. We are highly skilled at formulating data strategy, defining business and technology initiatives across the data management lifecycle, and aligning multi-year strategic roadmaps with client’s business goals. We work to establish holistic ways to effectively manage data through the modern data supply chain and facilitate consumption through analytics, modelling, AI, machine learning, dashboarding, and reporting. About the Job: As a member of our Data Team within our retail energy group, you will work across Capco’s different domains and solution offerings to help break down large problems, develop approaches and solutions. As a Data Analyst, you will contribute to data migration projects for retail energy providers, focusing on extracting, transforming, validating, and loading client data into target platforms. What You’ll Get to Do 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 What You’ll Bring with You 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; consulting experience preferred Why Capco? A career at Capco is a chance to help reshape the competitive landscape in financial services. We launch new banks, transform existing ones, and help our clients navigate complex change. As consultants, we work on the front-end business design all the way through to technology implementation. We are the largest Financial Services focused consultancy in the world, serving everyone from global banks to emerging FinTechs, from strategy through digital transformation, design, business consulting, data and analytics, cyber, cloud, technology architecture, and engineering. Capco is a young and growing firm with an entrepreneurial spirit and growth mindset. We offer opportunities to learn rapidly, take on tough challenges, and advance. We pride ourselves on a creative, collaborative, diverse, and inclusive culture where everyone can #BYAW. Ready to take the Next Step? If this sounds like you, we would love to hear from you. This is an opportunity to contribute to a highly successful company with a significant growth trajectory. Capco is an equal opportunity employer. We are committed to a diverse and inclusive workplace. Completion of any optional forms is voluntary and will not affect hiring decisions. U.S. EQUAL OPPORTUNITY EMPLOYMENT INFORMATION Capco complies with applicable equal opportunity laws. We do not discriminate on the basis of race, color, religion, national origin, sex, sexual orientation, gender identity, age, disability, veteran status, or other protected characteristics. Information collected is for compliance reporting purposes and is voluntary.

#J-18808-Ljbffr