Data Analyst & Automation Engineer

The Data Analyst & Automation Engineer position is part of Wheatland Electric Cooperative, Inc.’s Information Technology team in Garden City, KS. This onsite role focuses on creating automation solutions, delivering reporting and dashboards, and supporting data platforms and Operational Technology environments while adhering to cybersecurity, change-management, and compliance expectations.

Responsibilities

• Review manual workflows to identify automation opportunities and process improvements.
• Design, test, deploy, and support automated solutions using PowerShell, Python, Power Automate, Power Universal, and related technologies.
• Create and maintain scripts, scheduled jobs, integrations, automation services, and application programming interfaces.
• Develop 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 build reports and visualizations to 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.
• Develop and support operator dashboards, reporting displays, data tracking, and software applications within Rockwell FactoryTalk environments.
• Monitor automated processes, troubleshoot failures, perform root-cause analysis, and implement corrective actions.
• Comply with established cybersecurity, change-management, and compliance requirements.
• Train and support employees using automated workflows and self-service reporting tools.
• Attend required safety meetings, participate in training programs, and support Cooperative events.

Requirements

• 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 and Rockwell FactoryTalk environments

Benefits

• Competitive pay
• Excellent benefits
• Professional development opportunities
• Supportive team environment