TITLE: Senior Data Analyst

DEPARTMENT: Administration

PAY LEVEL: Level N $106,059.20-$170,589.57

EXEMPT/NON-EXEMPT: E

LOCATION: Leavenworth County Courthouse

SUPERVISOR: County Administrator

SUPERVISES: N/A

PERCENTAGE OF TIME ACCOUNTABILITIES 40% Strategic Planning and Analysis

30% Data Collection, Reporting & Auditing

25% Coordinating with internal and external data sources

5% Public Relations and Other Duties

SCOPE The Senior Data Analyst performs advanced analytical work in the areas of employee benefits, workers’ compensation, risk management, and municipal reporting. This position develops and maintains complex data models, dashboards, and forecasting tools to support strategic decision‑making by Human Resources, Finance, Safety, and elected officials.

The role is responsible for ensuring data accuracy, conducting root cause and risk analyses, and developing data‑driven safety programs that reduce organizational liability and improve county efficiency.

- The functions listed below represent the description of duties but not necessarily all duties required of this position. Management is not precluded from assigning other related functions not listed herein.

ESSENTIAL FUNCTIONS AND ILLUSTRATIVE TASKS Essential duties and responsibilities may include, but are not limited to, the following:

- Collects, validates, and integrates complex datasets.
- Designs advanced dashboards, scorecards, and automated reporting tools for internal leadership and elected officials.
- Conducts detailed analysis of financial and budgetary compliance.
- Analyzes workers compensation trends and analyzes proposed rate structures.
- Compares current emergency service billing rates with industry trends.
- Conducts risk management analysis on incidents and claims; identifies trends and exposure areas.
- Collaborates with the Safety division to design and evaluate data-driven safety programs aimed at reducing injuries and improving regulatory compliance.
- Develops forecasting models for benefit costs, workers’ compensation reserves, and long‑term budget planning.
- Prepares and presents reports to County leadership, department heads, boards, committees, and elected officials.
- Establishes data standards, audit processes, reporting protocols, and documentation to support accuracy and consistency.
- Leads cross-functional projects, including system integrations, process improvements, and new reporting development.

KNOWLEDGE AND SKILLS:

- Principles and practices of data analytics, data modeling, and quantitative reporting.
- Administration, cost structures, utilization trends, and plan design fundamentals.
- Workers’ compensation regulations, claim processes, reporting requirements, and cost‑control strategies.
- Risk management principles, including incident analysis, exposure assessment, and mitigation strategies.
- Occupational safety standards, reporting requirements, and best practices in municipal safety program design.
- Municipal operations, public sector reporting expectations, and the role of elected officials in oversight and budgeting.
- Applicable federal and state regulations including OSHA, ADA, FMLA, and workers’ compensation statutes.
- Data governance, audit practices, confidentiality standards, and public records requirements.
- Building advanced dashboards and visualizations.
- Developing complex Excel models using pivot tables, advanced formulas, and data automation techniques.
- Conducting deep analytical reviews to identify trends, root causes, predictive indicators, and actionable insights.
- Designing and implementing data-driven safety initiatives.
- Preparing clear, concise, and accessible reports for non‑technical audiences.
- Forecasting and financial modeling related to benefits and workers’ compensation budgets.
- Managing and integrating large, multi-source datasets with a high degree of accuracy.
- Communicating complex analytical concepts clearly through presentations, reports, and discussions.
- Leading cross-departmental projects and collaborating effectively with teams across the County.
- Translate complex data into meaningful recommendations for policy development, budgeting, and program improvements.
- Work independently while managing multiple priorities in a fast-paced municipal environment.
- Maintain confidentiality and handle sensitive data with professionalism.
- Identify emerging risks and propose strategic solutions.
- Maintain consistency, accuracy, and reliability of all data outputs and reports.

HUMAN RELATIONS

- Work effectively with Department Directors, Board of County Commissioners, County Administrator and Elected Officials.
- Communicate effectively, both orally and in writing, using the English language.

WORK ENVIRONMENT The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is required to stand; walk; sit; use hands to finger; reach with hands and arms; talk or hear. The employee must regularly lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, color vision, depth perception.



