Analyst, Data & Reporting

Exelon Baltimore , MD 21203

Posted 11 months ago

At Exelon, we've got a place for you!

Join the nation's leading competitive energy provider, with one of the largest electricity generation portfolios and retail customer bases in the country. You will be part of a family of companies that strives for the highest standards of power generation, competitive energy sales, and energy delivery. Our team of outstanding professionals is focused on performance, thought leadership, innovation, and the power of ideas that come from a diverse and inclusive workforce.

Exelon will provide you the tools and resources you need to design, build and enhance a successful career. We are also dedicated to motivating the success of our employees through competitive base salary, incentives, and health and retirement benefits.

Join Exelon and share your passion at a forward-thinking Fortune 150 company. Establish yourself in a place where you can truly shine and create a brighter, more sustainable tomorrow. Energize your career at Exelon!

Constellation is headquartered in Baltimore, with regional offices in Chicago, Houston, Kennett Square, Louisville, New York, and Omaha.

We develop energy management strategies that help customers buy, manage and consume energy.

Our retail unit is among the largest and most comprehensive in the industry with approximately 1 million residential customers that rely on our commitment to innovation, dependability, transparency, and service.

Our wholesale business serves utilities, municipalities and co-ops and features world-class risk management and energy trading capabilities.


This full-time, key position reports directly to the Supervisor, Partner Contact Management and is responsible for researching and compiling data on competitive pricing offers, compile and distribute KPI Scorecards and analyze customer feedback. In addition, this position is responsible for making recommendations and improvement based on data and report analysis.


  • Critical Reporting: Create, track and maintain critical, multiple, operational reports for the Customer Care and Marketing departments on a scheduled and ad hoc basis
  • 30%
  • Customer Satisfaction: Assign customer feedback from Fore See to ensure customer satisfaction goals are met. Review feedback and provide suggestions for process improvements
  • 30%
  • Service Ticket Management: Monitor service tickets created and assigned to Care, follow up with responsible parties and provide daily status report
  • 30%
  • Continuous Improvement: Make recommendations for improvements based on data and report analysis.
  • 5%
  • Reports and Presentations: Prepare Leadership level reports and presentations on customer trends, impacts and other ad hoc needs
  • 5%



  • Bachelor's degree preferred, although candidates with 3-5 or more years in equivalent business experience will be considered

  • Advanced skills with Microsoft Office applications (Word, Excel, PowerPoint and Access)

  • Ability to communicate effectively and professionally with internal and external parties at all levels within the organization

  • Obtain and analyze data without supervision and can reason through complex scenarios to recommend course of action or remediation

  • Effectively communicate with, develop and maintain strong cross functional relationships

  • Bachelor's degree in Business Administration, Finance, Management, Management Information Technology or Supply Chain Management


  • Prior experience in the retail energy industry and/or regulated energy industry

  • Prior experience in using CRM

  • Working knowledge of UDC/ISO market EDI transactions

  • Advanced skills in Microsoft Access and/or SQL database query development

  • Previous vendor management experience a plus


Level of independence, decision-making authority or strategic planning accountability: Medium

  • Analyzes data and workflow situations without supervision and determines course of action or remediation for complex service scenarios

Internal and external contact relationships: Key external contacts include Constellation Vendors. Key internal contacts include the Leadership Team, Retail Sales, Federal and State Regulatory and Policy Groups, Customer Care, Contract Administration, Billing, Pricing, Forecasting and Legal.

Exelon is proud to be an equal opportunity employer and employees or applicants will receive consideration for employment without regard to: age, color, disability, gender, national origin, race, religion, sexual orientation, gender identity, protected veteran status, or any other classification protected by federal, state, or local law.

VEVRAA Federal Contractor

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Analyst


Posted Today

VIEW JOBS 2/28/2020 12:00:00 AM 2020-05-28T00:00 Analytica is seeking a <strong>Data Analyst </strong>to support a federal government client in Baltimore, MD.   <a name="_Hlk13746221">Analytica has been recognized </a>by Inc. Magazine as the fastest-growing private US small business.  We work with U.S. government customers in health, civilian, and national security missions.  As a core member you’ll work with a diverse team of professionals to develop application systems for clients in a platform-diverse environment.  We offer competitive compensation with opportunities for bonuses, employer paid health care, training and development funds, and 401k match.<br /> <br /> <em><strong>Responsibilities: </strong></em> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Statistical analysis and model development using programming languages.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Work with project stakeholders and the software development team to develop data analysis and machine learning algorithms for business stakeholders.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Develop analytics solutions that are scalable, repeatable, effective, and meet the expectations of the decision-makers and stakeholders.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">irectly support users by developing advanced reporting and analytics.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Assisting users in choosing data sources and discovering new methods for achieving goals.</li> </ul> <br /> <strong><em>Basic Qualifications:</em></strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Bachelor’s Degree </li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">5+ years of experience in using statistical methodologies to identify vulnerabilities in the Medicare, Medicaid, and Managed Care programs.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Demonstrated experience and knowledge of health care information.  ICD-9 and ICD-10 codes, physician specialty codes, and provider/supplier identifiers.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience and proficiency in programming, web programming and data manipulation</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Knowledge of Medicare parts A, B, C, and D benefits.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience in the design, management, and oversight of databases.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Proficiency in SAS, SQL, Microsoft Access and Microsoft Excel.</li> </ul> <strong>About</strong> <a href="" target="_blank"><strong>ANALYTICA</strong></a>: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD, the company is an established <a href="" target="_blank">SBA certified HUBZone</a> and <a href="" target="_blank">8(a) small business</a> that has been recognized by <em>Inc. Magazine</em> each of the past three years as one of the 250 fastest-growing companies in the U.S.  Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at <a href="" target="_blank">CMMI® Maturity Level 3</a> and is an <a href="" target="_blank">ISO 9001:2008 certified</a> provider. Analytica Baltimore MD

Analyst, Data & Reporting