Business Data Analyst 1/2/Senior

Who We Are

As the largest private-sector power producer in the world and the nation's largest producer of clean and reliable energy, Constellation is focused on our purpose: lighting the way to a brilliant tomorrow for all. We have been the leader in clean energy production for more than a decade, and we are cultivating a workplace where our employees can grow, thrive, and contribute. Now integrated with Calpine, our portfolio includes 55 gigawatts of capacity from nuclear, natural gas, geothermal, hydro, wind and solar facilities, with the generating capacity to power the equivalent of 27 million homes.

Our culture and employee experience make it clear: We are powered by passion and purpose. Together, we're creating healthier communities and a cleaner planet, and our people are the driving force behind our success. At Constellation, you can build a fulfilling career with opportunities to learn, grow and make an impact. By doing our best work and meeting new challenges, we can accomplish great things. Join us in meeting the country's energy needs today and tomorrow.

Total Rewards

Constellation offers an extensive selection of benefits and rewards to help our employees thrive professionally and personally. We provide competitive compensation and a wide-range of benefits that support both employees and their families, helping them prepare for the future. In addition to highly competitive salaries, eligible employees are offered a bonus program, 401(k) with company match, employee stock purchase program; comprehensive medical, dental and vision benefits, including robust wellbeing programs; disability and life insurance benefits; paid time off for vacation, holidays, and sick days; and much more.

*****************This Analyst role can be filled at Business Data Analyst I, Business Data Analyst II, or Business Data Analyst Sr level. Please see minimum qualifications list below for each level***********************************

Business Data Analyst 1 - $60,350 - $71,000

Business Data Analyst II - $69,700 - $82,000

Business Data Analyst Sr - $90,100- $106,000

Ranges are per year based on experience, along with a comprehensive benefits package that includes bonus and 401K

Primary Purpose of Position

The Business Data Analyst roles (BDA) is responsible for maintaining and validating customer attributes used in the customer setup process. The BDA ensures the accuracy and integrity of customer and prospect historical data in our internal systems. This role involves coordinating the retrieval, verification, and uploading of usage data from various sources, as well as identifying and resolving inconsistencies.

Primary Duties and Accountabilities

• Reviews all historical prospect usage data, interprets the data and questions inconsistencies with the historical usage.
• Troubleshoots EDI issues and any issues related to prospect usage data.
• Retrieves historical usage from utility websites, and reviews invoice copies for historical usage where applicable.
• Ensures prospect historical usage (from all sources) is uploaded accurately to system(s) and is flowing correctly once uploaded.
• Mitigate potential financial risks by proactively identifying and addressing any data inconsistencies or gaps.
• Identify and elevate forecasting inconsistencies as needed to ensure accurate pricing.
• Works with the utility directly when retrieving or questioning data as needed.
• Assists with ad hoc requests for process improvements, such as assisting in cleanup projects, new hire training, development of process efficiencies, and system testing.
• Identify and document new processes, making recommendations to leadership for improvement.
• Travel required as necessary to meet business needs.
• In-person attendance for training, all-hands meetings, and other meaningful engagements.

Minimum Qualifications

MINIMUM QUALIFICATIONS - Business Data Analyst I

• Bachelor’s degree, or 2 years of equivalent experience in lieu of the degree
• Exceptional written and oral communication skills; demonstrated effectiveness in collaboration and building rapport with employees and customers across various levels of the organization.
• Strong relationship-building skills, capable of establishing and maintaining partnerships both internally and externally with customers and channel partners.
• Proven ability to thrive in a fast-paced, deadline-driven environment, managing multiple priorities effectively.
• Commitment to maintaining the highest level of confidentiality for all information handled.

MINIMUM QUALIFICATIONS - Business Data Analyst II

• Bachelor's degree and minimum of 2 years of relevant experience.
• A minimum of 6 years of relevant experience in lieu of a 4-year degree.
• Proven track record of strong analytical skills, attention to detail, problem-solving abilities, and independent decision-making.
• Proficiency in Word, Excel, PowerPoint, and Outlook.
• Exceptional written and oral communication skills; demonstrated effectiveness in collaboration and building rapport with employees and customers across various levels of the organization.
• Strong relationship-building skills, capable of establishing and maintaining partnerships both internally and externally with customers and channel partners.
• Proven ability to thrive in a fast-paced, deadline-driven environment, managing multiple priorities effectively.
• Commitment to maintaining the highest level of confidentiality for all information handled.

MINIMUM QUALIFICATIONS - Business Data Analyst Sr

• Bachelor’s degree and a minimum of 5 years of experience, or 9 years of equivalent experience in lieu of the degree

• Elevated knowledge in Excel (creating and using pivot tables, macros, and vlookups) and MS Office Suite experience.

• Reporting and dashboard knowledge in Salesforce.

• Proven track record of strong analytical skills, attention to detail, problem-solving abilities, and independent decision-making.

• Proficiency in Word, Excel, PowerPoint, and Outlook.

• Exceptional written and oral communication skills; demonstrated effectiveness in collaboration and building rapport with employees and customers across various levels of the organization.

• Strong relationship-building skills, capable of establishing and maintaining partnerships both internally and externally with customers and channel partners.

• Proven ability to thrive in a fast-paced, deadline-driven environment, managing multiple priorities effectively.

• Commitment to maintaining the highest level of confidentiality for all information handled.

Preferred Qualifications

• Ability to handle multiple tasks in a fast-paced environment
• Knowledge of SQL, Python, Power BI, Excel macros, and C++ is advantageous
• Previous experience in the energy industry