Business Data Analyst (Multiple Levels) - #1399459

Who We Are

As the nation's largest producer of clean, carbon-free energy, Constellation is focused on our purpose: accelerating the transition to a carbon-free future. 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.

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 and help fight climate change. Join us to lead the clean energy future.

TOTAL REWARDS

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

Senior Business Data Analyst - Expected salary range of $94,500 to $105,000, varies based on experience, along with comprehensive benefits package that includes bonus and 401(k).

Business Data Analyst II - expected salary range of $73,800 to $82,000, varies based on experience, along with comprehensive benefits package that includes bonus and 401(k).

Business Data Analyst I - expected salary range of $58,500 to $65,000, varies based on experience, along with comprehensive benefits package that includes bonus and 401(k).

Senior Business Data Analyst - Primary Purpose Of Position

The Senior Business Data Analyst (BDA) serves as a subject matter expert and role model for peers. This position is responsible for processing complex nonstandard deals across regions and assumes ownership of the internal Retail Gas Volumes system. The BDA acts as the primary liaison and point of contact with other functional groups for pre-deal related issues in the sales cycle. They possess an expert level of data interpretation, identifying inconsistencies in usage data, and play a key role in testing, training, and participating in special projects. The BDA takes a proactive approach to mitigate potential risks, detecting and addressing any data inconsistencies or gaps before they impact operations.

Business Data Analyst Ii - Primary Purpose Of Position

The Business Data Analyst II (BDA) is responsible for ensuring the accuracy and integrity of customer and account data in our internal systems. This role provides advanced technical support to the sales and account management team and serves as the primary liaison with other functional groups for pre-deal related issues in the sales cycle. The BDA focuses on advanced data interpretation of usage data, identifying inconsistencies, and developing technical and analytical skills to influence the direction of C&I gas systems and processes to deliver self-manufactured solutions. This role takes a proactive approach to mitigate potential risks, detecting and addressing any data inconsistencies or gaps before they impact operations.

Business Data Analyst i - Primary Purpose Of Position

