Public Consulting Group

Software Engineer 2 (Business Intelligence)

Job Locations US
Posted Date 2 months ago(2/14/2023 7:35 AM)
Job ID
# of Openings
Regular Full-Time
Practice Area
Education Services


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


Public Consulting Group, Inc. (PCG) provides management consulting and technology services to help public sector education, health, human services, and other government clients achieve their performance goals and better serve populations in need. Founded in 1986 and headquartered in Boston, Massachusetts, PCG has more than 2,200 professionals in 55 offices around the U.S. and in Montreal, the UK and Poland. The firm draws on more than three decades of consulting to public sector clients in all 50 states and Canada to deliver best-practice solutions and measurable results to state and local public agencies, state-operated facilities, and private providers that do business with government agencies. PCG is committed to a diverse workforce which reflects our clients and the people they serve. Our organizational culture attracts and rewards people who are results-oriented and interested in making an immediate impact on their community as well as their own career.

 We are currently seeking the services of full-time Software Engineer for our Business Intelligence team, working remotely as part of our Windsor, CT team. If you are dynamic, mature, ambitious, creative, and autonomous, you will appreciate working with our team of technology professionals committed towards producing superior applications for the Education Sector.




Specific Responsibilities:

  • Plan, develop, test, document, and implement data solutions according to specifications and industry best practices.
  • Convert functional specifications into technical specifications suitable for database development.
  • Follow coding and documentation standards. Participate in code review process.
  • Collaborate with end users to troubleshoot data related IT inquiries.
  • Become a data expert. Produce complex, large exports of data with a large degree of accuracy and efficiency.
  • Analyze, review and alter T-SQL to increase operating efficiency or adapt to new requirements.
  • Implement complex queries and reports.
  • Provide necessary knowledge transfer to support and services organizations.
  • Continuously look for ways to improve effectiveness and efficiency allowing us to provide a higher quality product in less time.
  • Demonstrate high professional and ethical standards.



Required Skills:

  • Experience working in Microsoft SQL Server and the Microsoft Business Intelligence Stack (SSRS, SSAS and SSIS)
  • Knowledge of administration of SQL Server for transactional and analysis systems
  • Skilled at analyzing and working with large amounts of data.
  • Reporting experience in a range of reporting, dashboard solutions.
  • Understanding of software development life cycle and ability to perform activities throughout lifecycle: data analysis, design, development, configuration/customization and unit/user acceptance testing.


Required Experience:

  • Bachelor’s degree in Computer Science or related field.
  • 2+ years hands on technical experience with MS SQL BI stack: SSAS, SSIS, etc.
  • 1+ years of reporting experience
  • Cloud environment, preferably Azure
  • Power BI is a plus.



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: $95,000 - $105,000k.

In addition, PCG provides a range of benefits for this role.


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