Senior Data Analyst (Hybrid)

Beth Israel Deaconess Medical Center, Inc.; Boston (MA); On-site; USD 75,000 - 125,000; Full time

Job summary

The position will develop dashboards, management reports, and analytics for leadership, define the reporting pipeline for grants operations, and collaborate with Grants Administration, Finance, Compliance, IS, and other groups to enable informed decision-making and process improvement. Experience with Snowflake, ELT processes, and PowerBI is preferred.

Qualifications

• Bachelor's degree required in Computer Science, Allied Health, or related field.
• 3-5 years related work experience required.
• 1-3 years of multiple application maintenance with relational databases.

Responsibilities

• 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.
• 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.
• Collaborates with IS to obtain and maintain applications used for data collection and reporting. Recommends tools, upgrades and alternatives.
• Designs and develops reporting and analysis tools. Interprets data and refines analysis. Prepares and presents comprehensive reports.

Skills

Data analysis

SQL

Power BI

ELT processes

Education

Bachelor's degree in Computer Science, Allied Health, or related field

Tools

Snowflake

Relational databases

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

• 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.
• 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.
• 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.
• 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.
• 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.
• Prepares weekly, monthly, and quarterly reports/dashboards and/or data submissions department.

Required Qualifications

• Bachelor's degree required in Computer Science, Allied Health, or related field.
• 3-5 years related work experience required.
• 1-3 years of multiple application maintenance with relational databases.
• 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 on several factors, that may include seniority, education, training, relevant experience, relevant certifications, geography of 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 At Beth Israel Lahey Health, we are driving the change in health care that Massachusetts wants and needs. Our culture promotes continuous learning, growth, innovation and a sense of belonging. We make it a priority to offer comprehensive compensation and benefits and help you achieve a healthy and balanced life. While you're busy caring for and supporting our patients, we take care of you.