Lead Analyst IT

This job posting is no longer active.

Location: WASHINGTON, DC, United States
Organization: Exelon Business Servcs Co, LLC
Job ID: 222519
Date Posted: Feb 28, 2020

Share: mail

Job Description


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 100 company. Establish yourself in a place where you can truly shine and create a brighter, more sustainable tomorrow. Energize your career at Exelon!



The Office of the CIO (CIO) is charged with leading the IT transformation and building an organization that ensures the standardization of processes and tools, that enable the effective and efficient delivery of IT solutions to our business partners. IT Business Office within the OCIO plays an instrumental role with driving IT Financial Management and Cost Management model process and continuous improvement while driving governance, standards, and tools across IT.

The IT Lead Analyst will be primarily responsible for consumption-based billing process (IT Rate x Quantity Billing), associated data modeling and cumulating application total cost of ownership.  Responsible for ensuring the proper allocation of infrastructure costs during the annual budgeting process and directs the monthly Rate x Quantity billings.  Coordinating with stakeholders to identify reporting needs of Service Portfolio Owners, Budgets Owners, IT Bill Recipients and IT Leadership in accordance with current Technology Business Management (TBM) standards.



Lead annual and monthly rate times quantity billing processes 40%:

- Manage adjustments and data modeling based on rate times quantity changes

- Development and design of new services and retirement of old

- Support annual Chart of Accounts analysis and external benchmark comparison

- Ensures Accounting and Finance requirements are addressed, and all vested parties aligned

- Catalogs existing reporting and makes reporting available to customers through SharePoint and manages User Experience and navigation in Apptio and BI reports


Proactive monitoring, management and adjustment of portfolio investments to maintain enterprise wide visibility into portfolio financials and overall health, support planning and execution of work, and helping with investment decisions based on strategic alignment of both baseline and project work in the portfolios 30%:

- Associating infrastructure expenses to applications and application services

- Design standard and ad-hoc reporting from modeling within Apptio to support cost transparency based on management and customer needs


Develop, maintain and support processes to effectively monitor, assess and evaluate performance adherence to technology business management standards 20%:

- Document data model architectural changes

- Data accuracy testing and process documentation development

- Balanced score card development and key performance indicators for measuring success

- Identification of innovation and continuous improvement opportunities


Support IT Business Office Functional Area responsibilities for IT Financial Management and Cost Management 5%:

- Create and gain alignment across OCIO and Peer groups for process documentation across core functional areas

- Support peer group and community of practice activities as a Subject Matter Expert 


Other responsibility as directed by Management. 5%




- Bachelor’s degree in a quantitative discipline (e.g. Computer Science, Mathematics, Engineering, or Finance or Accounting)

- At least 5 years of analyst experience.

- Advanced Microsoft Excel skills including complex formula development, pivot tables and scenario modeling.

- Demonstrated ability to develop multiple solutions to moderately complex problems and recommend the best solution to the business and project team.

- Run simulation analyses on scenarios to evaluate proposed process changes.

- Basic financial understanding including budgeting, variance analysis and financial statements

- Experience and deep knowledge of the business processes.

- Experience engaging with and supporting senior level leadership

- Demonstrated strategy planning and customer engagement skills and experience leading teams and people through change.

- Excellent consultative skills, including teamwork, facilitation, and negotiation. Advanced interpersonal skills, communications skills, and presentation skills.

- Demonstrated ability to present and discuss complex financial management information in a way that establishes rapport, persuades others, and gains understanding and approval

- Excellent communications skills and ability to work effectively with all levels of IT and business management and with vendors


- MBA or other advanced degree in data analytics

- Experience with Application Portfolio Management tools or ServiceNow

- Experience with Apptio Cost Transparency and Technology Business Management

- Advanced skills constructing PowerBI reporting and/or relational database design

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

EEO is the Law Poster

Share: mail

Similar Jobs

Lead Analyst IT

WASHINGTON, DC, United States
Exelon Business Servcs Co, LLC

Lead Analyst IT - Real Time Systems

WASHINGTON, DC, United States
Exelon Business Servcs Co, LLC

Lead Analyst IT - Wireless Network Operations

WASHINGTON, DC, United States
Exelon Business Servcs Co, LLC

Frequent Job Searches

Recently Viewed Jobs

Most Recent Job Searches

Relevant Jobs