Open position

Job Type: Regular

Time Type: Full time

Work Shift: Day (United States of America)

FLSA Status: Exempt

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

Job Summary: Reporting to the Business Intelligence (BI) Manager, the BI Developer is responsible for managing the enterprise wide database for Beth Israel Deaconess HealthCare (BIDHC) and the integration and integrity of data from various sources. The BI Developer will be responsible for creating packages that capture the business and data requirements within BIDHC's technical environment. The BI Developer is responsible for managing the overall data and reporting life cycle.

Job Description:

Essential Responsibilities:

Implement and support BIDHC database models and data warehousing projects in a Microsoft environment using SQL Server 2012/2014/2016 and newer technologies adopted by BIDHC.

Design and document data algorithms, report design requirements and flowcharts. Creates database structures, procedures, triggers and appropriate indexing methods to optimize data storage and retrieval processes.

Design, develop and optimize ETL data transformations and SSIS packages. Debugs and troubleshoots databases and database objects performance and data quality issues. Document error logs and solutions. Monitor SSIS packages and ETL processes to ensure accuracy and data quality. Provide assistance to others in topics related to data management.

Create and modify existing databases and database objects according to needs of the organization. Perform thorough testing on all database objects and data queries to ensure results meet designed specification.

Support all assigned BIDHC reporting needs by producing daily, weekly and monthly reporting deliverables.

Develop and maintain Business Intelligence reports utilizing Tableau, Axiom and other solutions adopted by BIDHC.

Develop Tableau visualizations and dashboards using Tableau Desktop. Develop Tableau workbooks from multiple data sources using Data Blending.

Provides business and technical analysis, development and project management expertise for business and technology initiatives, while focusing on data warehouse and business intelligence solutions.

Supports Business Intelligence Manager and Director, Strategic Analytics with reporting requests, presentations, database development and other assigned responsibilities.

Required Qualifications:

Bachelor's degree required.

1-3 years related work experience required.

1 year of SQL Server Integration Services (SSIS), writing T-SQL codes, and stored procedure experience.

Experience using SQL Server Management Studio (SSMS) and Visual Studio as well as experience with data marts and data warehouse design and development.

Willingness to develop new technical skills and learn new technologies.

Advanced technical computer skills as required for technical support specific to functional area and related systems.

Preferred Qualifications:

Preferred experience creating reports in Tableau.

Competencies:

Decision Making: Ability to make decisions that are guided by precedents, policies and objectives. Regularly makes decisions and recommendations on issues affecting a department or functional area.

Problem Solving: Ability to address problems that are highly varied, complex and often non-recurring, requiring staff input, innovative, creative, and Lean diagnostic techniques to resolve issues.

Independence of Action: Ability to set goals and determines how to accomplish defined results with some guidelines. Manager/Director provides broad guidance and overall direction.

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.

Team Work: 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 and staff training to meet customer service standards and expectations for the assigned unit(s). Resolves service issues in the assigned unit(s) in a timely and respectful manner.

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

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. Learn more about this requirement.

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