Power Platform Consultant - Public Consulting Group

About Public Consulting Group

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.

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

• 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.

Education: Bachelor’s degree or 5 years’ experience required and Master’s degree (MPA or government focused MBA) preferred

Experience: 5+ years of relevant work experience

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

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. 

#D-PCG

#LI-AH1

#LI- Remote

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: $85,000-115,000 and a potential discretionary bonus of up to 15%. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave.

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 employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PCG, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications. We do not discriminate on the basis of race, color, religion or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, past or present military service, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law. PCG will not tolerate discrimination or harassment based on any of these characteristics. PCG believes in health, equality, and prosperity for everyone so we can succeed in changing the ways the public sector, including health, education, technology and human services industries, work.