Work is typically performed in a standard office environment and involves extended periods of computer use and data review.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

While performing the duties of this job, the employee is exposed to a normal noise level in the work environment.

MINIMUM QUALIFICATIONS

- Bachelor’s degree in Data Analytics, Statistics, Human Resources, Business, Risk Management, or related field.
- 10+ years of progressively responsible experience in data analysis, including experience with benefits and workers' compensation data.
- Experience working with municipalities, elected officials, or public agencies, including preparation of public-facing reports or presentations.
- Advanced skills in Excel.
- Experience conducting risk management analysis, incident trend analysis, and root cause investigations.
- Strong verbal and written communication skills, including the ability to explain complex data to non‑technical audiences.
- Experience with pulling data sets from various software programs and platforms.

PREFERRED QUALIFICATIONS

- Master’s degree in Data Analytics, Business, Public Administration, or related field.
- Experience supporting municipal budget processes or actuarial-style forecasting.
- Knowledge of OSHA, FMLA, ADA, and other compliance requirements.

ADA/PHYSICAL DEMANDS Vision- Ability to see and read documents. Specific vision abilities include close vision, color vision, depth perception, and ability to adjust focus. Hearing- Ability to talk and hear in person and by telephone.

Speech- Must be able to speak English clearly. Must be able to clarify or give detailed instructions, facts and information. Ability to communicate in an effective manner, both orally and in writing.

Standing- Using copier, fax machine, printer, helping the public.

Walking- To and from various departments, offices.

Sitting - 80% of the time – preparing documents, talking on the telephone, and other duties.

Lifting/Carrying - 20 pounds –reams of paper and other office supplies.

Pushing/Pulling - 20 pounds – sometimes must push cart with documents and surplus property.

Climbing/Balancing - Required when climbing stairs within Courthouse or retrieving files from top shelf.

Stooping/Kneeling- Required when retrieving or filing from lower drawers or when retrieving items, office supplies, etc. from the floor.

Reaching/Handling- Required on most tasks.

Leavenworth County will reasonably accommodate qualified individuals with a disability so that they can perform the essential functions of a job unless doing so causes a direct threat to these individuals or others in the workplace and the threat cannot be eliminated by reasonable accommodation or if the accommodation creates an undue hardship to Leavenworth County. Contact human resources (HR) with any questions or requests for accommodation.

TITLE: Senior Data Analyst

DEPARTMENT: Administration

PAY LEVEL: Level N $106,059.20-$170,589.57

EXEMPT/NON-EXEMPT: E

LOCATION: Leavenworth County Courthouse

SUPERVISOR: County Administrator

SUPERVISES: N/A

ESSENTIAL FUNCTIONS AND ILLUSTRATIVE TASKS Essential duties and responsibilities may include, but are not limited to, the following:

- Collects, validates, and integrates complex datasets.
- Designs advanced dashboards, scorecards, and automated reporting tools for internal leadership and elected officials.
- Conducts detailed analysis of financial and budgetary compliance.
- Analyzes workers compensation trends and analyzes proposed rate structures.
- Compares current emergency service billing rates with industry trends.
- Conducts risk management analysis on incidents and claims; identifies trends and exposure areas.
- Collaborates with the Safety division to design and evaluate data-driven safety programs aimed at reducing injuries and improving regulatory compliance.
- Develops forecasting models for benefit costs, workers’ compensation reserves, and long‑term budget planning.
- Prepares and presents reports to County leadership, department heads, boards, committees, and elected officials.
- Establishes data standards, audit processes, reporting protocols, and documentation to support accuracy and consistency.
- Leads cross-functional projects, including system integrations, process improvements, and new reporting development.

KNOWLEDGE AND SKILLS:

- Principles and practices of data analytics, data modeling, and quantitative reporting.
- Administration, cost structures, utilization trends, and plan design fundamentals.
- Workers’ compensation regulations, claim processes, reporting requirements, and cost‑control strategies.
- Risk management principles, including incident analysis, exposure assessment, and mitigation strategies.
- Occupational safety standards, reporting requirements, and best practices in municipal safety program design.




