United States onlyPublic 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 three 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
Job Description
This role supports internal and external projects by developing solutions using Power BI, Power Platform, and Excel. Responsibilities include creating, maintaining, and enhancing Power BI dashboards and Power Platform applications in both test and production environments. The position also involves performing data analysis using Excel, including advanced formulas, pivot tables, and data visualization techniques.
The candidate will troubleshoot issues, manage production changes following lifecycle and risk guidelines, and act as a subject matter expert for assigned systems. They will also support internal users, assess new software tools, and contribute to technical solution design and client needs assessments.
Works with internal and external clients to identify application and analytical requirements, with a focus on Power BI reporting and analytics.
Duties and Responsibilities
Collaborate with internal and external stakeholders to gather business and analytical requirements, with a focus on data-driven decision-making.
Design and develop dashboards and reports using Power BI.
Clean, transform, and model data using Power BI and DAX to create calculated columns, measures, and relationships.
Develop and optimize SQL queries, views, stored procedures, and user-defined functions to support reporting and analytics.
Perform data analysis using Excel, including pivot tables, advanced formulas, and charts to support reporting needs.
Document processes and standards for creating and maintaining Power BI reports and Excel-based analysis tools.
Conduct unit testing and support QA efforts to ensure accuracy and quality of Power BI and Excel solutions.
Lead special projects, delegate tasks, and deliverables meet business needs and timelines.
Stay current with Power BI updates, Microsoft Fabric, and industry trends to continuously improve BI capabilities.
All other duties as assigned.
The position is remote, with occasional domestic travel for team and client meetings as needed, no more than once per month.
Required Skills
Proficient in Power BI Desktop and Power BI Service, including report creation, publishing, and workspace management.
Solid understanding of DAX (Data Analysis Expressions) and Power Query (M language) for data modeling and transformation.
Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, and data visualization techniques.
Experience with data modeling, ETL (Extract, Transform, Load) processes, and performance tuning to optimize report efficiency and accuracy.
Ability to design and manage relationships, hierarchies, and metadata in Power BI datasets.
Proficiency in SQL and working with relational databases (e.g., SQL Server, Azure SQL, Synapse).
Ability to create visually compelling and user-friendly dashboards.
Qualifications
Education: Bachelor’s degree in a related field (e.g., Data Analytics, Information Systems, Computer Science) or equivalent experience (6+ years) in a technical or analytical role.
Experience:
2+ years of hands-on experience with Microsoft Power BI, including building dashboards, data modeling, and visualization.
3+ years of experience working as a data analyst, with proven ability to interpret data, identify trends, and deliver actionable insights using tools like Excel and Power BI.
Strong analytical and problem-solving skills
Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders
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 a reasonable range of compensation for this role. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave.
Range: $76,900-$86,900
Additional Job Description
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.
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.
