Sr Data Analyst - Education

at Public Consulting Group in Springfield, Illinois, United States

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 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 www.publicconsultinggroup.com .

Our Education team offers consulting services and technology solutions to help schools, school districts, and state education agencies/ministries of education promote student success, improve programs and processes, and optimize financial resources. We work with clients to ensure all students have what they need to succeed.

Services:

+ Teaching

+ Learning Solutions

+ Data Systems

+ IT Solutions

+ Financial Solutions

+ Equity in Education

+ Equitable Education

+ Recovery Services

+ Work with internal and external clients to identify analytical requirements

+ Write advanced SQL queries and perform complex data mining techniques to capture appropriate data

+ Produce reports, dashboards, and data visualizations to satisfy client requirements

+ Automate business processes with Power Apps and Flows

+ Document processes and procedures used to produce reports

+ Perform business analysis to identify opportunities for business improvement

+ Interpret results of data analysis to business users

+ Lead special projects, including delegation and validation of tasks to other team members

+ Liaise with IT team on regarding data governance and requirements of the data warehouse

+ Participate in an Agile team as a Team Member

+ T-SQL (complex queries, joins, unions, creating tables, etc.)

+ Reporting Services & Report Builder

+ Power BI

+ DAX

+ SQL Server (SSMS, SSIS)

+ Microsoft Power Apps

+ Microsoft Flow

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

+ R and M a plus

+ Strong understanding of relational databases and data warehouses

+ Microsoft Office

+ Critical thinking and problem solving

+ Bachelor’s Degree

+ 4-6 years’ experience in data analysis

+ NA

+ NA

+ Office Setting

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 the following reasonable range of compensation for this role below. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave.

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.