Sr. Data Analyst

Family Care Center; Lone Tree (CO); On-site; USD 130,000 - 150,000; Full time

Job summary

Family Care Center seeks a Senior Data Analyst to convert organizational data into actionable insights through dashboards, reports, and ad-hoc analyses. You will build BI products, contribute to data warehouse modeling with the Data Engineering team, and ensure reports are clear, efficient, and consumable by business stakeholders.

As self-service analytics and AI-assisted capabilities expand, you will guide staff and AI tools in navigating data assets and ensuring outputs are accurate and

Qualifications

• Bachelor's degree in Data Science, Statistics, Business Analytics, Information Systems, or related field; master's preferred.
• 5+ years in data analytics or business intelligence; healthcare data preferred.
• Strong SQL; Git; Excel; Python; dbt experience.
• HIPAA familiarity preferred.

Responsibilities

• Designs, builds, and maintains dashboards and reports using BI tools; ensure visualizations are intuitive and clearly labeled.
• Develops and executes ad-hoc SQL queries and Python analyses to support nuanced analytical requests.
• Collaborates with stakeholders to translate reporting needs into accurate, performant products.
• Creates and modifies data models in the data warehouse using SQL and dbt.
• Partners with Data Engineer to ensure data assets are well documented and accessible.
• Applies best practices in data visualization to communicate insights effectively.
• Maintains and improves reporting infrastructure for reliability and performance.
• Develops documentation, data dictionaries, and guidance materials for self-service analytics.
• Guides staff and AI-assisted analytics tools to use data warehouse assets accurately.
• Monitors report usage and feedback to improve quality and accessibility.

Skills

SQL proficiency

Git

Python

dbt

HIPAA knowledge

Microsoft Excel

Education

Bachelor's degree in Data Science/Analytics/Information Systems

Master's degree preferred

Tools

Power BI

Tableau

Lightdash

Apache Superset/Preset

Job description

Description

• 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.

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.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.