Data Quality and Reporting Analyst

State of Montana
United States
2 days ago
Apply on mtstatejobs.taleo.net
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours

Tech stack

Artificial Intelligence Data Analysis Computer Programming Data Validation Data Cleansing Data Mapping Data Warehousing Excel Formulas R (Programming Language) Program Design Languages Power BI SQL Databases
+4 more
Tableau (Software) Snowflake Performance Monitor Servicenow

Job description

Put your data skills to work for Montana’s job seekers and employers. As our Data Quality and Reporting Analyst, you’ll turn complex workforce data into insights that help leaders see what’s working, identify opportunities, and improve how programs serve Montanans. You’ll take ownership of accurate, timely performance reporting for leadership, providers, and federal partners. You’ll also build automated data quality checks from the ground up in Snowflake, helping shape a modern data environment that keeps the Workforce Services Division’s state and federal program data reliable and ready to use year-round., The Data Quality and Reporting Analyst helps ensure that workforce program data is accurate, reliable, and ready for federal and state performance reporting. In this role, you will develop automated data checks in Snowflake, maintain repeatable reporting processes, and translate performance results into useful information for decisionmakers. You will partner with program experts, workforce providers, and technical teams to resolve data quality issues, strengthen data collection practices, and improve how systems support reporting requirements. By providing performance data expertise to agency leadership, the State Workforce Innovation Board, and federal partners, you will support informed decisions about policy, program design, and service delivery.

WHAT’S IN IT FOR YOU:

  • Build expertise in data quality, automated validation, and performance reporting while helping Montana understand how workforce programs serve job seekers and employers.
  • Strengthen your SQL, Snowflake, and analytical skills through hands-on work with complex workforce data and opportunities to develop new processes.
  • Grow your consultation and communication skills by helping program staff, providers, and leadership understand technical findings and use data effectively.
  • Develop specialized knowledge of workforce programs, public policy, and reporting requirements while partnering with program experts and technical teams.
  • Contribute to foundational work that improves data reliability, strengthens reporting practices, and supports informed decisions across the Workforce Services Division., * Develop and maintain automated data quality checks by building validation and cleaning processes in Snowflake that keep workforce program data accurate, complete, and ready for dashboards and reports throughout the year.
  • Review and resolve data quality issues by evaluating submitted data, identifying errors and their causes, and documenting workflows and correction processes that support consistent, repeatable improvements.
  • Prepare and deliver federal and state performance reports by applying established reporting requirements, validating results, and coordinating timely, accurate submissions.
  • Analyze and interpret program performance by identifying trends, explaining results, and translating findings into useful information for decisions about policy, program design, and service delivery.
  • Support providers and program staff by explaining data collection expectations, communicating when and why corrections are needed, and partnering with internal teams to provide training and guidance on accurate data entry.
  • Strengthen system and reporting reliability by working with IT staff to verify data mapping and reporting in EmployMT and related systems, prioritize issues, and develop processes that address new or changing requirements.
  • Interpret and apply reporting requirements by monitoring federal and state laws, rules, performance measures, and guidance; translating changes into data collection and reporting practices; and contributing to related policy review and development.
  • Provide performance data expertise by partnering with the Division’s Performance Data Manager to guide agency leadership, the State Workforce Innovation Board, Federal Project Officers, and Federal Project Analysts on data quality, reporting requirements, and performance results.

Requirements

  • SQL and data warehouse proficiency: Skill in using SQL to query, analyze, and validate data in Snowflake or a comparable cloud data warehouse.
  • Data quality and validation: Ability to apply data preparation and cleaning practices, evaluate accuracy, completeness, validity, and reliability, and develop automated checks that identify errors early.
  • Performance reporting and interpretation: Ability to produce recurring reports against established measures or requirements, validate results, and explain what findings mean for program performance and decision-making.
  • Systems and process thinking: Ability to understand how data moves between systems, identify the causes of reporting errors, and document workflows and correction processes that support consistent, repeatable results.
  • Analysis and business intelligence: Skill in using advanced Excel functions and a business intelligence tool, such as Tableau or Power BI, to analyze data and present findings in clear, useful formats.
  • Communication and user support: Ability to explain technical findings and correction requirements in plain language, adapt written and visual information for different audiences, and help users apply accurate data collection practices.
  • Consultation and collaboration: Ability to build productive working relationships, gather information through effective questioning and listening, and partner with technical staff, program experts, and providers to identify needs, prioritize issues, and develop practical solutions.
  • Regulatory interpretation and follow-through: Ability to research and apply changing laws, rules, policies, and reporting guidance while managing multiple assignments, tracking deadlines, and maintaining accuracy as requirements evolve.

Preferred Skills and Compentencies:

  • Workforce program knowledge: Familiarity with the Workforce Innovation and Opportunity Act (WIOA), its Title I, II, and III programs, and related federal performance reporting requirements.
  • Program and case management systems: Experience working with case management systems, public-sector program data, or the ServiceNow environment.
  • R programming: Skill in using R to clean, prepare, or analyze data.
  • AI-assisted data practices: Experience applying AI-assisted tools to data cleaning or validation.
  • Training and coaching: Experience helping nontechnical users understand reporting requirements, correct data issues, and apply consistent data entry practices.
  • Operational improvement: Experience translating analytical findings into actionable improvements and working across teams or agencies to develop shared solutions., * Demonstrated experience analyzing data, improving data quality, or producing performance reports, typically built over at least two (2) years of directly related experience.
  • Experience researching and resolving complex data problems, with clear examples of identifying errors, understanding their causes, and making improvements that increased accuracy or reliability.
  • Experience preparing recurring reports against established measures or requirements and translating the results into useful information for decisionmakers.\
  • Experience working with technical staff, programs teams, or other partners to improve data collection, resolve reporting issues, or develop consistent, repeatable processes.
  • A degree in mathematics, data analysis, business intelligence, statistics, economics, computer programming, or a related field may supplement relevant professional experience but is not a substitute for demonstrated ability in the areas noted above. Equivalent combinations of education, training, and directly related experience will be considered.

Benefits & conditions

Being able to enjoy the quality of life in the beautiful state of Montana is one of the benefits you will love about this opportunity! Our mountains, waterways and open spaces provide not only beautiful scenery but year-round recreational opportunities including hiking, camping, biking, fishing, boating, hunting, skiing and snowmobiling. Montana boasts a high-quality education system and a variety of entertainment including fairs, rodeos, and theaters. Read more about our great state here.

See our other incredible benefits here. These are some of our benefits just to name a few:

  • Work/life balance with hybrid schedules or partial telework may be available within the state of Montana.
  • 38 paid days off a year including vacation, sick leave and holidays.
  • Military leave: You’ll get up to 15 days of military leave with full pay.
  • Longevity raises with continuous service, as well as any negotiated market increases and state statutory raises.

About the company

It’s about the people and the impact we make in our communities every day. We are proud of our open, team-based, supportive, and collaborative work environments. Learn more about DLI here.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on mtstatejobs.taleo.net
Prepare application

Good distractions

Loading talks and stories from around this role…