Data Analyst

Company Description:

Founded in 2006, eHealth Technologies is the leading provider of medical record retrieval and organization services and image-enabled Health Information Exchanges (HIEs). With customers across the country, eHealth Technologies works with prominent HIEs and the nation s top-ranked hospitals, including 17 of the 20 US News World Report Honor Roll Hospitals for 2020-2021. The company s eHealth Connect solution enhances patient and physician satisfaction by streamlining referrals and intelligently aggregating patients clinical records. This assures physicians have the right healthcare information to care for their patients, right when they need it. As a critical adjunct to HIEs, eHealth Connect Image Exchange enables automated access to all types of medical images in the context of the aggregated patient record, in full diagnostic quality.

Career Opportunity Description:

We are looking for a detail-oriented Data Analyst with a strong background in data management and Excel proficiency to join our team. The candidate will be responsible for managing and analyzing data to support business decisions, ensuring the accuracy and integrity of our data systems. This role demands expertise in Excel formulas, pivot tables, and macros, with the ability to generate comprehensive reports. The ideal candidate will have a strong foundation in mathematics and 3-5 years of experience in a similar role.

This position is a member of eHealth Technologies Data Analysis Team which is comprised of team members that are deployed to create and maintain all reports assigned.

Data analysts play a crucial role in organizations by transforming raw data into actionable insights.

• Running regular reports and maintaining dashboards
• Answering data-related questions from different departments
• Monitoring key performance indicators
• Investigating anomalies in data

This individual will work in a dynamic, fast-paced, team-oriented work environment that is guided by and always upholds company core values.

Primary Responsibilities:

• Responsible for managing and maintaining data in Excel ensuring accuracy and consistency.
• Develop and automate reports using Excel formulas, pivot tables, and macros.
• Analyze large datasets to generate actionable insights and support business decision-making.
• Create and maintain dashboards to monitor key performance indicators (KPIs).
• Collaborate with different departments to understand data requirements and deliver customized reports.
• Troubleshoot data issues and implement solutions to improve data integrity.
• Provide training and support to team members on Excel and data management best practices.
• Assist in the continuous improvement of data management processes and tools.
• Know how to work with Power BI.
• Basic knowledge of data analytics
• should know how to create dashboards using from multiple data sources.
• Generate, maintain, consolidate, and track daily, weekly, and monthly MIS reports.
• Prepare dashboards and reports on a daily, weekly, monthly, quarterly, and yearly basis.
• Collect and analyze data sets using MSSQL, MySQL and Advance Microsoft Excel.
• Proactively interact with stakeholders to ensure timely preparation of MIS reports.
• Understand processes, delivery, and operations management to align reporting with business objectives.
• Analyze data and reports from multiple sources to provide actionable insights and recommendations.
• Prepare ad hoc reports as per stakeholder requirements.
• Work with other functions to assist in maintaining trackers for streamlined reporting.
• Identify opportunities to automate reports, snapshots, and dashboards to improve efficiency.
• Ensure reports are contextual, audience-specific, and relevant to business needs.
• Ensure on-time and accurate delivery of reports, analysis, and service requests.

Information Privacy and Security

In an effort to safeguard the information privacy and security of all covered information Employee shall also be responsible for:

1. Following eHealth Technologies information privacy and security policies, procedures, standard operating procedures, appendices, attachments, etc.

2. Accessing, using, and disclosing only the minimum necessary covered information that is needed for job responsibilities, or otherwise allowed by law.

3. Safeguarding the confidentiality, integrity, and availability of covered information always, whether or not on duty.

Knowledge and Skill Requirements:

• Hands-on experience in data analysis, MIS reporting, and creating dashboards.
• Proficiency in Microsoft Excel, including advanced formulas, pivot tables, and data analysis.
• Experience with data management tools.
• Strong mathematical skills with the ability to analyze and interpret complex data sets.
• Excellent problem-solving skills and attention to detail.
• Effective communication skills to collaborate with various departments.
• Ability to manage multiple tasks and prioritize workload effectively.
• 3-5 years of experience in a similar MIS or data management role.
• Open to work in flexible shift
• Monitor trends, performance metrics, and assist managers in process improvement.
• Proficiency in VBA, SQL and Excel (Basic + Advanced) is required.
• Advanced skills MS Excel, BI tools, including formulas, VLOOKUP, and dashboard creation.
• Strong expertise in data analytics and data modelling.
• Adaptability to new tools and technologies.
• Ability to multitask and manage diverse reporting requirements.
• Strong focus on automating repetitive tasks to enhance efficiency.
• Excellent analytical skills, logical reasoning, and ability to process large-scale data.
• Proven ability to build credibility, trust, and stakeholder relationships at all levels.
• Strong organizational and time management skills to handle variable workloads.
• Innovative mindset with a focus on automation and process improvements.
• Self-motivated team player with the ability to work independently and meet expectations.

Key Relationships:

1. Directly supervised by Director Operations Excellence
2. Interacts regularly with eHealth Technologies staff of all departments.