Data Analyst I

WASHINGTON COUNTY MENTAL HEALTH SERVICES INC

Barre (VT)

Hybrid

USD 72,000 - 76,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, dental, vision
Retirement contribution matching
Paid time off
12.5 flexible holidays
Sick and vacation days accrual

Job summary

Washington County Mental Health Services Inc. is seeking an entry-level Data Analyst I to support reporting and decision-making across clinical, billing, and operational areas in a hybrid role based in Barre, Vermont.

You'll convert clinical and administrative data into Power BI reporting, validate data, and work with clinical, finance, QA, and IT staff to ensure auditable outputs and regulatory compliance.

Qualifications

  • Bachelor’s degree in data analytics, information systems, statistics, public health, or related field, or associate degree with two years of relevant experience.
  • Zero to two years of data analysis or reporting experience.
  • Experience building Power BI reports, shaping data, creating relationships, and developing basic measures.
  • Working knowledge of SQL, including multi-table joins, filtering, aggregations, and date-based queries.
  • Proficiency in Excel, including PivotTables, lookup functions, conditional formulas, data validation, and data cleaning.
  • Strong attention to detail, analytical thinking, and problem-solving skills, including validating results against source data and communicating findings.
  • Ability to deliver services and complete treatment notes in English.
  • HIPAA requirements and agency privacy and security policies compliance and background checks.

Responsibilities

  • Build, publish, and maintain Power BI reports and dashboards for program managers, clinical leaders, and finance staff, covering service volume, caseloads, productivity, billing, and assessment completion.
  • Extract, clean, organize, and validate data using SQL, Power Query, and Excel to fulfill analytical requests.
  • Create and maintain Power BI measures and visualizations, manage report updates and access permissions, and respond to reporting needs across the agency.
  • Prepare, review, and reconcile datasets for state and federal reporting requirements, including Medicaid, service utilization, and quality measure submissions.
  • Detect missing, duplicate, or inconsistent data and coordinate with clinical, billing, management, and IT staff to resolve issues and improve data quality.
  • Document questions, data definitions, reporting logic, and standardized measures to support reproducible and auditable outputs.
  • Summarize reporting results clearly while protecting confidential client information and following agency privacy and security policies.

Job description

Washington County Mental Health Services Inc is seeking an entry-level Data Analyst I to support reporting and decision-making across clinical, billing, and operational areas. In this hybrid role based in Barre, Vermont, you will convert clinical and administrative data into reliable Power BI reporting and documentation that aligns with program performance and regulatory reporting needs.

You will work closely with clinical, finance, quality assurance, and other agency staff to build dashboards, validate data, and help ensure reporting is accurate, auditable, and understandable for both technical and nontechnical audiences.

What you’ll do
  • Build, publish, and maintain Power BI reports and dashboards for program managers, clinical leaders, and finance staff, covering service volume, caseloads, productivity, billing, and assessment completion.
  • Extract, clean, organize, and validate data using SQL, Power Query, and Excel to fulfill analytical requests.
  • Create and maintain Power BI measures and visualizations, manage report updates and access permissions, and respond to reporting needs across the agency.
  • Prepare, review, and reconcile datasets for state and federal reporting requirements, including applicable Medicaid, service utilization, and quality measure submissions.
  • Detect missing, duplicate, or inconsistent data and coordinate with clinical, billing, management, and IT staff to resolve issues and improve data quality.
  • Document queries, data definitions, reporting logic, and standardized measures to support consistent, reproducible, and auditable outputs.
  • Summarize reporting results clearly while protecting confidential client information and following agency privacy and security policies.
Minimum qualifications
  • Bachelor’s degree in data analytics, information systems, statistics, public health, or a related field (or associate degree plus two years of relevant experience), or an equivalent combination of education and experience.
  • Zero to two years of data analysis or reporting experience, including internships, academic projects, or portfolio work.
  • Experience building Power BI reports, shaping data, creating relationships, and developing basic measures.
  • Working knowledge of SQL, including multi-table joins, filtering, aggregations, and date-based queries, with the ability to read and modify existing queries.
  • Proficiency in Excel, including PivotTables, lookup functions, conditional formulas, data validation, and data cleaning.
  • Strong attention to detail, analytical thinking, and problem-solving skills, including validating results against source data, managing competing priorities, and communicating findings to technical and nontechnical audiences.
  • A commitment to confidentiality and data integrity aligned with the mission of public mental health services.
  • Ability to deliver services and complete treatment notes in English.
  • Responsibly handle confidential and protected health information, follow applicable HIPAA requirements and agency privacy and security policies, and complete required background checks and privacy training.
Preferred
  • Experience with healthcare, behavioral health, or human services data; electronic health record databases; Power Query; DAX; Python; Medicaid or quality reporting; or Microsoft PL-300 certification.
Tools you’ll use
  • Power BI, SQL, Power Query, Excel, DAX, Python, Microsoft PL-300, Medicaid
Compensation and benefits
  • Starting pay range: $72,009.60–$75,691.20 per year
  • Health, dental, vision
  • Retirement contribution matching
  • Paid time off
  • 12.5 flexible holidays
  • 12 days each of sick and vacation days accumulated in year one of employment, with accrual increasing yearly
Work environment
  • Primarily computer-based work in an office or hybrid environment in Barre, Vermont
  • Extended computer use, detailed data analysis, and collaboration with staff across agency departments
  • Occasional travel to agency sites for meetings or training may be required

Location: Administration Office - Barre, VT (Remote Hybrid)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst I — Power BI & SQL (Hybrid, VT)
Data Analyst I — Power BI & SQL (Hybrid, VT)

WASHINGTON COUNTY MENTAL HEALTH SERVICES INC • Barre (VT)

Hybrid
USD 72,000 - 76,000
Health, dental, vision
Retirement contribution matching
Paid time off
+2
Clinical Information Analyst I
Clinical Information Analyst I

Washington County Mental Health Services • Vermont

Hybrid
USD 72,000 - 76,000
Health benefits
Retirement contribution matching
Paid time off and holidays
Population Health Data Analyst
Population Health Data Analyst

Northern Counties Health Care Inc • St. Johnsbury (VT)

On-site
USD 40,000 - 62,000
Population Health Data Analyst
Population Health Data Analyst

Northern Counties Health Care Inc. • Vermont

On-site
USD 60,000 - 94,000
Data Analytics and Information Administrator
Data Analytics and Information Administrator

Vermont, Inc • Waterbury (VT)

On-site
USD 52,000 - 82,000
80% state medical premium
Dental plan at no cost
12 paid holidays
+8
Senior Data and Systems Analyst
Senior Data and Systems Analyst

Commonwealth of VA Careers • Richmond (VA)

Hybrid
USD 90,000 - 123,000
Clinical Data Analyst I: Power BI & SQL Insights
Clinical Data Analyst I: Power BI & SQL Insights

Washington County Mental Health Services, Inc. • Vermont

Hybrid
USD 72,000 - 76,000
Health benefits
Retirement contribution matching
Paid time off and holidays
Senior Data & Systems Analyst — Remote Analytics
Senior Data & Systems Analyst — Remote Analytics

Commonwealth of VA Careers • Richmond (VA)

Hybrid
USD 90,000 - 123,000
Data Analyst (2 positions available)
Data Analyst (2 positions available)

Marshall University • Huntington (WV)

On-site
USD 60,000 - 90,000
Senior Data and Systems Analyst
Senior Data and Systems Analyst

Department of Behavioral Health and Developmental Services • Richmond (VA)

On-site
USD 90,000 - 123,000