Job Description:
At National Church Residences, we believe every senior should lead a vibrant, healthy, and independent life. Since 1961, our mission has been to provide quality housing that meets the diverse and evolving needs of seniors.
With over 340 communities across 25 states, we are the nation’s largest not-for-profit provider of affordable senior housing and the leading employer of service coordinators. In addition to residential senior communities, we offer home and community-based services and permanent supportive housing for formerly homeless and disabled individuals.
PURPOSE
According to the prescribed policies and procedures of the organization including all applicable federal, state and local regulations and under the general supervision of the Director of Data Analytics, this position is responsible for managing, analyzing, and visualizing health data to support organizational decision-making. This position will focus on leveraging SQL, report automation, and data visualization tools such as Power BI to ensure data accuracy, streamline reporting processes, and provide actionable insights for various stakeholders.
ESSENTIAL FUNCTIONS
Responsible for maintaining data analysis and reporting policies, support strategic goals, and foster collaboration with stakeholders.
Data Analysis & Reporting:
- Design and optimize complex SQL queries to extract, manipulate, and analyze health data from diverse sources.
- Create, manage, and enhance databases, tables, views, and stored procedures to fulfill health data reporting requirements.
- Automate recurring reports to streamline processes and minimize manual effort, utilizing tools like SQL Server Reporting Services (SSRS) or other reporting frameworks.
- Conduct manual data entry and generate reports from various third-party platforms.
- Deliver market intelligence analysis to compare and benchmark organizational service lines against competitors.
- Perform ad hoc analysis to assist operations in addressing business challenges.
- Contribute to strategic growth initiatives aimed at expanding organizational services.
Data Visualization & Dashboarding:
- Design and create interactive dashboards and reports using Power BI and other BI applications to effectively communicate data insights to non-technical stakeholders.
- Collaborate with clinical and administrative teams to gather reporting requirements and develop custom visualizations that enhance health outcomes and operational performance.
- Optimize reports and dashboards in Power BI or other BI applications for improved performance and usability.
Quality Assurance & Data Governance:
- Ensure data quality through rigorous validation and testing of data extracts and reports.
- Uphold and implement data governance standards and practices to maintain the consistency, accuracy, and security of health data.
- Facilitate coordination efforts for establishing data connections and extractions from vendor systems.
Stakeholder Collaboration:
- Partner with clinical, operational, and IT teams to support data-driven initiatives and projects.
- Deliver training and support to end-users on Power BI, report interpretation, and data literacy.
- Transform complex data concepts into actionable insights and recommendations.
Continuous Improvement & Innovation:
- Stay current on industry trends and best practices in healthcare, health informatics, data analytics, and reporting technologies.
- Identify opportunities to enhance existing processes, tools, and methodologies to improve data accessibility and usability.
EXPECTATIONS
- Demonstrates and maintains a positive, professional manner, manages time efficiently and effectively, provides leadership as a role model to promote a team approach, collaborates and participates in policy creation and appropriate problem-solving methods.
- Must adhere to all policies, procedures, terms and conditions set forth in the National Church Residences’ Employee Information Guide (EIG), the Code of Conduct, as well as any facility handbook, including but not limited to, corporate compliance, drug free workplace, safe work practices, all federal, state, local regulations and laws.
- With respect to Resident Rights, ensures all care is provided with respect and dignity for the residents/clients, their families and the staff. Reports all complaints made by residents/clients and/or families to the appropriate supervisors, reports all allegations of abuse, misappropriation of funds/resident property and/or any other corporate compliance, drug free workplace, safe work practices, all federal, state and local regulations and laws.
- Completes all annual education requirements timely, including but not limited to Compliance, Privacy, Security and HIPAA training and exhibits behavior as set forth by the Code of Conduct in the performance of their duties.
- Performs other duties as assigned.
Education:
Bachelor’s degree in Health Informatics, Data Analytics, Computer Science, Public Health, or a related field.
Experience:
- Minimum of 3 years of experience in health informatics or data analytics.
- Proven experience with SQL (e.g., complex queries, stored procedures).
- Hands-on experience with data visualization tools, particularly Power BI.
- Experience in report automation and working with large health data sets. Knowledge in the health information field and working with healthcare data.
- Experience in working with Electronic Health Records (EHR) data.
Skills:
- Advanced proficiency in SQL (e.g., querying, database management).
- Strong experience with Power BI or other BI applications and Microsoft Excel.
- Experience in report automation (e.g., SSRS, SQL).
- Familiarity with data warehousing and ETL processes.
- Understanding of healthcare data standards (e.g., ICD, CPT, HL7) and regulatory requirements (e.g., HIPAA).
- Must have good working computer skills with basic professional computer software (Microsoft Office suite, Windows, etc.) and the capacity for learning new software systems quickly.
- Must be self-directed with excellent organizational, analytical and problem-solving skills and the ability to manage tasks and assignments concurrently.
- Must have excellent communication, comprehension, and interpersonal skills. Must have the ability to speak, read, write and understand English, as well as the ability to make self-understood.
- Must have strong motivational skills and a high emotional intelligence quotient (EQ)
Travel: Rare, up to 10% with overnight stays
In return, National Church Residences offers an excellent total reward package that includes:
- Medical & Rx – 3 plan options to fit your budget; choose from coverage offered through a Nationwide network for you and your family
- Complimented with a Healthcare Flexible Spending Account or Employer funded Health Savings Account
- Includes Fertility & Family Building Support, Weight Management, and Chronic Condition Support
- Parental Leave paid at 100% for four weeks
- Coverage begins first of the month following your date of hire!
- Dental & Vision coverage for you and your family with Nationwide providers.
- Company provided Life & ADD insurance and Disability coverage.
- Supplemental benefits such as Life and AD&D for you and your family, Accident Insurance, Hospital Indemnity, and Critical Illness.
- Flexible Spending Accounts for Dependent Care and Transportation & Parking
- Well-being Programs including an enhanced EAP with mental health and work-life support, tobacco cessation, and Well-Being Your Way which offers up to $1000/year in rewards & reimbursements!
- Retirement Savings Plan offering immediate company funding at 3%, increasing up to 5% over time and an additional company match up to 5% when you contribute your own funds!
- Reimbursement for Tuition expenses
- Paid Time Off (PTO), 9 paid Holidays and Parental Paid Leave at 100%
(Programs vary depending on Full Time, Part Time or Contingent Status)
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, ancestry, military status, disability, genetic information and/or any other characteristics protected by applicable law.
