Sr Data Analyst Job at Public Consulting Group in Bismarck

Overview

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. PCG employs approximately 2,000 professionals nationwide and serves clients in all 50 states, three Canadian provinces, and Europe. The firm offers 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 provides consulting services and technology solutions to help schools, school districts, and state education agencies/ministries promote student success, improve programs and processes, and optimize financial resources.

Services

• Teaching
• Learning Solutions
• Data Systems
• IT Solutions
• Financial Solutions
• Equity in Education
• Equitable Education
• Recovery Services

Role

The Data Analyst works as part of a deadline-oriented, fast-paced team that supports states and large school districts in areas including special education management systems, data warehousing, federal claiming, and other programs. Responsibilities include 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.

Responsibilities

• Executes and validates software implementation activities including data migration, data integration, and site preparation.
• Writes advanced SQL queries and performs complex data mining to capture appropriate data.
• Conducts data quality assurance and validation.
• Reviews data analysis and prepares materials and agendas for client meetings.
• Assists strategic customers in submitting electronic data and uploading the data into our systems.
• Creates and maintains data dictionaries and data flow diagrams for reports and related functions.
• Manages and completes tasks to meet or exceed client expectations.
• Produces reports, dashboards, and data visualizations to satisfy client requirements and support decision-making.
• Presents and interprets results of data analysis to internal stakeholders.
• Performs strategic client management, including working with clients to resolve issues, provide support, and build relationships.
• Automates business processes using tools such as Power Apps and Flows.
• Performs business analysis to identify opportunities for business improvement.
• Collaborates with IT teams regarding data governance and data warehouse requirements.
• Engages technical teams regarding emerging data structures and reporting needs, in close partnership with project leads.
• Travels to and presents at status update meetings to clients.

Position Requirements

• Data Migration & Integration. Demonstrated experience performing complex data migrations and integrations across multiple systems/formats, including flat files, databases, and APIs. Includes validating data accuracy, resolving discrepancies, and ensuring seamless data flow between systems.
• Data Analysis. Profile data sets, identify patterns or anomalies, map data to internal schemas, document validation/transformation rules, and design/execute import, transformation, and export processes.
• Data Engineering. Understanding of programming logic; write scripts, queries, formulas, and procedures to automate ETL processes using tools such as MS Access or similar.
• Documentation. Ensure data projects have clearly documented scope, requirements, and validation criteria to support data engineering and quality assurance.
• Communication Skills. Communicate effectively with team members and stakeholders, presenting findings and gathering requirements for alignment.
• Project Management. Manage own tasks and timelines, collaborating with internal stakeholders to ensure successful delivery of data-related projects.

Required Skills

• Strong analytical skills, critical thinking, and attention to detail for analyzing and organizing data.
• Proficiency in MS Office (Access, Excel, PowerPoint, Word).
• Experience creating/using scripts, macros, formulas, and other data wrangling techniques.
• Excellent organizational, oral presentation, and written communication skills.

Preferred Skills

• Experience with Visio, Asana, and JIRA.
• Experience with 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 and Benefits: As required by applicable law, PCG provides a reasonable range of compensation for this role: $77,500-$100,000, plus a benefits package including medical and dental care, 401k, PTO, parental leave, and bereavement leave.

EEO Statement

Public Consulting Group is an Equal Opportunity Employer dedicated to celebrating diversity and fostering an inclusive culture. PCG does not discriminate on the basis of race, color, religion or belief, national origin, sex, gender identity or expression, age, disability, sexual orientation, marital or civil union status, military status, citizenship status, family medical history or genetic information, or other protected characteristics. PCG is a federal contractor and committed to equal opportunity in all employment actions.