Lead Data Warehouse Developer

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.

The Lead Data Warehouse Developer will report to the BILHPN Director of Health Data Informatics. Responsible for the delivery of enterprise data warehouse, data lake and cloud analytical platform solution.

Job Description:

Essential Duties & Responsibilities including but not limited to:

• Designing enterprise warehouse, cloud data platform and data management initiatives.
• Design and architect enterprise data warehouse following the data-vault and dimensional data modelling methodology.
• Design the architecture to perform data management activities i.e., data extraction, transformation and load (ETL) to enterprise data warehouse.
• Implement the data management solutions using SQL, SQL procedures, Unix, Python, data management tools like Informatica power center SQL on Oracle exadata database.
• Designing, implementing, maintaining and supporting data stores used for reporting and analytics (such as data lake, data warehouse systems and related data marts).
• Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake.
• Develop code using SQL, SQL procedures, UNIX, python, ETL tools like Informatica Power center, AWS services like S3, data pipeline, AWS Glue, Python, AWS Lambda and Athena, Azure services like Data Lake, Data factory and Databricks to Load data into Data warehouse/DataMart/Data Lake.
• Coordinating with peers from other clinical and BILH IT groups to ensure successful design, planning and completion of programs and projects.
• Understand the Upstream and downstream application process as part of requirement gathering working with peers from other clinical and BILH IT groups.
• Understanding business requirements and priorities to shape the scope and requirements of the Data Warehouse solution.
• Gather and understand business requirements and translate business requirements to Functional and technical requirements for data warehouse solution.
• Performing data analysis and data provisioning against source systems.
• Perform analysis against source data by running complex SQLs and develop ETL code for getting more insights on source data as part of requirement gathering.
• Perform data analysis on source data to investigate and resolve production issues reported by end users.
• Designing the processes to acquire and integrate disparate data from multiple sources.
• Design and develop ETL process using SQL and Informatica to load data into data warehouse on daily basis from various source application on SQL Server, Oracle, Cloud Sources and files.
• Design and develop the process in AWS or Microsoft Azure to integrate real-time IOT data and On Premise data into Data Lake/Data Hub.
• Assisting in the data architecture design to be used for Business Intelligence and Analytical purposes.
• Assist downstream users with data warehouse related requirements & architecture Questions and provide SQL’s and develop ETL code to read data from data warehouse for business intelligence and Analytical needs.
• Documenting technical specifications for the design of data integration and data architecture.
• Document functional and technical requirements in technical specification for developing code using SQL, SQL procedure, Unix, Python and ETL tools like Informatica Power center.
• Performing unit testing to assure quality repeatable, quality processes with accurate data results and Installing processes for auditing target data stores and ensuring data quality.
• Providing input and experience on the architecture, design and evolution of BILH Data Hub enterprise warehouse and information delivery solutions, including tool selection, migration strategies, and risk mitigation.

Organizational Requirements:

Maintain strict adherence to the Lahey Health Confidentiality policy. Incorporate Lahey Health Standards of Behavior and Guiding Principles into daily activities. Comply with all Lahey Health Policies. Comply with behavioral expectations of the department and Lahey Health. Maintain courteous and effective interactions with colleagues and patients. Demonstrate an understanding of the job description, performance expectations, and competency assessment. Demonstrate a commitment toward meeting and exceeding the needs of our customers and consistently adheres to Customer Service standards. Participate in departmental and/or interdepartmental quality improvement activities. Participate in and successfully completes Mandatory Education. Perform all other duties as needed or directed to meet the needs of the department.

Minimum Qualifications:

Education: Position requires a Bachelor’s degree (or an equivalent foreign degree) in Computer Science, Electrical Engineering, IT or a closely related field.

Licensure, Certification & Registration:

Experience: Must also have 5 years of experience (which can have been gained concurrently with the other experience requirements) working with Informatica Power Center, SQL Server, SQL and PLSQL, Dimensional and Data Vault Modeling, ETL design, Python and Unix Scripting; and 2 years of experience (which can have been gained concurrently with the other experience requirements) working with AWS services including S3, data pipeline, AWS Glue, AWS Lambda, EMR, Arcadia and EPIC.

Skills, Knowledge & Abilities: AWS Lambda, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Architectural Design, Auditing, Business Intelligence, Cloud Computing, Computer Science, Data Analysis, Data Lake, Data Management, Data Mart, Data Modeling, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, Electrical Engineering, Electronic Medical Records, Functional Requirements Document (FRD), Informatica, Information Technology & Information Systems, Microsoft SQL Server, Microsoft Windows Azure, Migration Strategy, Oracle Database, Oracle PL-SQL, Problem Solving Skills, Process Development, Program Planning, Python Programming/Scripting Language, Requirements Management, Risk Management, SQL (Structured Query Language), Technical Writing, Testing, Unit Test, Unix Operating Systems, Unix Shell Programming, Warehousing.

Key Relationships:

1. BILHPN Leadership: Collaborates with the President, Chief Operating Office, Chief Medical Officer, Vice President IT and Health Data Informatics, and Director, Health Data Informatics to provide in-depth analysis of current data needs and potential process improvements.
2. BILHPN Analysts, Leads, and Clinical Staff: Collaborates with peers from other clinical and BILH IT groups to ensure successful design, planning and completion of programs and projects. Assists in the development of solutions that helps analyze healthcare trends.
3. Data Vendors & Payers: Per direction from the Director, Health Data Informatics communicates with Population Health Analytics Vendors and Payers and maintains the communication record.

Scope/Impact Statement:

Work Schedule: Indicate either Yes or No as appropriate. Hours of work may be subject to change based upon the needs of the business/department.

On Call: Shift Rotation: Weekends:

Physical Requirements & Environment: Required

For each category, select ONE option from choices below by placing an X in the space to the left of the entry.

Mental and Visual Attention Required

a) X The position requires basic mental and visual attention much or all of the time.

Physical Exertion

Weight

d) X Nature of work requires lifting or moving light weight (up to 20 pounds).

Dexterity

g) X Flow of work and character of duties require average manual coordination.

Range of Motion

j) X Duties require average range of motion.

Physical Conditions

m) X Performance of duties allows for variation in positioning and tasks.

Repetitive Motion

o) X Assignments require occasional repetitive motion.

Working Conditions

r) X Working conditions include minimal exposure to elements such as odor, noise, dust, chemicals, temperature extremes or airborne pathogens.

Exposure to Hazardous Materials

u) Performance of duties generally does not involve exposure to hazardous materials.

v) Performance of duties occasionally involves exposure to hazardous materials.

w) Performance of duties frequently involves exposure to hazardous materials.

Patient Care Conditions (select ALL that are applicable)

Patient Care/Patient Contact Designation (check only one of the items listed below)

X_ No patient care/contact, and does not facilitate the patient care process or directly impact health outcomes.

This Job Description is intended to describe the general nature and level of work being performed by people assigned to this classification. It is not intended to be construed as an exhaustive list of all responsibilities, requirements, duties and skills required of personnel so classified. Additional duties and responsibilities that are specific to the Department or Unit are identified and maintained by the Manager as an Addendum to the Job Description.

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) and COVID-19 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