Grid Data Analyst

General Purpose of Job

The Grid Data Analyst position is responsible for providing information, assistance, and technical resources to cooperative system end users. This role supports utility operations by analyzing data from systems such as Outage Management systems (OMS), Geographic Information Systems (GIS), Customer Information Systems (CIS), Supervisory Control and Data Acquisition (SCADA), and Meter Data Management Systems (MDMS). The analyst works across business and technology teams to understand business processes, define analytical requirements, validate data products, and deliver accurate, usable, secure reports and dashboards that align with enterprise data governance standards.

• Minimum: Four‑year bachelor’s degree in data analytics, information systems, business, finance, accounting, computer science, mathematics, statistics, engineering, or a related field.
• Preferred: Experience with electric utility operations, power systems, grid modernization, outage and reliability analytics, Power BI, Microsoft Fabric, Power Platform, SQL, Python, Spark, Power Query, data modeling, and data governance.
• Job‑related experience may be substituted for the required education on a year‑for‑year basis.

• Minimum: Three (3) years of progressively responsible experience in data analysis, business intelligence, reporting, operations analytics, or related analytical work.
• Preferred: Experience with modern cloud analytics platforms (Microsoft Fabric, Azure data services, Databricks, Snowflake, Qlik, Talend Cloud or comparable lakehouse/warehouse platforms).
• Preferred: Experience with Power BI semantic models, report development, paginated reports, Power Query, DAX, SQL, Python, Spark, documentation, data validation, source‑to‑target mapping, business metric definition, and cross‑functional requirements gathering.
• Preferred: Experience with Power Platform tools such as Power Automate, Power Apps, Dataverse, and Copilot Studio for analytics‑driven workflows.
• Preferred: Utility, cooperative, grid operations, outage, reliability, AMI, billing, or asset analytics.
• Preferred: Experience with OMS, GIS, CIS, MDMS, AMI, SCADA, ADMS data and with feeder, circuit, substation, transformer, meter, service point, outage, and reliability datasets.
• Preferred: Experience with utility KPIs such as SAIDI, SAIFI, CAIDI, outage duration, restoration performance, load, billing, and meter‑read quality.

• Ability to operate office equipment, including personal computer, printers, copy machines, and telephones.
• Ability to work irregular hours and flexible scheduling, including reporting to work on short notice during emergency situations.
• Successful completion of pre‑employment background check, physical and drug screen.

• Partner with stakeholders to define business questions, metrics, dimensions, filters, report layouts, semantic model needs, drill paths, and acceptance criteria.
• Translate business requirements into source‑to‑target mapping input, data quality rules, report specifications, and semantic model requirements.
• Determine the appropriate data product category—operational report, Power BI semantic model, gold data product, certified platinum product, automation, or ad‑hoc analysis—and document assumptions, exclusions, business rules, and source‑system limitations.
• Perform data querying, validation, and reconciliation: write SQL, DAX, Power Query M, and report dataset queries; validate row counts, aggregate totals, distinct keys, required fields, duplicate records, date windows, joins, unions, and filters; reconcile reports and semantic model outputs to approved source totals and documented business rules.
• Support unit, user acceptance testing, release validation, defect triage, and document validation evidence, exceptions, known limitations, and sign‑off notes.
• Build, enhance, and maintain Power BI reports, dashboards, semantic models, measures, and data visualizations; develop paginated reports; use Power Query to connect, shape, combine, and parameterize data.
• Develop and support Power Automate workflows for alerts,…