Enterprise Data Analyst in Chicago, Illinois at OnSite Partners LLC

About OnSite Partners

OnSite Partners’ mission is to empower each customer in achieving success through the design and delivery of collaborative, creative and comprehensive energy solutions.

Job Overview:

The Enterprise Data Analyst plays a key role in managing, curating, and optimizing client utility data and asset production data to support accurate billing, reporting, analysis, and client delivery. This position blends SQL data operations, client-facing support, and business analysis, serving as a key liaison between Data Quality, Client Program Management, and internal operations teams.

This role is responsible for ensuring the accuracy, completeness, and usability of client utility billing data and other enterprise data, resolving data-related issues, supporting client data intake, and contributing to the continuous improvement and documentation of data processes, standards, and controls.

Key Responsibilities:

1. Utility Data Management & Data Quality

• Curate, validate, and maintain utility billing datasets (bill, service, charge-level, and production-level)
• Monitor data ingestion and identify gaps, inconsistencies, and anomalies for both client and asset data.
• Investigate and resolve data issues (missing bills, incorrect charges, mismatches)
• Partner with Data Quality and leadership to escalate and resolve systemic data issues
• Maintain data health metrics (e.g., completeness, error rates, expected vs. received bills)

2. Client Data Onboarding & Ongoing Support

• Support onboarding of client data, including intake, transformation, and validation
• Ensure data is standardized, complete, and aligned with internal models and rules
• Act as liaison between Client Program Management and Data Quality for issue resolution
• Respond to client inquiries and participate in discussions regarding billing data and discrepancies
• Coordinate with clients, vendors, and internal teams to resolve onboarding and ongoing data issues

3. Operations & Process Execution

• Support operational workflows for billing validation, correction tracking, and issue resolution
• Contribute to cross-functional efforts to improve operational efficiency and data accuracy
• Ensure consistent execution of business rules and workflows across datasets
• Assist in preparing datasets for reporting and downstream operational use

4. Data Governance, Documentation & Continuous Improvement

• Document processes, business rules, and standard operating procedures
• Maintain data standards, definitions, and governance controls (traceability, auditability)
• Identify opportunities for automation, process improvement, and efficiency gains
• Support development of reporting, dashboards, and analytics to monitor performance and data quality through SQL, PowerBI and other reporting languages/tools.

Qualifications:

Preferred Qualifications