Business Data Analyst 1

Public-Consulting-Group; United States; Remote; USD 60,000 - 75,000; Full time

Job summary

Public Consulting Group is seeking a data analyst to serve as a liaison between development and business teams, translating client requirements into actionable data assets. The role involves collaborating with end users, developers, and management on multiple projects simultaneously to deliver client requests.

The ideal candidate has 2–4 years of data analysis experience, strong Excel skills (PivotTables, VLOOKUP, SUMIFS) and proficiency with Power BI and Microsoft Office.

Qualifications

• Proficient in Excel functions and data manipulation.
• Experience with reporting tools and dashboard creation is preferred.
• Strong communication to translate client needs into data requirements.

Responsibilities

• Collaborate with clients to identify analytical and technical requirements.
• Create queries and perform data mining to capture relevant data.
• Produce reports and analyses to meet client needs.
• Identify requirements and user stories for project scope.
• Provide testing support to ensure client expectations are met.
• Document processes and procedures used to generate reports.

Skills

Excel PivotTables

VLOOKUP

SUMIFS

Power BI

Microsoft Office

Education

Bachelor’s Degree or Equivalent

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 .The analyst will be a liaison between the development team and the business team to relay requirements and to confirm development is acceptable. This requires the analyst to work with the end user or client in identifying their expectations and even managing those expectations. It is expected that the analyst will work on several projects at the same time, interfacing with the end user, developers, and management in the delivery to the client requests.Duties and ResponsibilitiesWorks with internal and external clients to identify analytical and technical requirementsCreates queries and perform data mining techniques to capture appropriate dataProduces reports and analysis to satisfy client requirementsIdentifies and documents requirements and user storiesProvides testing support to confirm client expectations will be metDocuments processes and procedures used to produce reportsPerforms business analysis to identify opportunities for business improvementInterprets client requests for scope and applicabilityInterprets results of data analysis to business usersRequired SkillsExcel (PivotTables, various functions like VLOOKUP, SUMIFS, etc.)Power BIMicrosoft OfficeFamiliarity with IT principals including logic, flowcharting, and codingQualificationsBachelor’s Degree Preferred or 2+ relevant years’ experience required2 - 4 years’ experience in data analysisSupervisory ResponsibilityNoneWorking ConditionsRemote SettingThe 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.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: $60,000 - $75,000#LI#LI-SB1PCG does not sponsor newly hired foreign national workers for work authorization, including H-1B sponsorship.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.