Data Analyst

JOB TITLE: Data Analyst

REPORTS TO: Director of Data Strategy & Reporting

DEPARTMENT: Data Strategy & Reporting

HOURS: 40 Hours Monday - Friday 9:00a - 5:00p

FLSA STATUS: Exempt

JOB TYPE: Full-Time

RATE: $90k - 125k

About Healthix

Healthix is the largest public health information exchange (HIE) in New York State, securely connecting thousands of healthcare providers, hospitals, health plans, and community organizations to improve the quality, safety, and efficiency of care. Through the secure exchange of health information, Healthix helps ensure that clinicians, care teams, and public health partners have access to the data they need to make informed decisions and deliver better outcomes for the communities they serve.

As part of our ongoing organizational transformation, Healthix is expanding its focus beyond data exchange to making health information more actionable and impactful for healthcare providers, community partners, and public health initiatives. This transformation reflects our commitment to strengthening community partnerships, improving health equity, and supporting innovative approaches that connect healthcare with community-based services.

Through initiatives such as Healthix Connects, our internal volunteer and community engagement program, we are deepening our relationships with local organizations and creating opportunities for our team to actively support healthier, safer communities.

Joining Healthix means becoming part of a mission-driven organization that is shaping the future of health information sharing while building stronger connections between healthcare systems and the communities they serve.

THE ROLE:

The Data Analyst provides the foundation for analytics, namely the collection, quality assurance and availability of data. This IT role requires a significant set of technical skills, including a deep knowledge of SQL, SQL database design and multiple programming languages as well as communication skills to understand what data and analysis the healthcare analysts want to gain from Healthix data stores. They are responsible for the maintenance, improvement, cleansing and manipulation of data in the organization’s operational and analytics databases. The Data Analyst works with team members to define and build data pipelines to orchestrate the movement, transformation, validation, and loading of data from the source to the final destination - data stores defined and implemented based on system requirements and data consumer requirements.

Typical tasks performed include working with the data architect on data warehouse design, ensuring data loads quickly, is easily accessible and rapidly comprehensible for analysts/users; extract, transform, and load (ETL) processing; performing thorough testing and validation in order to support the accuracy of data transformations and data verification to ensure correctness and that data is generally reliable for downstream consumption; data bounds checking and database tuning.

The Data Analyst strives to ensure proper data governance and quality for the Data Strategy team and the entire organization. They analyze complex data elements and systems, data flow, dependencies, and relationships to contribute to conceptual physical and logical data models. They work collaboratively within the Data Strategy team, providing support for their data centric needs. The candidate has strong working and conceptual knowledge of database queries multidimensional query and index tuning, monitoring, disaster recovery, backup, automated testing, automated schema migration, and continuous deployment.

KEY RESPONSIBILITIES:

• Enhance and streamline data and pipeline architecture to improve data flow and collection.
• Partner with software developers, database architects, and data analysts to support data initiatives and ensure reliable data delivery.
• Independently address the data requirements of multiple teams, systems, and products.
• Refine or redesign Healthix’s data architecture to enable next-generation products and data capabilities.
• Build and maintain scalable data pipelines and reporting solutions to support growing data volumes, performance and complex queries across Databricks, MS SQL Server, and InterSystems HealthShare.
• Work with Data Strategy and Business teams to improve data models and increase data accessibility for business intelligence.
• Implement monitoring processes to safeguard data quality, accuracy, and availability for key stakeholders.
• Develop queries, support reporting needs, and tailor reporting solutions to enable data-driven decision-making.
• Develop and execute unit and data validation tests while maintaining accurate documentation, perform data analysis to troubleshoot issues, support feasibility assessments, evaluate health outcomes, and resolve data-related problems.
• Provide general reporting and project support across the organization.
• Ensure reporting meets standards for reliability, accuracy, completeness, and compliance.
• Support the development, ETL processes, and maintenance of company data assets and data models, design data integrations and data quality frameworks.
• Evaluate open-source and vendor data-lineage tools and contribute to long-term data platform architecture planning across IT and Business teams.
• Assist in developing an integrated data warehouse to provide a comprehensive healthcare dataset.

Requirements

QUALIFICATIONS, SKILLS and COMPETENCIES:

• 5+ years of experience in a Data Analyst role, with a graduate degree in Computer Science, Statistics, Healthcare Informatics, Informatics, Information Systems, or a related field. IBM Certified Data Engineer or Google Certified Professional is preferred.
• Experience with healthcare data, including HL7, CCDAs, MS SQL Server, Databricks, Tableau, InterSystems HealthShare, and Cache databases.
• Advanced SQL knowledge and experience with relational databases, query authoring, and familiarity with various databases.
• Proficient in database design principles, including relationships, normalization, structures, indexes, views, and analyzing database requirements.
• Experience in building and optimizing big data pipelines, architectures, and data sets.
• Strong analytical skills and experience in performing root cause analysis on data and processes to answer business questions and identify improvement opportunities.
• Experience in developing processes for data transformation, structures, metadata, dependency, and workload management.
• Working knowledge of message queuing, stream processing, and scalable big data stores.
• Proficient in big data tools such as Hadoop, Spark, and Kafka.
• Experience with relational SQL and NoSQL databases.
• Strong programming skills with languages like Python, Java, C++, and Scala.
• Ability to architect end-to-end ETL pipelines.
• Experience with AWS services and BI tools like Tableau.
• Strong quantitative, analytical, process development, facilitation, and organizational skills.
• Excellent documentation and verbal communication skills, with the ability to clearly communicate technical concepts to both technical and non-technical stakeholders.