Senior Oracle ETL/BI Developer

Location: Chelmsford, MA

Resuscitation

ZOLL Medical is a growing, innovation-driven company on the forefront of delivering medical devices to save lives, and software solutions to improve efficiency. With customers in more than 140 countries, we continue to expand our reach, as well as our product offerings. Hospitals, emergency medical services (EMS), and others trust us to provide high-quality products and exceptional customer service. ZOLL products are used every day across the globe to save the lives of people who suffer sudden cardiac arrest. From Real CPR Help® technology—an industry first—to the world’s only wearable defibrillator, our capabilities and features set us apart. But none of this would be possible without the motivation and dedication of ZOLL employees, and we’re invested in their success.

We offer competitive salaries and a comprehensive benefits package. Join our team. It’s a great time to be a part of ZOLL!

Job Summary:

The Business Intelligence ETL Developer is responsible for delivering Business Intelligence/Data warehouse projects. Design and Build ETL / ELT solutions utilizing Data Analysis, Dimensional Modeling and ETL Design. Technical skills like Oracle PL/SQL, EBS data models, ETL Development/administration, Tableau development, Data warehouse architecture Integration with Oracle EBS, Sales force, Hyperion Essbase and Oracle Agile. This individual will also play an important role in the design, development, and maintenance of other BI related software and systems, including integrations with databases and Oracle EBS systems, as well as helping to define the overall data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts).

Job Responsibilities:

  • Work independently with users to define BI concepts, information needs and defining functional requirements, specifications and recommendations related to a proposed solution.

  • Lead and perform complex analysis in an evolving data environment.

  • Extract and analyze data, patterns, and related trends as needed, with the subsequent ability to synthesize the data into information consumable by organization.

  • Ensure high levels of Business Intelligence system availability through support functions and in-depth testing.

  • Responsible for the efficient, compliant, timely, secure acquisition, integration, provision, and exchange of the enterprise data.

  • Strong verbal and written communication skills with technical and non-technical audiences.

  • Analyzes and evaluates business requirements by working with business users and management. Provides recommendations on the nature, scope and complexity of solutions

Qualifications:

  • BS degree in Computer Science or related field.

  • 5+ years working in IT with experience in Financials, Sales and Marketing Data Warehouse projects.

  • 5+ years hands-on experience in one of the major ETL/ELT tools like Oracle Data Integrator (ODI)/ Informatica/Talend.

  • 3+ years ETL experience using Oracle EBS modules as Data Source. Extracting data from Finance/SCM modules is required.

  • Must have hands-on expertise in PL/SQL, Stored Procedures, Functions and Packages. Experience with Oracle Databases 11g and 12c is must.

  • Solid understanding of requirements for Data Quality, Metadata, Data Lineage, Operational Data Management and Operational Data Stores.

  • Experience in developing Business Intelligence environment based on OLAP and OTLP frameworks

  • Experience with full Software Development Lifecycle methodologies, expert level of PL/SQL, and working knowledge of ETL and ELT approach, design, and implementation.

Education Requirements:

  • BA in Computer Science with seven plus years of experience

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job.  Duties, responsibilities, and activities will be reviewed periodically as duties and responsibilities change with business necessity.  Essential and marginal job functions are subject to modification.

ZOLL Medical Corporation appreciates and values diversity.  We are an Equal Opportunity Employer M/F/D/V. 

ADA:  The employer will make reasonable accommodations in compliance with the Americans with Disabilities Act of 1990