Grid Data Analyst
City of Lincoln
- Sumterville, Alabama, United States
- Sumterville, Alabama, United States
À propos
Minimum Required Qualifications and Competencies Education
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.
Experience
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.
Other Requirements
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.
Essential Duties and Responsibilities
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, approvals, notifications, refresh support, report distribution, exception handling, and operational handoffs; support Power Apps, Dataverse, and Copilot Studio use cases where analytics outputs become guided actions or business workflows.
Maintain and contribute to data dictionaries, business glossaries, metric catalogs, source‑to‑target mappings, lineage notes, report inventories, and validation checklists; support metadata and governance practices for cataloging, ownership, certification, endorsement, sensitivity, access review, and quality evidence.
Work with data owners and stewards to align business definitions with system behavior and reporting needs; support master data management analysis for customer, account, product, location, device, meter, vendor, chart of accounts, or reference‑data quality issues.
Collaborate with data engineers to review transformations, validate data products, prioritize defects, and resolve data questions with operational, financial, customer, technology, compliance, and leadership teams.
Train users on reports, metrics, filters, data definitions, and appropriate interpretation; support release readiness, deployment validation, post‑release issue triage, and continuous improvement.
Analyze and reconcile grid, outage, meter, asset, service location, customer, billing, and reliability data to support operational reporting, regulatory reporting, reliability improvement, and executive decision‑making.
Legal and Equal‑Opportunity Statement Sumter Electric Cooperative is an Equal Employment Opportunity (EEO) Employer. All employment decisions are made without regard to age, race, color, religion, creed, sex, national origin, marital status, veteran status, the presence of any physical or mental disability, genetic information, or any other status or characteristic protected by federal, state, or local law.
SECO Energy participates in E‑Verify. E‑Verify electronically compares information entered on the Employment Eligibility Verification, Form I‑9, with records contained in Social Security Administration and Department of Homeland Security databases to verify the identity and employment eligibility of newly hired employees.
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.