Automation Solutions Engineer/Power Platform Developer

Universities of Wisconsin; Milwaukee (WI); On-site; USD 90,000 - 130,000; Full time

Job summary

Universities of Wisconsin is seeking an Automation Solutions Engineer/Power Platform Developer to design and implement automation workflows, develop PowerApps and Power Automate flows, and lead automation initiatives across departments.

You will connect data from Oracle, MariaDB, RedShift, Dataverse, and SharePoint, develop reliable business logic, and document architectures. This role requires collaboration with IT, HR, and finance and acts as a technical lead for key system components.

Qualifications

• Demonstrated experience developing Power Apps and Power Automate solutions.
• Experience across the platform (PowerApps Canvas, Model Driven Apps, Power Automate flows).
• Experience designing business processes and integrations between Microsoft and other applications.
• Experience with SQL and Azure cloud services.
• Extensive experience using Power BI and Power Apps.
• Experience with M, DAX and SQL; 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.

Responsibilities

• Develop PowerApps and Power Automate solutions that meet business requirements and remain flexible.
• Connect data from sources such as Oracle, MariaDB, RedShift, Dataverse, and SharePoint.
• Design, implement, test, troubleshoot and maintain complex business logic and workflows using Power Automate.
• Communicate with nontechnical users to translate requests into requirements for automations and BI solutions.
• Create and maintain technical documentation for Power Automate Flows or similar software.
• Detail-oriented mindset and ability to troubleshoot data integrity issues.
• Manage multiple priorities and adapt to changing priorities as communicated by divisions.
• Serve as technical lead for one or more aspects of the system.
• Analyze requirements and coordinate with staff and stakeholders.
• Develop, program, and deploy automation workflows for deployment, configuration, and monitoring.
• Maintain automation tools and infrastructure, including security configurations.
• Perform integration, migration, configuration, and security of apps into automated infrastructures with other campus units.
• Provide guidance and training to staff as a subject matter expert.

Skills

Power Apps

Power Automate

Azure

SQL

RESTful APIs

Power BI

Data modeling

ETL

Tools

Oracle

MariaDB

Microsoft Dataverse

SharePoint

Azure DevOps

Job description

Current Employees: If you are currently employed at any of the Universities of Wisconsin, log in to Workday to apply through the internal application process.

Position Title:

Automation Solutions Engineer/Power Platform Developer

Job Category:

Academic Staff

Employment Type:

Regular

Job Profile:

DevOps Engineer III (Inst)

Job Duties:

Key Job Responsibilities:

• Manages, maintains, selects, and develops automation tools and infrastructure, including security configurations
• Develops, programs, and/or deploys automation workflows for deployment, configuration, and/or monitoring of systems/services
• Serves as technical lead for one or more aspects of the system
• Performs integration, migration, configuration, and security of existing applications and services into automated infrastructures
• Analyzes requirements and communicates and coordinates with staff and internal stakeholders related to the system and/or project
• Serves as a subject matter expert to internal stakeholders, providing guidance and training to staff

Department:

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.

Job 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 prioritiesas communicated by The Division of Research and The Graduate School.
• Job Responsibilities 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.

Experience:

• 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