Sr. Data Analyst

Description

Position Summary: The Senior Data Analyst translates organizational data into actionable insights through dashboards, reports, and ad-hoc analyses that support business decision-making across Family Care Center. This role builds and maintains BI reporting products, contributes to data warehouse modeling in collaboration with the Data Engineering team, and ensures that reports are designed for clarity, efficiency, and ease of consumption by business stakeholders. As the organization expands its self-service analytics and AI-assisted capabilities, the Data Analyst plays a key role in guiding staff and AI tools to effectively navigate and leverage available data assets.

Essential Responsibilities:

• Designs, builds, and maintains dashboards and reports using BI tools, ensuring visualizations are intuitive, clearly labeled, and optimized for business consumption.
• Develops and executes ad-hoc SQL queries and Python-based analyses to support non-recurring, nuanced analytical requests from across the organization.
• Collaborates with business stakeholders to understand reporting needs and translate requirements into well-structured, accurate, and performant analytical products.
• Creates and modifies data models in the data warehouse using SQL and dbt to support new and evolving reporting requirements.
• Partners with the Data Engineer to ensure data assets are well documented, consistently defined, and accessible to both technical and business audiences.
• Applies data visualization best practices - including appropriate chart selection, clear labeling, and intuitive layout - to ensure reports communicate insights effectively.
• Maintains and improves existing reporting infrastructure, identifying opportunities to consolidate redundant reports, improve performance, and increase reliability.
• Supports the organization's self-service analytics initiatives by developing documentation, data dictionaries, and guidance materials that enable business users to independently explore and interpret data.
• Serves as a resource for staff and AI-assisted analytics tools, helping guide effective use of available data warehouse assets and ensuring outputs are accurate and appropriately contextualized.
• Monitors report usage and stakeholder feedback to proactively identify opportunities to improve the quality, relevance, and accessibility of analytical products.

Other Duties:

• Performs other related duties as assigned by management.

Supervisory or Managerial Responsibility: None

Minimum Qualifications:

• Bachelor's degree in Data Science, Statistics, Business Analytics, Information Systems, or a related field required. Master's degree preferred. Minimum of 5 years of experience in a data analytics or business intelligence role required. Experience working with healthcare or behavioral health data preferred.
• Strong SQL proficiency required. Experience with Git is required. Proficiency in Microsoft Excel required. Experience with at least one major BI platform required - Power BI, Tableau, Lightdash, or Apache Superset/Preset. Ability to use Python for data analysis and ad-hoc reporting required. Experience writing or modifying dbt models preferred. Familiarity with HIPAA and healthcare data privacy standards preferred.
• Work Environment and Conditions: Continually required to sit, utilize hand, and finger dexterity, talk, and hear. Work environment is usually quiet to moderate. Frequently working at a desk in front of a computer. Occasionally required to lift and/or move up to 15 pounds.

Annual Compensation: $130,000 - $150,000 Family Care Center is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.