ETL & Business Intelligence Developer

Winchester Hospital Woburn , MA 01801

Posted 7 months ago

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 Careright care, right time, right placeis 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.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Business Analyst


Posted Today

VIEW JOBS 10/14/2019 12:00:00 AM 2020-01-12T00:00 <strong>Senior Business Analyst<br /> Cambridge, MA<br /> Contract to hire</strong><br />  <br /> Lead the implementation of strategic RD projects, working closely with RD leadership to identify key initiatives and provide oversite of these initiatives. Will frequently convey project plans, progress and strategies to departmental managers and other stakeholders across RD.<br />  <br /> Manages projects by effectively building support through discussion and<br /> compromise. Develops long-term project plans with strategic milestones. Negotiates<br /> timelines with both stakeholders and programming services/reporting analytics<br /> managers and others (vendors or consultants) responsible for delivering outcomes.<br /> Also drives vendors to deliver within established milestones and budgets.<br />  <br /> Performs on-going analysis to determine<br /> requirements for the design, development and implementation of information<br /> systems for Resource Development and the Advancement community. Plays a<br /> key role in conducting business and data analysis for these systems and in<br /> implementing new business policies and procedures based upon system use.<br /> Performs application testing, develops end-user training curriculum and<br /> documentation as well as providing high level support.<br />  <br /> <strong>Characteristic Duties </strong><br /> • Working with other RD managers, identifies critical projects, leads and<br /> develops project plan and manages lifecycle of projects from initial<br /> identification of tools and requirements, to managing implementation, to<br /> testing, to user adoption. Includes working across RD with senior stakeholders<br /> to establish priorities, milestones and key deliverables.<br /> • Performs analysis for data and business requirements for the<br /> implementation of new systems, and upgrades, enhancements and<br /> maintenance of existing systems. This includes analysis of data<br /> structures, working with end-users to<br /> determine specifications for reports and system modules, and analysis of<br /> December 2018 <br /> business processes. Develops and documents data and business models, issues<br /> and business requirements and report and system specifications.<br /> • Mentors other analysts on team as well as developers on the RD team.<br /> Frequently reviews work of others and provides feedback on specific tasks<br /> and overall deliverables.<br /> • Designs test plans and performs acceptance testing for his/her projects as<br /> well as overall system upgrades. Documents all test findings and works<br /> closely with application developers and project leads in the resolution of<br /> these issues, reporting issue to the vendor and re-testing revisions.<br /> • Determines end-user requirements for training and develops training<br /> curriculum. Develops format and content for training sessions and prepares<br /> all training materials, both print and electronic. Develops coordinating<br /> documentation, such as user manuals, job aids and screen guides. May<br /> conduct training classes.<br /> • Performs systems analysis of business issues and works together with the<br /> Directors in IT to make recommendations to improve business processes, use<br /> of the system and data integrity. This includes data usage and access<br /> policies, system use and business policies, workflow procedures, and design<br /> of data tables. Also works to uncover and resolve any data inconsistencies or<br /> integrity problems.<br /> • Provides high end-user support in the use of the advancement services<br /> systems and other applications.<br /> • Develops plans and procedures with programming and service desk team to<br /> ensure their preparedness to triage issues for new system functionality.<br /> • Perform other related tasks as assigned.<br />  <br /> <strong>Qualifications</strong><br /> Bachelor's degree required. Requires 7 years of Business Analysis experience with<br /> evidence of successful project management in the implementation of business<br /> applications, business processes, enterprise systems, databases and/or CRMs.  Strong<br /> project management and communication skills. Ability to manage multiple projects<br /> and priorities and meet challenging and changing deadlines. Experience gathering<br /> business or functional requirements collection and analysis required. Ability to present information in a<br /> clear and cohesive manner to a variety of users. Must be a self-motivated team player<br /> with a willingness to collaborate with a variety of staff. High degree of<br /> professionalism, discretion, confidentiality and commitment to quality. Excellent<br /> written and oral communications skills.<br />  <br /> Experience in the use and integration of a wide variety of business systems including<br /> enterprise database, reporting, web, mobile and desktop applications preferred.<br /> Experience in advancement services in higher education or other non-profit<br /> organization is strongly preferred. Experience with Ellucian's Advance very<br /> desirable. Experience in developing technical documentation very desirable.<br /> Knowledge of advanced database concepts, preferably in an Oracle environment<br /> desirable. Knowledge of Crystal Reports or other reporting software desirable.<br />  <br />   Syrinx Woburn MA

ETL & Business Intelligence Developer

Winchester Hospital