Public Consulting Group
Lead Data Analyst
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. 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. Overall responsibilities include: Supervising a small team of Data Analysts Providing strategic recommendations in terms of data interoperability direction and features Reviewing, formatting, importing/exporting, transforming, validating, or modeling data for strategic clients Position requirements include: Project management Documentation Data analysis Data engineering Communication skills Specific responsibilities include: Delegating and managing tasks accordingly to meet or exceed client expectations Writing advanced SQL queries and performing complex data mining techniques Producing reports, dashboards, and data visualizations Automating business processes with Power Apps and Flows Performing business analysis Presenting and interpreting results of data analysis Liaising with IT team regarding data governance Overseeing creation and maintenance of data dictionaries Strategic client management Travel to and present at status update meetings Engaging technical team as it relates to emerging data structure and reporting needs Software implementation activities Overseeing and performing data QA Reviewing data analysis and agendas for client meetings Assisting strategic school districts in submitting electronic data Required skills include: Strong analytical skills, critical thinking, and careful attention to detail Proficiency in MS Office products 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 include: Previous experience utilizing Visio, Asana, and JIRA Previous experience utilizing Python, SQL or other data platforms Required experience includes: 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 Salary range: $80,000 - $100,000. 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. 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 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.
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. 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. Overall responsibilities include: Supervising a small team of Data Analysts Providing strategic recommendations in terms of data interoperability direction and features Reviewing, formatting, importing/exporting, transforming, validating, or modeling data for strategic clients Position requirements include: Project management Documentation Data analysis Data engineering Communication skills Specific responsibilities include: Delegating and managing tasks accordingly to meet or exceed client expectations Writing advanced SQL queries and performing complex data mining techniques Producing reports, dashboards, and data visualizations Automating business processes with Power Apps and Flows Performing business analysis Presenting and interpreting results of data analysis Liaising with IT team regarding data governance Overseeing creation and maintenance of data dictionaries Strategic client management Travel to and present at status update meetings Engaging technical team as it relates to emerging data structure and reporting needs Software implementation activities Overseeing and performing data QA Reviewing data analysis and agendas for client meetings Assisting strategic school districts in submitting electronic data Required skills include: Strong analytical skills, critical thinking, and careful attention to detail Proficiency in MS Office products 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 include: Previous experience utilizing Visio, Asana, and JIRA Previous experience utilizing Python, SQL or other data platforms Required experience includes: 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 Salary range: $80,000 - $100,000. 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. 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 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.