Data Analyst I

Job Details: Job Location: Administrative Office - Barre, VT, Salary Range: $72009.60 - $75691.20Salary, Data Analyst I Quick Facts Starting pay: $72,009.60–$75,691.20 per year Location: Administration Office - Barre, VT — [Remote Hybrid] Employment type: Full-time Benefits: Health, dental, vision, retirement contribution matching, and paid time off Turn data into insights that help improve care, strengthen programs, and support the delivery of essential community mental health services. As a Data Analyst I at Washington County Mental Health Services (WCMHS), you will help transform clinical, billing, and operational data into accurate, actionable reports that support decision-making, program performance, and regulatory compliance. This is an entry-level opportunity for someone who enjoys problem-solving, working with data, and making complex information easier to understand. You'll work with Power BI, SQL, and Excel while collaborating with clinical leaders, finance, quality assurance, and other agency staff. With guidance from experienced colleagues, you'll build your analytical skills, learn the agency's data systems, and contribute to reporting that supports effective services and better outcomes for the community. Summary of Duties Build, publish, and maintain Power BI reports and dashboards that help program managers, clinical leaders, and finance staff monitor service volume, caseloads, productivity, billing, and assessment completion. Extract, clean, organize, and validate data using SQL, Power Query, and Excel to produce reliable reports and support analytical requests. Develop and maintain Power BI measures and visualizations, manage report updates and access permissions, and respond to reporting requests from agency staff. Prepare, review, and reconcile data for state and federal reporting requirements, including applicable Medicaid, service utilization, and quality measure submissions. Identify missing, duplicate, or inconsistent data and collaborate with clinical, billing, management, and IT staff to resolve discrepancies and improve data quality. Document queries, data definitions, reporting logic, and standard measures to support consistent, reproducible, and auditable reporting. Translate reporting results into clear, useful information for technical and nontechnical audiences while protecting confidential client information and following agency privacy and security policies. Compensation and Benefits WCMHS provides a comprehensive benefits package including health, dental, vision, and retirement contribution matching. Our industry-leading paid time off package includes 12.5 flexible holidays and 12 days each of sick and vacation days accumulated in year one of employment and accrual increases yearly. The starting pay range for this position is $72,009.60–$75,691.20 per year. Qualifications: Summary of Qualifications A bachelor's degree in data analytics, information systems, statistics, public health, or a related field; an associate degree plus two years of relevant experience; or an equivalent combination of education and experience. Zero to two years of experience in data analysis or reporting, including internships, academic projects, or portfolio work. Experience building Power BI reports, shaping data, creating relationships, and developing basic measures is required. Working knowledge of SQL, including multi-table joins, filtering, aggregations, and date-based queries, along with the ability to read and modify existing queries. Proficiency in Excel, including PivotTables, lookup functions, conditional formulas, data validation, and data cleaning, is also required. Strong attention to detail, analytical thinking, and problem-solving skills, with the ability to validate results against source data, manage competing priorities, and communicate findings clearly to technical and nontechnical audiences. 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 is preferred. A commitment to confidentiality, data integrity, and the mission of public mental health services is essential. The ability to deliver services and complete treatment notes in English. Work Environment and Physical Requirements This is primarily a computer-based position in an office or hybrid work environment in Barre, Vermont. The role involves 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. Employees must handle confidential and protected health information responsibly, follow applicable HIPAA requirements and agency privacy and security policies, and complete required background checks and privacy training. About the Agency For more than 50 years, Washington County Mental Health Services (WCMHS) has served the Washington County community and the Orange County towns of Orange, Washington, and Williamstown. WCMHS provides education, support, and treatment to individuals and families living with mental health challenges, substance use issues, and developmental and intellectual disabilities. Providing accessible, high-quality services in the community, schools, and health care settings, we work toward positive outcomes for wellness with collaborative, inclusive, and compassionate care. Washington County Mental Health Services is “Where Hope and Support Come Together.” #PPA