Data Analyst & Automation Engineer
Job Description
Join Wheatland Electric Cooperative, Inc. in the Information Technology team to deliver automation, reporting, and data platform support on-site in Garden City, KS.
Responsibilities
- Review manual workflows and identify automation and process improvement opportunities.
- Design, test, deploy, and support automation solutions using PowerShell, Python, Power Automate, Power Universal, and related technologies.
- Build and maintain scripts, scheduled jobs, integrations, automation services, and application programming interfaces.
- Create and maintain reports, dashboards, and data visualizations using Power BI, Crystal Reports, Splunk, SQL, and related tools.
- Collect business requirements, analyze and validate data, define data-quality standards, and produce reports that support business decisions.
- Maintain data dictionaries, data-lineage records, and technical documentation.
- Administer and support SQL Server, the Power BI Data Gateway, and cloud-based and on-premises Splunk environments.
- Support operator dashboards, reporting displays, data tracking, and software applications in Rockwell FactoryTalk environments.
- Monitor automated processes, troubleshoot failures, perform root-cause analysis, and implement corrective actions.
- Follow established cybersecurity, change-management, and compliance requirements.
- Train and support employees using automated workflows and self-service reporting tools.
- Attend required safety meetings, training programs, and Cooperative events.
Requirements
- Minimum 5 years of experience.
- Associate degree in Computer Science or Statistics (or related field), or five years of an equivalent combination of training and experience.
- Experience with Power BI, SQL, Python, PowerShell, or other scripting languages.
- Knowledge of relational databases, data governance, data quality, data warehousing concepts, and business intelligence and reporting tools.
- Strong analytical, problem-solving, communication, organizational, and time-management skills.
- Ability to analyze workflows, identify inefficiencies, and develop effective automation solutions.
- Ability to translate complex data into meaningful insights and communicate results to technical and nontechnical audiences.
- Ability to maintain confidentiality and independently manage multiple priorities.
- Ability to pass a background check, pre-employment drug test, and ongoing random drug and alcohol testing.
Technologies
- PowerShell
- Python
- Power Automate
- Power Universal
- Power BI
- Crystal Reports
- Splunk
- SQL
- SQL Server
- Power BI Data Gateway
- Rockwell FactoryTalk
- Rockwell FactoryTalk environments
Benefits
- Competitive pay
- Excellent benefits
- Professional development opportunities
- Supportive team environment