Public Consulting Group

Business Data Analyst (Power BI) I

Job Locations US-Home or Remote Position
Posted Date 2 weeks ago(9/9/2021 9:30 AM)
Job ID
# of Openings
Information Technology
Regular Full-Time
Practice Area
Human Services


About Public Consulting Group

Public Consulting Group, Inc. (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 and headquartered in Boston, Massachusetts, PCG has over 2,500 professionals in more than 60 offices worldwide. PCG’s Human Services practice helps state, county, and municipal human services agencies to achieve their performance goals in order to better serve populations in need. PCG’s seasoned professionals offer proven solutions to help agencies design programs, services, and systems; increase program revenue; cut costs; and improve regulatory compliance with state and federal regulations. To learn more, visit


  • Works with internal and external clients to identify application and analytical requirements
  • Design and develop Office 365 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.
  • Creates queries and performs data mining techniques to capture appropriate data
  • Produces reports, analysis, and other outputs to satisfy client requirements
  • Documents processes and procedures used to create and maintain applications
  • Performs business analysis to identify opportunities for business improvement
  • Interprets results of data analysis to business users
  • 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


Required Skills

  • Experience developing applications from scratch on the Microsoft Power Platform; Power Automate, SharePoint, Teams, and Power BI
  • Experience with Power Apps and Microsoft Data verse 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
  • Worked through all phases of Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the 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 0365 licensing plans and features included in different plans
  • Good 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
  • T-SQL (complex queries, joins, unions, creating tables, etc.)
  • SQL Server (SSMS, SSIS, SSRS)
  • Excel (PivotTables, various functions like VLOOKUP, SUMIFS, etc.)



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

Experience: 1-3 years experience 





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.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Public Consulting Group!

Not ready to apply? Connect with Public Consulting Group for general consideration.