Search Our Jobs
ETL & Business Intelligence DeveloperJob ID 148839 Date posted 06/23/2018
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:
1. Participates in requirements definition, solution development and the implementation phases of data warehouse and ETL projects
2. Creates and maintains ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows)
3. Design data ingestion components and ETL to collect data from various sources
4. Assists in definition of logical and physical data models
5. Configures and tunes ETL infrastructure to optimize the data warehousing architecture
6. Responsible for the maintaining of a OBIEE data warehouse system
7. Work with user to design and develop OBIEE reports and dashboards, understanding of the underlying technology including setup, tuning and administration
8. Build, configure and test integrations between HCM, financial solutions as necessary
9. Define test scenarios based on requirements; create test scripts to prove each scenario through system and user acceptance testing.
10. Elicit, document and derive requirements from functional users, subject matter experts, system documentation and high-level requirement specifications
11. Translate customer requirements into a best fit within the application, and develops processes and documentation that support the SDLC
12. Develop and maintain standard systems requirement documents including but not limited to: business process workflows, functional requirements documents; requirement traceability matrix, and use cases.
13. Support application design, configuration, deployment, and security setup activities as needed
14. Develops aggregation, monitoring and alerting tools/modules
15. Require to participate in a rotating on-call schedule supporting 24-hour, 7-day operations.
16. May assume duties of a higher level in preparation for increased responsibilities. Performs other related duties as assigned by the Director or the Manager.
Education: Bachelor degree in computer science
Licensure, Certification & Registration: None required
Minimum 5 years experience relevant Oracle Technology experience - OBIEE, OBIA, DAC, BI Publisher, ODI, ETL. Experience in the following areas: data base performance monitoring and tuning; database error analysis, troubleshooting and problem resolution; Experience with SQL*net or ODBC connectivity; physical and logical database design; Experience with REST and other APIs, Saas, Paas, and ETL like Oracle ODI, SQL Server Integration Services (SSIS) and Talend. Experience with ETL tools with multiple databases systems (SQL Server, Oracle, Cloud database). Experience with SaaS based products and technologies (SOAP, REST, XML, WSDL, XSD, JSON).
Skills, Knowledge & Abilities: Advanced knowledge of SQL and Unix database environments operating in a multi-platform, multi-vendor environment. knowledge of DBMS concepts and support methodologies, including debugging and trouble-shooting techniques. Knowledge of script language, and use of APIs desired.. Proficiency in SQL and use of interactive editing tools required. Must be detail-oriented, have a professional demeanor, proven analysis and problem-solving abilities, excellent interpersonal and writing skills, on-call experience, and the ability to work with those having wide-ranging levels of expertise.
About Lahey Health
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.
How To Apply
Please apply directly online at http://www.laheyhealth.org/engage-with-us/careers. Use the Job ID number to quickly locate the appropriate job listing. Once you have located the desired job, click on the checkbox in the 'Select' column, and then click the 'Apply Now' button, located at the bottom of the screen. Please note you are only able to select 5 jobs at a time.
Lahey Colleagues please apply directly through Colleague Connection using your Login and Password.