Business Data Analyst 1

Public Consulting Group; Montpelier (VT); Remote; USD 75,000 - 86,000; Full time

Job summary

A leading public sector solutions firm in Vermont is seeking a Data Analyst to work remotely. The role involves analyzing client needs, creating data queries, and producing reports to improve performance in health and education sectors. Candidates should possess strong Excel and SQL skills, along with experience in data analysis and state health programs.

Benefits

Medical and dental benefits

401k

PTO

Parental leave

Bereavement leave

Qualifications

• Experience with data analysis and creating reports.
• Strong analytical and problem-solving skills.

Responsibilities

• Identify analytical requirements with clients.
• Create data queries and perform analysis.
• Document findings and recommendations.

Skills

Excel (PivotTables, functions)

Power BI / QuickSite

Microsoft Office

SQL

Education

Bachelor’s Degree Preferred or 2+ years relevant experience

2 – 4 years’ experience in data analysis

Medicaid background

Experience with state health and human service programs

Job description

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

Employee will be responsible for analyzing business requests, making recommendations, determining requirements, documenting results, creating user stories and providing monitoring of production systems. This analyst will be a core team member with direct contact with the various clients.

Duties and Responsibilities

• Works with internal and external clients to identify analytical requirements

• Creates queries and perform data mining techniques to capture appropriate data

• Produces reports and analysis to satisfy client requirements

• Documents processes and procedures used to produce reports

• Performs business analysis to identify opportunities for business improvement

• Interprets results of data analysis to business users

• Makes recommendations to management and the clients on solutions and opportunities

• Supports the development life cycle through requirement gathering and user story creation

• Supports testing of developed systems

Required Skills

• Excel (PivotTables, various functions like VLOOKUP, SUMIFS, etc.)

• Power BI / QuickSite

• Microsoft Office

• SQL

Qualifications

• Bachelor’s Degree Preferred or 2+ relevant years’ experience required

• 2 – 4 years’ experience in data analysis

• Medicaid background

• Experience with state health and human service programs

Supervisory Responsibility

• None

Working Conditions

• Remote

The above is intended to describe the general contents and requirements of work being performed by people assigned to this classification. It is not intended to be construed as an exhaustive statement of all duties, responsibilities or skills of personnel so classified.

LI

LI-LR1

LI-remote

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.

As required by applicable law, PCG provides the following reasonable range of compensation for this role: $75 ,500-$85,500 . 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.

Public Consulting Group is an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity, protected veteran status, or status as a qualified individual with a disability. VEVRAA Federal Contractor.