Regulatory Data Analyst – Utility Transformation

Contract Regulatory Data Analyst supporting a high visibility regulatory transformation initiative by delivering accurate, well-validated data for regulatory filings and discovery requests, in collaboration with Compliance Analysts and cross-functional teams.

Responsibilities

• Address regulatory discovery requests by pulling data from diverse systems, performing analysis, and validating results
• Assemble datasets covering customer accounts, billing, credit inquiries, and energy usage
• Perform data validation and quality checks to ensure accuracy and completeness
• Collaborate with Compliance Analysts to support regulatory and legal responses
• Produce clear, structured data outputs suitable for formal filings and responses
• Coordinate with internal regulatory teams, case specialists, and project stakeholders
• Assist with reporting and dashboard development as needed using Power BI

Requirements

• Advanced Excel skills including pivot tables and handling large datasets
• Experience in data analysis, validation, and quality assurance
• Experience with Power BI or similar BI and reporting tools
• Experience working with enterprise systems such as Salesforce or equivalent platforms
• Strong analytical and problem-solving abilities
• Minimum 7 years of relevant work experience
• Contract position

Technologies

• Microsoft Excel
• Power BI
• Salesforce

Compensation

Hourly rate: USD 69

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Spending accounts
• Life insurance
• Voluntary plans
• 401(k) plan

Typical Day

• Receive and prioritize incoming discovery requests from regulatory teams
• Pull and consolidate data from various internal systems
• Validate datasets and investigate discrepancies
• Work with compliance and regulatory partners to align on response requirements
• Prepare data deliverables for legal and regulatory submissions
• Collaborate with cross-functional team members across the transformation program

Team & Work Environment

• Part of a large, cross-functional transformation initiative
• Collaborates across multiple program teams, referred to as towers
• Key collaborators include: Compliance Analysts, regulatory and legal teams, case specialists, and operating company managers
• Project leadership involvement in a fast-paced, highly collaborative setting with strong coordination between technical and business teams

Work Schedule

• Full-time, 40 hours per week
• Hybrid schedule: onsite Tuesday through Thursday; remote Monday and Friday
• Office locations: Minneapolis, MN (preferred – 414 building)
• Office locations: Denver, CO (alternative)