Data Analytics & Reporting Specialist — Remote

MSF&W Consulting

Springfield (IL)

Hybrid

CAD 90,000 - 131,000

Full time

4 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Marucco, Stoddard, Ferenbach & Walsh seeks a full-time Data Analyst for the Illinois State Board of Education offices in Springfield, IL. Remote work is allowed; on-site reporting to the client office three days weekly.

Responsibilities include writing SQL queries, validating data, and supporting data governance, data warehouse, SSRS reporting, and ArcGIS visualizations while complying with FERPA and accessibility standards.

Qualifications

Bachelor's degree (or foreign equivalent) in Computer Science, Information Technology, or closely related field and 4 years of experience in administrating data systems in a large-scale enterprise or regulated environment; or a Master's degree (or foreign equivalent) in Computer Science, Information Technology, or closely related field and 2 years of experience in administrating data systems in a large-scale enterprise or regulated environment.
2 years of experience writing and executing SQL queries for data retrieval and reporting in a large-scale enterprise or regulated environments.
2 years of experience performing data validation and data quality checks on structured datasets.
2 years of experience developing reports using SSRS or similar.
2 years of experience supporting geospatial or location-based reporting and visualization using ArcGIS or similar tools.
2 years of experience supporting reporting in environments with data privacy or regulatory requirements (e.g., FERPA).
2 years of experience developing accessible, Section 508/WCAG 2.2-compliant reports and data visualizations.

Responsibilities

Write and execute SQL queries to retrieve data and generate standard and ad-hoc reports.
Perform routine data validation, cleansing, and preparation to support data accuracy and consistency.
Follow established data governance, security, and access control policies when handling sensitive data.
Work with existing data warehouse and data mart structures to support data processing and reporting needs.
Develop reports using SSRS or similar reporting tools.
Support development of geospatial or location-based reports and visualizations using ArcGIS or similar tools, as needed.
Apply established data privacy standards, including handling of FERPA-protected data.
Ensure reports and outputs align with accessibility standards (e.g., Section 508 / WCAG).
Assist in translating business requirements into technical data solutions
Apply established methods to de-identify or anonymize datasets for reporting and analysis.