The Business Data Analyst I (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.

Senior Business Data Analyst - Primary Duties And Accountabilities

• Advanced Data Analysis: Conduct in-depth analysis and interpretation of historical prospect usage data, using advanced statistical methods and modeling techniques to identify patterns, trends, and anomalies. Question any inconsistencies and manage Electronic Data Interface (EDI) requests with utilities. Demonstrate expertise in troubleshooting complex EDI and data-related issues. Retrieve and verify historical usage data from utility websites and review invoice copies. Ensure accurate and timely uploading of prospect historical usage to internal systems, utilizing advanced data validation and cleansing techniques. Mitigate potential financial risks by proactively identifying and addressing any data inconsistencies or gaps.
• Retail Gas Volumes System Ownership: Take ownership of the internal Retail Gas Volumes system, ensuring all data-related issues and system problems are addressed promptly. Collaborate with the IT team to resolve system issues and actively participate in maintaining smooth processes related to the historical usage data flow. Troubleshoot historical usage data issues encountered throughout the prospect-to-customer life cycle.
• Utility Knowledge and Relationship Management: Stay at the forefront of utility industry trends and requirements within the utility industry related to usage data requests. Collaborate closely with utilities to gather and question data as needed, leveraging advanced analytical and negotiation skills to obtain comprehensive and accurate information. Communicate system issues and outages to the Sales and Sales Support team.
• Influential Stakeholder Engagement: Respond to Salesforce cases requesting usage data, exhibiting advanced expertise in retrieving and validating data. Collaborate with internal and external stakeholders, including cross-functional teams and utility providers, to ensure seamless data exchange and accurate insights. Serve as a subject matter expert, providing guidance and expertise on complex data-related issues.
• Process Optimization: Take a lead role in driving process improvements, leveraging advanced expertise to identify opportunities for efficiencies and automation. Assist with the development and implementation of new processes, including cleanup projects, new hire training, and the optimization of existing systems. Make data-driven recommendations to stakeholders regarding process enhancements and identify areas for improvement.
• Resource and Escalation Point: Serve as an internal resource and initial escalation point to resolve challenges related to data validation processes and system synchronization. Act as a liaison between sales, internal functional groups, and customers/channel partners to ensure open communication and coordination throughout the data validation process and contract execution.
• Travel required as necessary to meet business needs.
• In-person attendance for trainings, team meetings, and other moments that matter.
  
  

Business Data Analyst Ii - Primary Duties And Accountabilities

• Data Analysis: Maintain processes related to the flow of historical usage data, troubleshoot issues that may arise throughout the prospect-to-customer life cycle, and ensure data accuracy and consistency. Utilize advanced data interpretation techniques to identify inconsistencies and improve overall data quality. Question any inconsistencies and manage Electronic Data Interface (EDI) requests with utilities. Demonstrate expertise in troubleshooting complex EDI and data-related issues. Mitigate potential financial risks by proactively identifying and addressing any data inconsistencies or gaps.
• Utility Knowledge and Relationship Management: Stay updated with changes in utility requirements for usage data requests. Collaborate with utilities to retrieve data. Question data related to historical usage and other associated properties data. Work with the Operations team to establish standards across utilities and ensure compliance.
• Influence Stakeholder Engagement: Respond to Salesforce cases requesting usage data, exhibiting expertise in retrieving and validating data. Collaborate with internal and external stakeholders, including cross-functional teams and utility providers, to ensure seamless data exchange and accurate insights. Serve as a subject matter expert, providing guidance and expertise to make recommendations on complex data-related issues.
• Process Optimization: Take a lead role in driving process improvements, leveraging expertise to identify opportunities for efficiencies and automation. Assist with the development and implementation of new processes, including cleanup projects, new hire training, and the optimization of existing systems. Make data-driven recommendations to stakeholders regarding process enhancements and identify areas for improvement.
• Resource and Escalation Point: Serve as an internal resource and initial escalation point to resolve challenges related to data validation processes and system synchronization. Act as a liaison between sales, internal functional groups, and customers/channel partners to ensure open communication and coordination throughout the data validation process and contract execution.
• Travel required as necessary to meet business needs.
• In-person attendance for trainings, team meetings, and other moments that matter.
  
  

Business Data Analyst i - Primary Duties And Accountabilities

• Data Analysis: Review and interpret historical prospect usage data, questioning any inconsistencies and managing Electronic Data Interface (EDI) requests with utilities where necessary. Troubleshoot EDI and data-related issues. Retrieve and verify historical usage data from utility websites and review invoice copies. Ensure accurate and timely uploading of prospect historical usage to internal systems. Mitigate potential financial risks by proactively identifying and addressing any data inconsistencies or gaps.
• Utility Knowledge and Relationship Management: Stay updated with utility requirements for usage data requests. Collaborate with utilities to retrieve data. Question utility data as needed based on industry expertise.
• Influence Internal Stakeholders: Respond to Salesforce cases requesting usage data, working with both internal and external stakeholders to retrieve and validate data. Identify and elevate forecasting inconsistencies as needed to ensure accurate pricing.
• Process Improvements: Assist with ad hoc requests for process improvements, such as cleanup projects, new hire training, and development of process efficiencies. Identify and document new processes, making recommendations to leadership for improvement.
• Travel required as necessary to meet business needs.
• In-person attendance for trainings, team meetings, and other moments that matter.
  
  

Senior Business Data Analyst - Minimum Qualifications

• 4-year degree and minimum of 5 years of relevant experience.
• A minimum of 9 years of relevant experience in lieu of a 4-year degree.
• Experience delivering solutions using technical and analytical abilities, such as: SQL, Excel macros, Power BI, C++, etc.
• 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.
  
  

Business Data Analyst Ii - Minimum Qualifications

• 4-year degree and minimum of 2 years of relevant experience.
• A minimum of 4 years of relevant experience in lieu of a 4-year degree.
• 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, fostering effective teamwork and rapport with employees and customers.
• Ability to build and maintain relationships internally and with customers/channel partners.
• Flexibility and ability to work under multiple daily deadlines.
• Commitment to maintaining confidentiality of all information.
  
  

Business Data Analyst i - Minimum Qualifications

• 4-year degree
• A minimum of 2 years of relevant experience in lieu of a 4-year degree.
• 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, fostering effective teamwork and rapport with employees and customers.
• Ability to build and maintain relationships internally and with customers/channel partners.
• Flexibility and ability to work under multiple daily deadlines.
• Commitment to maintaining confidentiality of all information.
  
  

Senior Business Data Analyst - Preferred Qualifications

• Experience in a fast-paced, team-oriented work environment, including exposure to high-volume data analysis and support operations.
• Previous experience in the energy industry or a related field, demonstrating comprehensive knowledge of industry-specific data requirements and practices.
• Reporting and dashboard knowledge in Salesforce.
  
  

Business Data Analyst Ii - Preferred Qualifications

• Experience in a fast-paced, team-oriented work environment, including exposure to high-volume data analysis and support operations.
• Proficiency in SQL, Python, Power BI, Excel macros, and C++ is highly advantageous, allowing for advanced data manipulation, modeling, and visualization.
• Previous experience in the energy industry or a related field, demonstrating comprehensive knowledge of industry-specific data requirements and practices.
  
  

Business Data Analyst i - Preferred Qualifications

• Experience in a fast paced and team-oriented work environment.
• Knowledge of SQL, Python, Power BI, Excel macros, and C++ is advantageous.
• Previous experience in the energy industry.