Essbase Developer and Administrator

Company: Labcorp
Location: Burlington
Posted on: September 13, 2023

Job Description:

Labcorp is recruiting an Essbase Developer and Administrator for a dynamic team in either the Burlington or RTP, NC area. This will be a Hybrid based position.
Get ready to redefine what's possible and discover your extraordinary potential at Labcorp. Here, you'll have the opportunity to personally advance healthcare and make a difference in peoples' lives with your bold ideas and unique point of view. With the support of exceptional people from across the globe and an energized purpose, you'll be empowered to own your career journey with mentoring, training and personalized development planning.
At Labcorp we believe in the power of science to change lives. We are a leading global life sciences company that delivers answers for crucial health questions because we know that knowledge has the potential to make life better for all. Through our unparalleled diagnostics and drug development capabilities, we provide insights and accelerate discoveries that not only empower patients and providers but help medical, biotech and pharmaceutical companies transform ideas into innovations.
*Overview:*
Primary responsibilities include managing day to day operations and end-user support and supporting project initiatives across the EPM platform.
*Specific Duties and Responsibilities:*

* Act as a key resource in the projects and enhancement of the Oracle EPM system

* Manage operations and end-user support of Hyperion EPM 11.2.5 platform; including maintenance and technical support of Essbase cubes

* Essbase Administration and development, including MDX queries, Smart View Add-in for Essbase

* Modify/tune existing batch scripts; compose SQL queries for DB2 and Oracle relational databases

* Create and maintain Windows server Administration and MaxL Scripts

* Support Oracle EPM system products associated with Essbase; including working with vendor and maintaining Admin Account on Oracle support website

* Participate and complete Deloitte audit request associated with Finance General Ledger cube

* Participate in the Quarterly 302 Certification - IT Logical Access - Essbase

* Manage IBM TWS scheduling setup for batch automation

* Create/update technical documentation

* Stay up-to-date on Oracle EPM product releases and new features, provide recommendations for system improvements, participate in regression testing of Oracle software updates and patches

*Required Education/Skills and Abilities:*

* 3-5 years of software/IT experience.

* Bachelor''s degree in Computer Science or related discipline.

* Experience in multidimensional analysis, designing applications and databases, designing and building dimensions, loading data, calculating data and aggregation techniques.

* Thorough knowledge of end-user tools including Smartview

* Working knowledge of data modeling concepts both relational and dimensional

* Working knowledge in relational database technologies and administration, preferably Oracle and DB2

* Knowledge of Hyperion application architecture and design principles, including infrastructure, table structure, protocols, and delivered objects

* Some exposure/knowledge of installation, configuring and patching Oracle EPM is a plus

* Experience in tuning, and optimization of Essbase cubes

* Experience in working with both Windows and UNIX/Linux based systems

* Experience in developing software applications leveraging Hyperion EPM, including Essbase

* Manage time efficiently with the capacity to handle multiple tasks concurrently under minimal supervision

* Experience with high levels of accountability; demonstrated initiative, innovation and flexibility

* Excellent verbal, written and interpersonal skills

* Strong analytical and problem-solving skills

* Hyperion certification is preferred but not required

*Labcorp is proud to be an Equal Opportunity Employer:*
As an EOE/AA employer, Labcorp strives for diversity and inclusion in the workforce and does not tolerate harassment or discrimination of any kind. We make employment decisions based on the needs of our business and the qualifications of the individual and do not discriminate based upon race, religion, color, national origin, gender (including pregnancy or other medical conditions/needs), family or parental status, marital, civil union or domestic partnership status, sexual orientation, gender identity, gender expression, personal appearance, age, veteran status, disability, genetic information, or any other legally protected characteristic. We encourage all to apply.
For more information about how we collect and store your personal data, please see our -[Privacy Statement](https://www.labcorp.com/hipaa-privacy/web-privacy-policy). -

Keywords: Labcorp, Burlington , Essbase Developer and Administrator, IT / Software / Systems , Burlington, North Carolina