Data Analyst Intern Jobs in Commack, NY (NOW HIRING)

JOB TITLE: Data Analyst

REPORTS TO: Director of Data Strategy and Reporting

DEPARTMENT: IT

HOURS: 40 Hours

FLSA STATUS: Exempt 

SALARY: $90k-125k

POSITION SUMMARY:

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.

Essential Duties and 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.

Supervisory Responsibilities:

• This job has no supervisory responsibilities.

Qualifications:

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

Healthix is a non-profit organization that works to improve patient care and manage population health. We securely aggregate patient health data from hospitals, labs, ambulatory care facilities and more and we share it amongst providers to improve clinical outcomes and enhance value based care delivery.