Microsoft Power Platform/Power BI Engineer

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.

Our Human Services team helps state and municipal human services and economic development agencies keep their promises—responsibly and sustainably—to the children, adults, and families they serve. Join us and use your professional skills to build stronger communities and better serve populations in need by making meaningful and lasting changes in government organizations.

Services

• Program Consulting
• Finance Consulting and Billing Services
• Applied Technology
• Outsourcing and Operations
• Strategy
• Project and Grants Management
• Assessments and Feasibility Studies
  
  

Responsibilities include building solutions for internal and external projects using Power BI and Power Platform. Also responsible for the development and day-to-day maintenance and enhancements of Power BI reports and dashboards, as well as Power Platform application systems in test and production operations. Tasks include identifying and troubleshooting application and report 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 systems and is responsible for knowing what changes have been made to the base systems. 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, with a focus on Power BI reporting and analytics.
• Design and develop applications and solutions using Power BI, Microsoft Power Platform, and Office 365 services.
• Implement custom solutions that leverage Power BI, along with various Microsoft Power Platform and Office 365 services.
• Documents processes and procedures used to create and maintain Power BI reports, dashboards, and applications.
• Performs business analysis to identify opportunities for business improvement, particularly through enhanced data visualization and reporting with Power BI.
• Leads special projects, including delegation and validation of tasks to other team members, ensuring Power BI solutions meet business needs.
• Liaises with IT team regarding applications and data governance, and maintenance of the data warehouse, including security, privacy, and user management concerns, with a focus on Power BI data sources and datasets.
• Performs unit testing on Power BI reports and dashboards, as well as other work completed.
• Liaises with QA team regarding system, integration, and user acceptance testing, ensuring Power BI solutions are thoroughly tested and meet quality standards.
• Experience developing applications from on the Microsoft Power Platform, Power Automate, SharePoint, Teams, Power Apps and Power BI
• 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
• 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
  
  

Education And Experience

• Bachelor’s Degree or 6+ years equivalent experience required
• 3+ years’ experience with Microsoft Power BI
  
  

Role

This position is a remote, work from home position. 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: $76,800 - $85,000.

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