Data Analyst Retail Energy

Data Analyst

About the team:

Capcos 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 clients business goals. As digital technologies advance and regulations tighten todays consumers and therefore todays businesses are becoming more aware of the importance of good quality data. 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 Capcos 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 Youll 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 Youll 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
• Bachelors or Masters 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. We maintain an entrepreneurial spirit and growth mindset and have minimal bureaucracy. We have no internal silos that get in the way of your career opportunities or ability to focus on our clients and make a difference to the business. We offer the opportunity for everyone to learn rapidly take on tough challenges and get promoted quickly. We take pride in our creative collaborative diverse and inclusive culture where everyone can #BYAW.

We offer highly competitive benefits including medical dental and vision insurance a 401(k) plan tuition reimbursement and a work culture focused on innovation and creation of lasting value for our clients and employees.

Ready to take the Next Step

If this sounds like you we would love to hear from you. This is an opportunity to make a difference and contribute to a highly successful company with a significant growth trajectory.

We have been informed of several recruitment scams targeting the strongly advise you to verify identities before engaging in recruitment related communication. Allofficial Capcocommunication will be conducted via a Capco recruiter.