ETL & Business Intelligence Developer

Location: Woburn, MA
Job ID: 148840-1A
Date Posted: Nov 8, 2018

Job Description

Welcome To

Lahey Health Shared Servicesis a vibrant and growing health care system, recognized as a trailblazer in medicine and a standard bearer in patient experience. It includes an award-winning academic medical center, a superb constellation of community hospitals, home care services, rehabilitation facilities and more.

We are committed to attracting, developing and retaining top talent in a market long recognized and revered as a global leader in health. With a team approach to care, we encourage learning and growth at all levels, and we offer competitive salaries and benefits. We adhere to the principles of a just and fair work environment for all colleagues, where respect is foundational and performance is rewarded.

About the Job

This individual is responsible planning, designing, configuring, developing, testing, deploying and supporting ETL/BI solutions. Develops and uses ETL applications to perform data analysis, create technical designs, develop ETL program and provide applications support.

This individual will also have the role of OBIEE ETL administrator and will be responsible for maintaining the OBIEE system that is used to bring data nightly the PeopleSoft ERP into the OBIEE warehouse and ensures that the ETL process is completed daily; working with stakeholders on enhancement; building and testing integrations between HCM, financial solutions as necessary

Essential Duties & Responsibilities including but not limited to:

  • Participates in requirements definition, solution development and the implementation phases of data warehouse and ETL projects.
  • Creates and maintains ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows).
  • Design data ingestion components and ETL to collect data from various sources
  • Assists in definition of logical and physical data models.
  • Configures and tunes ETL infrastructure to optimize the data warehousing architecture
  • Responsible for the maintaining of a OBIEE data warehouse system.
  • Work with user to design and develop OBIEE reports and dashboards, understanding of the underlying technology including setup, tuning and administration.
  • Build, configure and test integrations between HCM, financial solutions as necessary.
  • Define test scenarios based on requirements; create test scripts to prove each scenario through system and user acceptance testing.
  • Elicit, document and derive requirements from functional users, subject matter experts, system documentation and high-level requirement specifications.
  • Translate customer requirements into a best fit within the application, and develops processes and documentation that support the SDLC.
  • Develop and maintain standard systems requirement documents including but not limited to: business process workflows, functional requirements documents; requirement traceability matrix, and use cases.
  • Support application design, configuration, deployment, and security setup activities as needed.
  • Develops aggregation, monitoring and alerting tools/modules.
  • Require to participate in a rotating on-call schedule supporting 24-hour, 7-day operations.
  • May assume duties of a higher level in preparation for increased responsibilities. Performs other related duties as assigned by the Director or the Manager.

About Us

The Lahey Model of Care—right care, right time, right place—is exactly what patients, providers and payers need and deserve. Identifying and delivering on this convergence of interests has positioned Lahey Health for further growth. Our model ensures care is highly coordinated and locally delivered, with lower costs and exceptional quality.

Lahey Health is a robust, regional system including a teaching hospital, community hospitals, primary care providers, specialists, behavioral and home health services, skilled nursing and rehabilitation facilities, and senior care resources throughout northeastern Massachusetts and southern New Hampshire. The system has a global presence with programs in Canada, Jordan and Bermuda.

Equal Opportunity Employer/Minorities/Females/Disabled/Veterans.