Data and Automation Analyst 2

Job DescriptionThe Opportunity Homecare Homebase (HCHB) is seeking a Data & Automation Analyst 2 to join our Intelligent Automation team. In this role, you'll build and maintain Dataverse data structures, develop Power BI dashboards, write custom SQL reports, and support automation-related data flows that enable scalable, insight-driven operations. The Challenge You will partner with stakeholders to translate business needs into trusted data products-well-designed Dataverse tables, accurate reporting datasets, and intuitive dashboards. You'll balance multiple requests, ensure data quality, and deliver reporting and automation-ready data solutions that drive measurable outcomes. What You'll Be Responsible For: Design, build, and maintain Dataverse tables (schema, relationships, data standards, and documentation) to support reporting and automation use cases Develop and enhance Power BI dashboards (data modeling, DAX measures, visuals, performance tuning, and publishing) Write and maintain custom SQL queries and reports to support operational and analytical needs Support automation data flows (data movement, transformations, refresh reliability, and monitoring) in partnership with the Intelligent Automation team Gather, clarify, and document requirements; translate them into scalable reporting and data solutions Perform validation and testing to ensure accuracy, consistency, and usability of dashboards and reports Create and maintain documentation (data definitions, report logic, refresh schedules, and support runbooks) Collaborate cross-functionally with business partners, analysts, engineers, and automation developers to deliver end-to-end solutions Demonstrate strong ownership, prioritize effectively, and meet delivery timelines while maintaining quality standards What We're Looking For Required 3+ years of experience in analytics/reporting, BI, or data automation support roles Strong SQL skills (joins, CTEs, aggregations, query optimization, validation) Strong experience building dashboards in Power BI (data modeling and DAX) Experience designing or working with Dataverse tables and relationships (or equivalent relational modeling experience with the ability to ramp quickly) Ability to translate business requirements into data models, reports, and dashboards Strong attention to detail and a consistent approach to testing and data validation Clear communication skills and comfort working directly with stakeholders Preferred Experience with Tableau (building and/or migrating dashboards) Familiarity with data integration/ETL concepts and scheduled refresh patterns Experience supporting automation initiatives (e.g., reporting for automation, operational metrics, data pipelines feeding automations) Healthcare, home health, or hospice industry experience Education Bachelor's degree preferred (e.g., Computer Science, Information Systems, Analytics, Statistics, Economics) or equivalent practical experience. What You Can Expect from Us At Homecare Homebase, we don't just help our clients succeed; we help our employees succeed. Competitive pay, robust benefits, and professional development opportunities are a few of the many reasons that Homecare Homebase is a great place to build your career. Our Team Members Also Enjoy Meaningful work. Our employees often tell us that their work gives them a sense of purpose because it makes a difference in the lives of clinicians and homecare staff. Flexibility. We value work-life balance because we know that happy employees create happy clients. That's why Homecare Homebase offers both full- and part-time career opportunities to fit life's unique demands, as well as the opportunity to work remotely for qualified candidates. A company that gives back. Every year, Homecare Homebase proudly supports numerous charitable fundraising initiatives that align with our mission of empowering exceptional care and helping others in need. About Homecare Homebase Founded in 1999, Homecare Homebase is dedicated to helping our clients overcome business and technological challenges that stand in the way of clinical outcomes and operational efficiency. We work with home health and hospice organizations to tackle problems big and small. Our services are rooted in systems thinking and reach across the entire organization - from Intake to Discharge - to achieve transformative results. Sound like a good fit? Please take a moment to apply for this position. This position does not provide sponsorship. All applicants should either be US Citizens or Permanent Residents eligible to work in the US without immigration restrictions.

Created: 2026-03-10