South Dakota Staffing
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. To learn more, visit www.publicconsultinggroup.com. The 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 include teaching, learning solutions, data systems, IT solutions, financial solutions, equity in education, and recovery services. The 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. This role is responsible for executing data migration and integration tasks, validating data quality, and supporting the implementation of data systems. The analyst will work independently to review, format, import/export, transform, validate, and model data to support strategic and operational decision-making. Overall Responsibilities: Executing data migration and integration tasks Validating data quality Supporting the implementation of data systems Working independently to review, format, import/export, transform, validate, and model data Position Requirements: Data Migration & Integration: Demonstrated experience performing complex data migrations and integrations across multiple systems and formats. Data Analysis: Profiling data sets, identifying patterns or anomalies, mapping data to internal schemas, documenting validation and transformation rules, and designing and executing import, transformation, and export processes. Data Engineering: Understanding of programming logic to write scripts, queries, formulas, and procedures using tools such as MS Access or similar to automate ETL processes. Documentation: Ensuring that all data projects have clearly documented scope, requirements, and validation criteria to support data engineering and quality assurance. Communication Skills: Effective communication with team members and stakeholders, presenting findings and gathering requirements to ensure alignment and clarity. Project Management: Managing own tasks and timelines, collaborating with internal stakeholders to ensure successful delivery of data-related projects. Specific Responsibilities: Executing and validating software implementation activities including data migration, data integration, and site preparation. Writing advanced SQL queries and performing complex data mining techniques to capture appropriate data. Conducting data quality assurance and validation. Reviewing data analysis and preparing materials and agendas for client meetings. Assisting strategic customers in submitting electronic data and uploading the data into our systems. Creating and maintaining data dictionaries, data flow diagrams, etc. for reports and related functions. Managing and completing tasks to meet or exceed client expectations. Producing reports, dashboards, and data visualizations to satisfy client requirements and support decision-making. Presenting and interpreting results of data analysis to internal stakeholders. Performing strategic client management including working with clients to resolve issues, provide support, and build relationships. Automating business processes using tools such as Power Apps and Flows. Performing business analysis to identify opportunities for business improvement. Collaborating with IT teams regarding data governance and data warehouse requirements. Engaging technical team as it relates to emerging data structure and reporting needs, in close partnership with the project leads. Traveling to and presenting at status update meetings to clients. Required Skills: Strong analytical skills, critical thinking, and careful attention to detail. 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 of K-12 experience or education-related environments. 5+ years data analyst experience. 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 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.
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 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 include teaching, learning solutions, data systems, IT solutions, financial solutions, equity in education, and recovery services. The 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. This role is responsible for executing data migration and integration tasks, validating data quality, and supporting the implementation of data systems. The analyst will work independently to review, format, import/export, transform, validate, and model data to support strategic and operational decision-making. Overall Responsibilities: Executing data migration and integration tasks Validating data quality Supporting the implementation of data systems Working independently to review, format, import/export, transform, validate, and model data Position Requirements: Data Migration & Integration: Demonstrated experience performing complex data migrations and integrations across multiple systems and formats. Data Analysis: Profiling data sets, identifying patterns or anomalies, mapping data to internal schemas, documenting validation and transformation rules, and designing and executing import, transformation, and export processes. Data Engineering: Understanding of programming logic to write scripts, queries, formulas, and procedures using tools such as MS Access or similar to automate ETL processes. Documentation: Ensuring that all data projects have clearly documented scope, requirements, and validation criteria to support data engineering and quality assurance. Communication Skills: Effective communication with team members and stakeholders, presenting findings and gathering requirements to ensure alignment and clarity. Project Management: Managing own tasks and timelines, collaborating with internal stakeholders to ensure successful delivery of data-related projects. Specific Responsibilities: Executing and validating software implementation activities including data migration, data integration, and site preparation. Writing advanced SQL queries and performing complex data mining techniques to capture appropriate data. Conducting data quality assurance and validation. Reviewing data analysis and preparing materials and agendas for client meetings. Assisting strategic customers in submitting electronic data and uploading the data into our systems. Creating and maintaining data dictionaries, data flow diagrams, etc. for reports and related functions. Managing and completing tasks to meet or exceed client expectations. Producing reports, dashboards, and data visualizations to satisfy client requirements and support decision-making. Presenting and interpreting results of data analysis to internal stakeholders. Performing strategic client management including working with clients to resolve issues, provide support, and build relationships. Automating business processes using tools such as Power Apps and Flows. Performing business analysis to identify opportunities for business improvement. Collaborating with IT teams regarding data governance and data warehouse requirements. Engaging technical team as it relates to emerging data structure and reporting needs, in close partnership with the project leads. Traveling to and presenting at status update meetings to clients. Required Skills: Strong analytical skills, critical thinking, and careful attention to detail. 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 of K-12 experience or education-related environments. 5+ years data analyst experience. 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 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.