Power Platform Consultant

at Public Consulting Group in Springfield, Illinois, United States

Job Description

Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986, PCG employs approximately 2,000 professionals throughout the U.S.-all committed to delivering solutions that change lives for the better. The firm is a member of a family of companies with experience in all 50 states, and clients in six Canadian provinces and Europe. PCG offers clients a multidisciplinary approach to meet challenges, pursue opportunities, and serve constituents across the public sector. To learn more, visit www.publicconsultinggroup.com .

Collaborating with our Technology Consulting team, you will help organizations streamline operations and achieve strategic goals to serve the public better. We provide the full spectrum of technology consulting services to help state and local agencies meet operational and program needs that enhance the lives of their user base.

Services:

+ Strategy, Architecture, Planning, and Procurement

+ Business Enablement

+ Business Solutions

+ Project Assurance

Responsibilities include building solutions for internal and external projects using Power Platform, root cause analysis, management communication, and client relationship management in partnership with team members. Also responsible for the development and day-to-day maintenance and enhancements of the Power Platform application systems in test and production operations, including tasks related to identifying and troubleshooting application issues and issue resolution or escalation. Ensures all production changes are made in accordance with lifecycle methodology, version control, appropriate testing, and risk guidelines. Acts as an internal expert in terms of the assigned system and is responsible for knowing what changes have been made to the base system. Plays a critical role in delivering high-quality service and support to various levels of internal users. Conducts technical and analytical work in developing, designing, and/or analyzing technical solutions for clients. Assesses new software products and solutions. Duties include participation in client needs assessments, evaluating hardware and platform availability, and software requirements.

+ Works with internal and external clients to identify application and analytical requirements

+ Design and develop applications and solutions using the Microsoft Power Platform and Office 365 services

+ Implement custom solutions that leverage various Microsoft Power Platform and Office 365 services

+ Documents processes and procedures used to create and maintain applications

+ Performs business analysis to identify opportunities for business improvement

+ Leads special projects, including delegation and validation of tasks to other team members

+ Liaises with IT team on regarding applications and data governance, and maintenance of the data warehouse including security, privacy, and user management concerns

+ Performs unit testing on work completed

+ Liaises with QA team regarding system, integration, and user acceptance testing

The above is intended to describe the general contents and requirements of work being performed by people assigned to this classification. It is not intended to be construed as an exhaustive statement of all duties, responsibilities or skills of personnel so classified.

Qualifications:

+ Experience developing applications from on the Microsoft Power Platform, Power Automate, SharePoint, Teams, Power Apps and Power BI

+ Experience with Power Apps and Microsoft Dataverse is a plus

+ Knowledge of Power BI data querying and modeling capabilities, such as creation of calculated columns, measures, and relationships using DAX

+ Experience in database development in creating complex database Queries, Views, Stored Procedures, User Defined Functions

+ Experience with supporting all phases of Software Development Life Cycle (SDLC), including: gathering and analyzing business requirements; documenting functional/technical specifications; designing, developing, testing and deploying applications; and, providing production support

+ Experience in database development in creating complex database Queries, Views, Stored Procedures, User Defined Functions

+ Knowledge of Power Platform and other Microsoft O365 licensing plans and features included in different plans

+ Experience in implementing agile/scrum software development methodologies

+ Knowledge of automated unit testing and test-driven development

+ Ability to troubleshoot software systems, optimize performance, resolve problems, and provide follow-up on issues

+ Critical thinking, problem-solving, trouble shooting and decision-making skills

+ Strong communication skills

+ Desire to work in fast-paced, entrepreneurial setting

+ High integrity, with a proactive, positive approach to work

+ Ability to understand both the service delivery system for programs which are administered by states and monitored by federal regulators.

+ Ability to understand and be an expert in complex federal regulations and requirements.

+ Strong Microsoft Office applications skills, especially data analytics (i.e. ACCESS, SQL, SPSS)

+ Ability to use sound judgment in completing tasks and to seek guidance when needed.

+ Attention to detail and ability to work with large data sets with accurate results.

+ Ability to move projects forward within a specific timeline and budget while working at a detailed level.

+ Commitment to exceptional client service.

+ Creative problem-solving ability and a consultancy mindset.

+ Dedication to accomplishing goals and challenges presented by clients and management.

+ Ability to interact with various levels of management and with clients.

+ Flexible, self-starter possessing intellectual curiosity.

+ Enthusiasm for life-long learning and staying well-informed about current business issues.

+ Able to follow, critically evaluate, and improve upon current processes.

+ Excellent business writing skills and ability to make presentations to various audiences.

+ Ability to recognize issues and identify solutions.

Experience: 5+ years of relevant work experience

Education: Bachelor’s Degree or 6 + yrs equivalent experience required

2+ years’ experience with Microsoft Power Platform

This position is remote with travel/onsite requirements. PCG is a remote-friendly organization and is committed to creating a culture where remote work remains a vital part of the company’s success. To be successful in a remote work role at PCG, you must:

+ be available during your set working hours

+ have a safe, private, and distraction-free environment in which to complete your work, and

+ be able to give your full attention to the completion of your PCG job duties

Some travel to the office or elsewhere may be required for team meetings, client meetings, etc.

We are accepting applications on an ongoing basis until filled. As required by applicable law, PCG provides the following reasonable range of compensation for this role: $85,000-115,000.

\#D-PCG

\#LI-AH1

\#LI- Remote

+ ?

Compensation:

Compensation for roles at Public Consulting Group varies depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, PCG provides the following reasonable range of compensation for this role below. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave

EEO Statement:

Public Consulting Group is an Equal Opportunity Employer dedicated to celebrating diversity and intentionally creating a culture of inclusion. We believe that we work best when our emplo