Afternoon Excel Data Analyst Jobs in Springfield, IL

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 .

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

Duties & Responsibilities

• Lead team in reviewing and analyzing Title IV-E cases for compliance with state and federal policies and procedures.

• Manage the Title IV-E eligibility team, including direct supervision of individuals and overall leadership of team activities and outcomes.

• Direct supervision of one or more team members including weekly check-ins; providing training, direction, and feedback; and performance management.

• Ensure team’s compliance with federal and state laws, regulations, and policies.

• Monitor performance measurements for team activities to help ensure that team meets all contractual responsibilities

• Use critical thinking and data analysis tools (e.g., Excel, PowerBI) to respond to DCF and PCG management requests.

• Proactively pursue continuous improvement to increase compliance, value, accuracy, and efficiency of the team’s work.

• Develop and maintain a robust quality assurance process for all activities, data and reports developed for DCF and for PCG management.

• Lead client meetings and trainings in a variety of settings.

• Maintain positive working relationship with the clients, colleagues, and team members.

• Collaborate with PCG staff on other teams, fostering an environment of information sharing and mutual support across teams.

• Maintain up-to-date knowledge of federal and state laws, policies, and procedures related to Title IV-E and share findings with DCF.

• Lead/participate in state and federal audits and reviews.

• Maintain and update Standard Operating Procedures and training materials for team functions.

Required Skills

• Ability to prioritize responsibilities for self and others and to delegate tasks

• Ability to organize and plan work efficiently within set time limits for self and others

• Advanced understanding of and ability to interpret relevant federal and state laws, regulations, and policies

• Strong verbal and written communication skills in formal and informal settings, including customer service

• Critical thinking for the sake of problem solving and identifying process improvements

• Detail-orientation

• Ability to work independently and within a team.

• Demonstrates initiative

• Comfortable using Microsoft Office applications, including Excel, Word, and Outlook.

• Strong proficiency with Microsoft Excel preferred

Qualifications

Education

• Bachelor’s degree or higher, preferably in related field

Experience

• 5+ years of relevant work experience, including supervision of staff

• Familiarity with relevant federal entitlement programs

#LI-MB1

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

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,100 –$ 75,000

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

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.