- Municipal operations, public sector reporting expectations, and the role of elected officials in oversight and budgeting.
- Applicable federal and state regulations including OSHA, ADA, FMLA, and workers’ compensation statutes.
- Data governance, audit practices, confidentiality standards, and public records requirements.
- Building advanced dashboards and visualizations.
- Developing complex Excel models using pivot tables, advanced formulas, and data automation techniques.
- Conducting deep analytical reviews to identify trends, root causes, predictive indicators, and actionable insights.
- Designing and implementing data-driven safety initiatives.
- Preparing clear, concise, and accessible reports for non‑technical audiences.
- Forecasting and financial modeling related to benefits and workers’ compensation budgets.
- Managing and integrating large, multi-source datasets with a high degree of accuracy.
- Communicating complex analytical concepts clearly through presentations, reports, and discussions.
- Leading cross-departmental projects and collaborating effectively with teams across the County.
- Translate complex data into meaningful recommendations for policy development, budgeting, and program improvements.
- Work independently while managing multiple priorities in a fast-paced municipal environment.
- Maintain confidentiality and handle sensitive data with professionalism.
- Identify emerging risks and propose strategic solutions.
- Maintain consistency, accuracy, and reliability of all data outputs and reports.

HUMAN RELATIONS

- Work effectively with Department Directors, Board of County Commissioners, County Administrator and Elected Officials.
- Communicate effectively, both orally and in writing, using the English language.

WORK ENVIRONMENT The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is required to stand; walk; sit; use hands to finger; reach with hands and arms; talk or hear. The employee must regularly lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, color vision, depth perception. Work is typically performed in a standard office environment and involves extended periods of computer use and data review.

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

While performing the duties of this job, the employee is exposed to a normal noise level in the work environment.

MINIMUM QUALIFICATIONS

- Bachelor’s degree in Data Analytics, Statistics, Human Resources, Business, Risk Management, or related field.
- 10+ years of progressively responsible experience in data analysis, including experience with benefits and workers' compensation data.
- Experience working with municipalities, elected officials, or public agencies, including preparation of public-facing reports or presentations.
- Advanced skills in Excel.
- Experience conducting risk management analysis, incident trend analysis, and root cause investigations.
- Strong verbal and written communication skills, including the ability to explain complex data to non‑technical audiences.
- Experience with pulling data sets from various software programs and platforms.

PREFERRED QUALIFICATIONS

- Master’s degree in Data Analytics, Business, Public Administration, or related field.
- Experience supporting municipal budget processes or actuarial-style forecasting.
- Knowledge of OSHA, FMLA, ADA, and other compliance requirements.

ADA/PHYSICAL DEMANDS Vision- Ability to see and read documents. Specific vision abilities include close vision, color vision, depth perception, and ability to adjust focus. Hearing- Ability to talk and hear in person and by telephone.

Speech- Must be able to speak English clearly. Must be able to clarify or give detailed instructions, facts and information. Ability to communicate in an effective manner, both orally and in writing.

Standing- Using copier, fax machine, printer, helping the public.

Walking- To and from various departments, offices.

Sitting - 80% of the time – preparing documents, talking on the telephone, and other duties.

Lifting/Carrying - 20 pounds –reams of paper and other office supplies.

Pushing/Pulling - 20 pounds – sometimes must push cart with documents and surplus property.

Climbing/Balancing - Required when climbing stairs within Courthouse or retrieving files from top shelf.

Stooping/Kneeling- Required when retrieving or filing from lower drawers or when retrieving items, office supplies, etc. from the floor.

Reaching/Handling- Required on most tasks.

Leavenworth County will reasonably accommodate qualified individuals with a disability so that they can perform the essential functions of a job unless doing so causes a direct threat to these individuals or others in the workplace and the threat cannot be eliminated by reasonable accommodation or if the accommodation creates an undue hardship to Leavenworth County. Contact human resources (HR) with any questions or requests for accommodation.

📌 SENIOR DATA ANALYST - ADMINISTRATION DEPARTMENT 26-8-3 (Medellín)
🏢 Leavenworth County Kansas
📍 Medellín