Accounting, Analysis Skills, Application Integration, Application Programming Interface (API), Billing, Business Analysis, Business Intelligence, Business Solutions, Cloud Computing, Crystal Reports, Data Analysis, Data Lake, Data Management, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, Enterprise Applications, Finance, Geographic Information Systems (GIS), Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Internet Security, Java, Microsoft C# (C Sharp), Needs Assessment, Operational Support, Organizational Skills, Power BI, Problem Solving Skills, Process Improvement, Python Programming/Scripting Language, Quality Management, R Programming Language, Reliability Engineering, Reporting Dashboards, Reporting Skills, Requirements Management, SQL (Structured Query Language), Scripting (Scripting Languages), Secure/SSH File Transfer Protocol (SFTP), Snowflake Schema, Software Administration, Supervisory Control and Data Acquisition (SCADA), System Operations, Tableau, Windows PowerShell
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:
- Develop and maintain dashboards, reports, and data extracts using SQL, Power BI, Tableau, Crystal Reports, and related tools.
- Translate business requirements into accurate reporting, analytics, and technical solutions for technical and non-technical users.
- Extract, transform, validate, and analyze data from enterprise systems, databases, APIs, SFTP sources, and other approved sources.
- Develop and support ETL/ELT workflows, API-based integrations, and custom scripts or automations using SQL, Python, PowerShell, C#, Java, or similar tools.
- Support and troubleshoot enterprise applications and workflows, including CIS, FIS, GIS, AMI, OMS, SCADA, Laserfiche, and related systems.
- Assist with data lake, warehouse, and reporting platform practices for data quality, governance, security, accessibility, and performance.
- Partner with departments and vendors to understand needs, present findings, resolve issues, and recommend process or reporting improvements.
- Work with IT and Cybersecurity to ensure applications, integrations, and data processes follow security and compliance expectations.
- 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.
Job Posted by ApplicantPro