Data Analyst

Healthix • New York, NY

6d

About The Position

The Data Analyst provides the foundation for analytics through data collection, quality assurance, and availability. This technical role maintains, improves, cleanses, and manipulates data in operational and analytics databases, and collaborates with healthcare analysts to understand the data and analysis they need from Healthix data stores.

The analyst works with team members to define and build data pipelines that orchestrate the movement, transformation, validation, and loading of data from source systems to destinations designed around system and data-consumer requirements. The role includes working with the data architect on data warehouse design; supporting fast data loads and accessible, comprehensible data; performing ETL; validating transformations and data; and conducting data bounds checking and database tuning.

The Data Analyst supports data governance and quality across the Data Strategy team and organization. The position analyzes complex data elements, systems, flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models. It also requires working knowledge of database queries, multidimensional queries, index tuning, monitoring, disaster recovery, backups, automated testing, automated schema migration, and continuous deployment.

Requirements

• At least 5 years of experience in a Data Analyst role.
• Graduate degree in Computer Science, Statistics, Healthcare Informatics, Informatics, Information Systems, or a related field.
• 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.
• Proficiency in database design principles, including relationships, normalization, structures, indexes, views, and analyzing database requirements.
• Experience building and optimizing big data pipelines, architectures, and data sets.
• Strong analytical skills and experience conducting root cause analysis on data and processes to answer business questions and identify improvement opportunities.
• Experience developing processes for data transformation, structures, metadata, dependency, and workload management.
• Working knowledge of message queuing, stream processing, and scalable big data stores.
• Proficiency with big data tools such as Hadoop, Spark, and Kafka.
• Experience with relational SQL and NoSQL databases.
• Strong programming skills with languages such as Python, Java, C++, and Scala.
• Ability to architect end-to-end ETL pipelines.
• Experience with AWS services and BI tools such as Tableau.
• Strong quantitative, analytical, process development, facilitation, and organizational skills.
• Excellent documentation and verbal communication skills, including the ability to clearly communicate technical concepts to technical and non-technical stakeholders.

Nice To Haves

• IBM Certified Data Engineer certification or Google Certified Professional certification.

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 data requirements across 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 across Databricks, MS SQL Server, and InterSystems HealthShare, supporting growing data volumes, performance, and complex queries.
• 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 stakeholders.
• Develop queries, support reporting needs, and tailor reporting solutions for data-driven decision-making.
• Develop and execute unit and data validation tests, maintain 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 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 that provides a comprehensive healthcare dataset.
• Work with the data architect on data warehouse design and help ensure data loads quickly and is accessible and comprehensible to analysts and users.
• Perform ETL processing, thorough testing and validation of data transformations, data verification, bounds checking, and database tuning.
• Contribute to conceptual, physical, and logical data models by analyzing data elements, systems, flows, dependencies, and relationships.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior