JR Business Analyst
Who We Are
Founded in 2007, DTI (Diversified Technology, Inc.) is a successful African American owned IT Consulting/Staffing firm based in Chicago's Loop.
What We Do
We focus on providing delivery, staffing, and supported services such as enterprise integration/implementations including, but not limited to, CRM, EAM, ERP, PMO, and QA. We service clients in SLED (state/local gov't & education), financial services, fortune, public utility, as well as regularly partnering with Big 4 SI partners.
Are you a Jr Business Analyst looking for your next opportunity? If so, we want to speak to you. DTI has an immediate need for a Jr Business Analyst for a 5Month contract in Chicago, IL.
Must work on our W2
Local consultant prefered
Onsite in Chicago 1- 4 client visits during the project
Summary
The Demand Response (DR) Coordination Analyst will be part of a 4 person Client Utilities Strategy team partnered with ComEd's Clean Energy Solutions to evolve and enhance one of the nation's largest behavioral DR opt-in programs called Peak Time Savings ("PTS”). The program provides residential electric utility customers the opportunity to earn bill credits on their energy bills for voluntarily shifting and reducing their energy use on days with Peak Time Savings Hours between May to October. Participants are notified in advance of a Peak Time Savings Hours event via their preferred notification method(s). The DR Coordination Analyst will take direction from the Client DR program consultant and senior manager to perform DR seasonal readiness preparations, DR event coordination and post event/season reconciliation, validation and leadership reporting responsibilities.
Responsibilities
Development of DR Event forecasting reports
Hosting DR forecasting meetings twice a week as needed
Assist with Drive the creation a program weekly summary report containing customer participation, billing, and load reduction results
Assist with coordinating DR events to include the following (which involve having access to customer PII data)
Drafting internal communications to stakeholders, such as business and IT
Monitoring customer inquiries
Assist with responding to customers
Develop post DR event summary reports
Manipulate and cross-compare large datasets via Excel to reconcile and analyze customer enrollments, notification preferences, behavioral reductions and bill credits
Maintain PowerBI dashboards and create data visualizations
Requirements
Business Analyst with 2-4 years in client facing project roles
Possess strong oral and written communication skills
Strong skills in Microsoft Office (Excel, Word, PowerPoint) including being comfortable with manipulatinglarge Excel workbooks (>350,000 rows), formulas, pivot tables and table joining (VLOOKUP, INDEX/MATCH)
Analytical thinking for translating data into informative reports, charts and visuals
Developing client leadership slideware (strong PowerPoint visuals)
Experience developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
Preferred: Utilities industry (gas/electric) experience is preferred
Preferred: Experience with Python web scraping is a plus
Pay rate: $46.61-$51.61hr
Please click on the link below for our company benefits
DTI is an Equal Opportunity Employer. We do not discriminate based on race, color, religion, sex, gender identity, sexual orientation, national origin, ancestry, age, disability, marital status, veteran status, or any other protected characteristic under Illinois state or federal law. All qualified applicants are encouraged to apply, and employment decisions are based solely on merit, qualifications, and business needs.
