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 Lead Data Analyst works as part of a deadline-oriented, fast-paced team consisting of consulting and operations staff that works together to provide superior service to states and large school districts in the areas of special education management systems, data warehousing, federal claiming, and other programs. The Lead Analyst will be responsible for supervising a small team of Data Analysts, providing strategic recommendations in terms of data interoperability direction and features. Will also be responsible for reviewing, formatting, importing/exporting, transforming, validating, or modeling data for strategic clients with the purpose of understanding or drawing conclusions to drive strategic and operational decision-making.

Position Title: Lead Data Analyst

Overall Responsibilities

Position Requirements

Project Management. The Lead Data Analyst will manage directly, setting scope, managing schedule, issues, risks, and collaborating with internal and client stakeholders. For larger, more complex projects, the Lead Data Analyst may work with a dedicated project manager.
Documentation. The Lead Data Analyst will be responsible for ensuring that all data projects have clearly documented scope and elaborated requirements to manage and validate data engineering.
Data Analysis. The Lead Data Analyst will be expected to profile data sets, recognize the existence (or absence) of patterns in the data, map to and extend PCG’s Data Schemas, document validation and transformation rules, design and execute import, transformation, and export processes, and explore analytics and visualizations.
Data Engineering: This role requires an understanding of programming logic, although no experience with a specific programming language is required. The Lead Data Analyst will be expected to write scripts, queries, formulas, and procedures, using tools like MS Access, to automate data ETL processes.
Communication Skills: The Lead Data Analyst must communicate well with clients, team members, and ancillary resources. This includes both presenting ideas or findings, as well as drawing out client or team member key concerns or other relevant information.

Specific Responsibilities

Delegates and manages tasks accordingly to meet or exceed client expectations.
Writes advanced SQL queries and perform complex data mining techniques to capture appropriate data.
Produces reports, dashboards, and data visualizations to satisfy client requirements.
Automates business processes with Power Apps and Flows.
Performs business analysis to identify opportunities for business improvement.
Presents and interprets results of data analysis to internal stakeholders.
Liaises with IT team regarding data governance and requirements of the data warehouse.
Oversees creation and maintenance of data dictionaries, data flow diagrams, etc. for EDPlan reports and related functions
Strategic client management including working with clients to resolve issues, provide support, and build relationships
Travel to and present at status update meetings to clients.
Engages technical team as it relates to emerging data structure and reporting needs, in close partnership with the project leads
Software implementation activities including data migration, data integration, site preparation, and project management.
Oversee and perform data QA
Reviewing data analysis and agendas for client meetings.
Assist strategic school districts in submitting electronic data and uploading the data into our system.

Required Skills

Strong analytical skills, critical thinking, and careful attention to detail, including the ability to analyze and organize data.
Proficiency in MS Office products: Access, Excel, PowerPoint, and Word
Expertise in creating/using scripts, macros, formulas, and other similar data wrangling skills and techniques
Excellent organizational, oral presentation and written communication skills.

Preferred Skills

Previous experience utilizing Visio, Asana, and JIRA
Previous experience utilizing Python, SQL or other data platforms

Required Experience

Bachelor’s degree and/or prior data analysis experience
3+ years supervisory experience
3+ years of schools (K-12) experience
6+ years data analyst experience

#EDU

As required by applicable law, PCG provides the following reasonable range of compensation for this role: $80,000-$100,00. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave.

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.

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.