Senior Data Analyst (Hybrid)

Anna Jaques Hospital; Boston (MA); On-site; USD 75,000 - 125,000; Full time

Job summary

Beth Israel Lahey Health (BILH) seeks an experienced Senior Project Manager & Data Analyst to support grants management operations, reporting, and analytics across the organization. You will liaison between grants stakeholders, technical teams, and business analysts to ensure data accuracy and develop dashboards for leadership.

The role emphasizes data mapping, ELT processes, and reporting using SQL, PowerBI, and Snowflake, with collaboration across Finance, Compliance, IS, and Grants

Qualifications

• Bachelor's degree required in Computer Science, Allied Health, or related field.
• 3-5 years related work experience.
• 1-3 years of multiple application maintenance with relational databases.
• Advanced technical computer skills for technical support specific to functional area and related systems.

Responsibilities

• Manages one or more complex data projects using hospital systems and database applications to update and analyze data.
• Maintains integrity and quality of data and supports data collection criteria; trains staff.
• Ensures application access is in compliance with regulatory practices and defines user access.
• Collaborates with IS to maintain applications used for data collection and reporting; recommends tools and upgrades.
• Designs and develops reporting and analysis tools; prepares and presents comprehensive reports.
• Prepares weekly, monthly, and quarterly reports/dashboards for the department.

Skills

SQL

PowerBI

Data analysis

Data mapping

ELT processes

Dashboard design

Reporting tools

Education

Bachelor's degree

Tools

Snowflake

Job description

When you join the growing BILH team, you're not just taking a job, you’re making a difference in people’s lives.

Seeking an experienced Senior Project Manager & Data Analyst to support grants management operations and reporting across Beth Israel Lahey Health (BILH). The Senior Project Manager & Data Analyst will serve as a liaison between grants management stakeholders, technical teams, and system business analysts ensuring the accuracy and integrity of data within the grants management system and related applications. This role will manage data elements, system interactions, and reporting requirements while developing dashboards, management reports, and analytics for leadership and other stakeholders. The position will define and oversee the reporting pipeline for the various grants operations groups, including the selection, validation, and integration of data elements from the grants management system into the enterprise data warehouse to support consistent reporting and analytics. The role will collaborate closely with Grants Administration, Finance, Compliance, Information Systems, and other ancillary groups to support informed decision-making, process improvement, and the effective use of grants management and compliance data. Successful candidates will have demonstrated experience with enterprise data lake queries (like SnowFlake), familiarily with ELT processes, report and dashboard design, and ad hoc reporting using SQL tools and PowerBI.

Leverages software applications to design solutions, performs detailed data mapping and analysis and reviews all data for accuracy and reasonableness prior to distribution. Produces business, research or clinical intelligence.

Job Description:

Essential Responsibilities:

• 1. Manages one or more complex data projects. Utilizes hospital systems and database applications to update and analyze data. Prepares and distributes various reports to key stakeholders. Meets with departmental leadership to review reports or requests for data.
• 2. Maintains integrity and quality of data and assures data conformity meets operational requirements and goals. Acts as a central resource and integral member of data collection team. Assists in planning, establishing and monitoring criteria for data collection. Trains department staff on data acquisition methods. Extracts data from multiple sources. Audits and resolves all issues.
• 3. Ensures application access is in compliance with all regulatory and medical center practices. Acts as gatekeeper for application. Sets and defines user access and determines level of access. Reports all security risks to the application.
• 4. Collaborates with IS to obtain and maintain applications used for data collection and reporting. Recommends tools, upgrades and alternatives. Assists in the development of application security and back-up plans. Coordinates interface solution with multiple applications.
• 5. Designs and develops reporting and analysis tools. Interprets data and refines analysis. Prepares and presents comprehensive reports. Develops forms, tables and other data tools in the applications that capture, report and consolidate data. Provides application data collection, analytics and reporting expertise. Completes analytics in a timely and efficient manner.
• 6. Prepares weekly, monthly, and quarterly reports/dashboards and/or data submissions department.

Required Qualifications:

• 1. Bachelor's degree required in Computer Science, Allied Health, or related field.
• 2. 3-5 years related work experience required.
• 3. 1-3 years of multiple application maintenance with relational databases.
• 4. Advanced technical computer skills as required for technical support specific to functional area and related systems.

Preferred Qualifications:

• Application Certification for one of the applications used in the department.

Competencies:

Written Communications:

Ability to summarize and communicate in English moderately complex information in varied written formats to internal and external customers.

Oral Communications:

Ability to comprehend and communicate complex verbal information in English to medical center staff, patients, families and external customers.

Knowledge:

Ability to demonstrate in-depth knowledge of concepts, practices and policies with the ability to use them in complex varied situations.

Teamwork:

Ability to act as a team leader for small projects or work groups, creating a collaborative and respectful team environment and improving workflows. Results may impact the operations of one or more departments.

Customer Service:

Ability to provide a high level of customer service to patients, visitors, staff and external customers in a professional, service-oriented, respectful manner using skills in active listening and problem solving. Ability to remain calm in stressful situations.

Physical Nature of the Job:

Sedentary work: Exerting up to 10 pounds of force occasionally in carrying, lifting, pushing, pulling objects. Sitting most of the time, with walking and standing required only occasionally.

Pay Range:

$74,880.00 USD - $124,800.00 USD

The pay range listed for this position is the annual base salary range the organization reasonably and in good faith expects to pay for this position at this time. Actual compensation is determined based based on several factors, that may include seniority, education, training, relevant experience, relevant certifications, geographyof work location, job responsibilities, or other applicable factors permissible by law.

As a health care organization, we have a responsibility to do everything in our power to care for and protect our patients, our colleagues and our communities. Beth Israel Lahey Health requires that all staff be vaccinated against influenza (flu) as a condition of employment.

More than 35,000 people working together. Nurses, doctors, technicians, therapists, researchers, teachers and more, making a difference in patients' lives. Your skill and compassion can make us even stronger.

Equal Opportunity Employer/Veterans/Disabled