Data Analyst

Healthix • New York, NY

7d • $90,000 - $125,000

About The Position

The Data Analyst provides the foundation for analytics through the collection, quality assurance, and availability of data. This technical role maintains, improves, cleanses, and manipulates data in Healthix’s operational and analytics databases. The analyst works with colleagues to define and build pipelines that move, transform, validate, and load data from source systems to destinations designed around system and data-consumer requirements.

The role includes collaborating with the data architect on data warehouse design; supporting fast, accessible, and understandable data loads; performing ETL; testing and validating transformations; verifying data correctness and reliability; checking data bounds; and tuning databases. The Data Analyst supports data governance and quality across the Data Strategy team and the organization, and analyzes data elements, systems, flows, dependencies, and relationships to contribute to conceptual, physical, and logical data models.

The analyst works collaboratively with the Data Strategy team and other stakeholders to support data needs. The position calls for working and conceptual 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.
• A 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.
• Strong quantitative, analytical, process-development, facilitation, and organizational skills.
• Excellent documentation and verbal communication skills, including the ability to communicate technical concepts clearly to technical and non-technical stakeholders.

Nice To Haves

• IBM Certified Data Engineer or Google Certified Professional certification.
• Experience with AWS services and BI tools such as Tableau.

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 for growing data volumes, performance needs, and complex queries across Databricks, MS SQL Server, and InterSystems HealthShare.
• Work with Data Strategy and Business teams to improve data models and increase business-intelligence data accessibility.
• 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, maintain accurate documentation, analyze data 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.

What This Job Offers

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