Enterprise Data Analyst

Position Purpose:

Provides business intelligence, data analysis, light development, and enterprise application support by turning operational data into accurate, usable insights. Develops reports, dashboards, data pipelines, API-based integrations, and custom scripts while improving data quality, workflow efficiency, and reporting consistency across the Cooperative.

Job Dimensions:

Internal Responsibility - Works with IT, Cybersecurity, Member Services, Finance, Accounting, Billing, Engineering, Operations, System Operations, and other departments to gather reporting needs, support application processes, and improve data use.

External Responsibility - Coordinates with software vendors and data providers as needed for enterprise applications, reporting tools, integrations, APIs, and data platforms.

Principal Accountabilities:

1. Develop and maintain dashboards, reports, and data extracts using SQL, Power BI, Tableau, Crystal Reports, and related tools.
2. Translate business requirements into accurate reporting, analytics, and technical solutions for technical and non-technical users.
3. Extract, transform, validate, and analyze data from enterprise systems, databases, APIs, SFTP sources, and other approved sources.
4. Develop and support ETL/ELT workflows, API-based integrations, and custom scripts or automations using SQL, Python, PowerShell, C#, Java, or similar tools.
5. Support and troubleshoot enterprise applications and workflows, including CIS, FIS, GIS, AMI, OMS, SCADA, Laserfiche, and related systems.
6. Assist with data lake, warehouse, and reporting platform practices for data quality, governance, security, accessibility, and performance.
7. Partner with departments and vendors to understand needs, present findings, resolve issues, and recommend process or reporting improvements.
8. Work with IT and Cybersecurity to ensure applications, integrations, and data processes follow security and compliance expectations.
9. Evaluate tools, technologies, and reporting processes to improve efficiency, reliability, and decision-making.

Minimum Requirements:

Education and Experience: Bachelor's degree in Information Technology, Data Analytics, Business Analysis, or related field preferred; or equivalent relevant experience. At least two years of relevant experience required; three or more years in BI, data analytics, reporting, or enterprise applications preferred.

Operational Experience: Experience building dashboards/reports, writing SQL, analyzing data, supporting business applications, and working with users to define requirements. Some developer or scripting experience preferred, especially with API integrations, custom scripts, ETL/ELT, SFTP, databases, data warehousing, web scraping, or utility systems.

Knowledge/Skills/Abilities: Working knowledge of SQL Server, Oracle, Power BI, Tableau, Crystal Reports, Python, PowerShell, C#, Java, XML, JavaScript, and/or related tools. Strong analytical, troubleshooting, documentation, communication, and coordination skills. Ability to manage priorities, protect data integrity and security, and explain technical information clearly. Snowflake, Alteryx, R, cloud data platforms, or BI/SQL certifications preferred.