Automation Solutions Engineer/Power Platform Developer

Universities of Wisconsin • Milwaukee, WI

8d • $83,400 - $109,000 • Hybrid

About The Position

The Office of Information Technology and Assessment (ITA) supports the mission of the UWM Office of Research and the Graduate School. The Graduate School is an administrative unit that supports a wide range of functions related to graduate education across UWM including admissions, graduation, and various other functions related to graduate education. The Office of Research supports the broad campus research mission, including compliance, extramural funding administration, strategic research planning, and a range of internal programs providing direct support to faculty and staff members, post-doctoral researchers, graduate students, and undergraduate students engaged in research activity.

The Graduate School
The Graduate School is an administrative office that supports a wide range of functions related to graduate education across UWM.
Manages graduate student admissions, matriculation, and graduation
Manages processing of cases of graduate student academic misconduct, dismissals, and appeals
Supports development and implementation of campus policies governing Graduate Academic Programs and students
Supports governance committees that develop graduate policies, review and approve curriculum, and conduct periodic program reviews
Supports the review and awarding of fellowships managed by The Graduate School
Supports graduate student recruitment and retention efforts
Supports data collection efforts for special projects

Division of Research:
The Office of Research, and its staff, are responsible for central research administration, oversight of research policy and compliance, and internal research development programs. The Office is part of The Chancellors Office and includes the Office of Sponsored Programs, the Office of Undergraduate Research, as well as several research centers.

This role will develop PowerApps and Power Automate solutions that meet business requirements and remain flexible and agile to work with similar software running on different platforms. The developer will connect data from various sources, design, implement, test, troubleshoot, and maintain complex business logic and workflows. Communication with nontechnical business users to translate process requests into specific business requirements is essential. The role also involves creating and maintaining technical documentation, troubleshooting data integrity issues, and managing multiple priorities in a dynamic environment.

Requirements

• Bachelor's degree in computing field or related field
• Minimum of 3 years of experience with Microsoft Power Automate and the Microsoft Power Suite, OR other similar software i.e. (Microsoft Power Automate, Ansible, Terraform, UiPath, Automation Anywhere, etc.)
• Evidence of 3+ years’ experience developing reports and dashboards using Microsoft Power BI or other industry standard tools (Tableau, Looker, Metabase)
• Demonstrated experience developing solutions using the Power Apps and Power Automate.
• Experience across the entire platform, PowerApps Canvas, Model Driven Apps, Power Automate flows
• Experience designing business processes and integrations between Microsoft and other applications
• Experience with SQL
• Experience with Azure cloud services.
• Experience with Azure DevOps
• Extensive experience using Power BI and Power Apps
• Experience with Power Automate
• Experience with M, DAX and SQL.
• Experience with ETL design, analytics and reporting
• Experience with developing and using data models
• Knowledge of RESTful APIs
• Experience with data development and reporting tools such as Microsoft Power BI, Tableau, Oracle BI

Nice To Haves

• Graduate degree in computing fields, information sciences, similar field.
• 5 years of experience developing Business Automation solutions using Microsoft Power Automate or similar software.
• 5 years of experience developing reports and dashboards using Microsoft Power BI or other industry standard tools (Tableau, Oracle BI, Qlik, Salesforce, SAS, SAP)
• Evidence of 3+ years' experience working in a higher education environment at a research-focused university.
• Extensive knowledge of the Microsoft Power Apps Suite, including Power Automate, Power Apps, DataVerse, DataFlows, SharePoint, and Microsoft Power BI.
• Experience with developing dashboards in Microsoft Power BI or similar platforms.
• Experience designing and building forms using Microsoft Power Apps.
• Knowledge of JSON, PowerShell, VBScript.
• Proven abilities to take initiative and be innovative
• Strong analytical, conceptual and problem-solving abilities
• Programming / scripting experience and knowledge of software development.
• Effective Project Management experience.

Responsibilities

• Develop PowerApps and Power Automate solutions that meet business requirements and remain flexible and agile to work with similar software running on different platforms.
• Connect data from different sources such as but not limited to Oracle, MariaDB, Amazon RedShift, Microsoft Dataverse, and SharePoint.
• Design, implement, test, troubleshoot and maintain complex business logic and workflows using Power Automate or similar software.
• Communicate with nontechnical business users to translate process requests into specific business requirements that will be used to implement the required automations and business intelligence solutions.
• Create and maintain technical documentation for Power Automate Flows or similar software as needed.
• Detail-oriented mindset and ability to troubleshoot data integrity issues.
• Ability to manage multiple priorities and assess and adjust quickly to changing priorities as communicated by The Division of Research and The Graduate School.
• Serves as technical lead for one or more aspects of the system.
• Analyze requirements and communicates and coordinates with staff and internal stakeholders related to the system and/or project.
• Develop, programs, and/or deploy automation workflows for deployment, configuration, and/or monitoring of systems/services.
• Manage, maintain, select, and develop automation tools and infrastructure, including security configurations.
• Performs integration, migration, configuration, and security of existing applications and services into automated infrastructures in collaboration with other campus units such as IT, HR, and finance as needed.
• Serves as a subject matter expert to internal stakeholders, providing guidance and training to staff.

Benefits

• This position does not offer visa sponsorship. Applicants must be legally authorized to work in the United States at the time of hire. Selected candidates will be required to verify eligibility to work in the United States by completing the required I-9 form upon hire.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level