Data Analyst I

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)