Junior Business Analyst Utilities

Junior Business Analyst – Utilities (Contract)

Contract Length: 12 Months

Location: Houston, TX

Work Setup: Hybrid (Wednesdays in the Houston Office)

Pay Rate: $25/hour W2

Join a leading retail energy company supporting Mass Market Operations. We are seeking a Junior Business Analyst – Utilities to support Government Aggregation operations by analyzing enrollment and contract data, performing quality control, identifying operational issues, and partnering with internal teams to ensure accurate and compliant utility processes.

This is an excellent opportunity for an analytical professional looking to grow their career in the retail energy industry.

Junior Business Analyst – Utilities Responsibilities

• Review and validate Government Aggregation accounts, contracts, and enrollments to ensure accuracy and compliance with utility requirements.
• Analyze large datasets to identify discrepancies, trends, and opportunities for process improvements.
• Perform high-volume quality control on customer enrollments, contract setup, and account maintenance activities.
• Investigate and resolve data exceptions by collaborating with internal departments and utility partners.
• Utilize advanced Microsoft Excel functions, including VLOOKUP, XLOOKUP, and Pivot Tables, to analyze and reconcile operational data.
• Write and execute basic SQL queries to retrieve, analyze, and validate data for business and operational reporting.
• Ensure customer and enrollment records are complete, consistent, and audit-ready.
• Lead weekly stakeholder meetings to present Government Aggregation performance metrics, trends, and key operational issues.
• Support business operations by documenting findings, recommending improvements, and ensuring timely resolution of issues.

Junior Business Analyst – Utilities QualificationsRequired Qualifications

• Retail energy industry experience is required.
• Experience supporting Government Aggregation (Gov Agg) programs is preferred.
• Advanced Microsoft Excel skills, including experience working with large datasets using VLOOKUP, XLOOKUP, Pivot Tables, and other analytical functions.
• Working knowledge of SQL, including the ability to write basic queries, analyze data, and identify trends (developer experience not required).
• Strong analytical, problem-solving, and organizational skills.
• Exceptional attention to detail with the ability to maintain accuracy in a high-volume environment.
• Excellent verbal and written communication skills, including experience presenting information to business stakeholders.
• Ability to prioritize multiple tasks while working independently and collaboratively across cross-functional teams.

Preferred Qualifications

• Experience with utility enrollments, contracts, billing processes, or regulated market operations.
• Previous experience in business analysis, operations, quality control, or data analysis within the utilities or retail energy industry.

If you're a detail-oriented Junior Business Analyst – Utilities who enjoys working with data, solving operational challenges, and supporting business processes, we'd love to hear from you. This 12-month contract offers an excellent opportunity to build your business analysis experience while making an immediate impact within a dynamic retail energy organization.

We look forward to reviewing your application!

Skills

Analysis Skills, Billing, Business Analysis, Business Operations, Business Processes, Business Support, Communication Skills, Contract Analysis, Cross-Functional, Data Analysis, Data Quality, Data Sets, Detail Oriented, Documentation, Energy & Utilities, Establish Priorities, Government, Government Sales, Identify Issues, Maintain Compliance, Microsoft Excel, Multitasking, Operational Audit, Operational Control, Operational Support, Operations Control, Performance Metrics, Pivot Tables, Presentation/Verbal Skills, Problem Solving Skills, Process Improvement, Quality Control, Query Analysis, Reconciliation, Regulatory Compliance, Retail, SQL (Structured Query Language), Time Management, Trend Analysis, Vlookups, Writing Skills

About the Company

Crossfire Consulting Corporation