Obiee Developer

US Pharmacopeia Rockville , MD 20850

Posted 2 months ago

OBIEE Developer

Information Technology

Rockville, MD

  • ID:1681-679
  • Full-Time/Regular

Summary of the Position

This is a professional hands-on IT position in which the incumbent will be a technical architect responsible for designing and developing solutions with technical expertise in data warehouse design, ETL (ODI), reporting and analytics. The incumbent designs and develops enterprise data warehouse (EDW), ETL and business intelligence systems on OBIEE and Tableau. This position will provide guidance and technical oversight an offshore BI development team to support the ongoing operation and enhancements of EDW, ETL and OBIEE systems.

Roles and Responsibilities

  • Responsible for gathering requirements and specifications from business stakeholders.

  • Provide expertise in performing application development, configuration and unit testing of data integration (using ODI, PL/SQL, SQL), and Oracle Business Intelligence (OBIEE) applications.

  • Collaborate with development team to design and implement data extraction programs that integrate seamlessly into BI solutions to meet the needs of the end users

  • Proficient with data modelling tools to create Entity Relationship Diagrams (ERD) for new and existing models

  • Experience with transforming logical business requirements into appropriate schemas and models

  • Create both logical and physical data models, with emphasis on data preparation, data profiling, data cleansing, and data auditing

  • Responsible for working with the offshore BI team members and business stakeholders to deliver reporting and analytics solutions within the data warehouse and OBIEE.

  • Responsible for analysis, design, development, customizations, validations, deployment and post-implementation support for OBIEE components including Oracle BI Admin, interactive dashboards, BI Publisher, scheduler, and interactive reporting using OBIEE 12c

  • Work closely with business stakeholders, developers(offshore) and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases.

  • Responsible to create, maintain and enhance Business Intelligence components (metadata, reports, metrics, dashboards) and manage the overall BI ecosystem by resolving defects in timely manner.

  • Responsible for troubleshooting, debugging, optimizing and performance tuning of Oracle BI reports.

  • Responsible for developing re-usable OBIEE frameworks such as logical layers and metadata mappings

  • Lead BI application change control management by performing impact analysis to drive changes

  • Responsible for performing analysis, design, development, testing and performance improvements of complex queries based upon the specific needs of USP

  • Coordinate work efforts with the DBA team for application changes and system performance issues

  • Collaborate on testing OBIEE functionality for deployment of upgrades to keep application release level current

  • Pursue innovative ways to improve the process of delivering solutions to OBIEE users

  • Proactively work through service requests with Oracle support as needed.

  • Nurture and enforce best practices for development activities within assigned staff

  • Perform other related duties as assigned

Basic Qualifications

  • Developer III
  • Bachelor's degree in computer science or relevant field

  • Minimum 6 years of experience in data warehouse and OBIEE, with focus on ETL/ODI) and BI tools like OBIEE

  • Minimum 2 years of experience in end-to-end deployments of OBIEE

Professional Skills Requirements:

  • Demonstrated involvement in end-to-end deployments of two (2) of the following: OBIEE Administration, OBIEE repositories, Oracle BI applications, data warehousing in an Oracle environment

  • SQL proficiency with experience in constructing/deconstructing complex reports and queries

  • Data modeling experience using dimensional data modeling, star/snowflake schema, fact and dimension tables, physical and logical data modeling

  • Knowledge in building metadata repository, designing business and presentation layers, creating interactive dashboards and reports using OBIEE

  • Ability to solve complex issues using methodical troubleshooting based on expert knowledge of Oracle OBIEE application functionality and technology

  • Ability to coordinate, lead and support offshore development activities beyond the regular working hours.

Preferred Qualifications

  • Experience in Hyperion Planning and budgeting (PBCS), Enterprise Analytics (ASO), or financial reporting is a plus

  • Understanding of Oracle EBS from a functional user perspective is a plus

  • Excellent verbal and written communication skills.

  • Skilled problem-solver and detail oriented. Ability to identify technical risks, present solutions to non-technical personnel and influence technical decisions.

  • Has ability to influence without direct authority. Ability to interact successfully with all levels of the organization. Ability to manage conflicts, confrontations, and disagreements in a positive manner.

  • Requires ability to work on assigned tasks independently with limited direction

  • Takes accountability for projects and deliverables and escalates appropriately and in a timely manner as needed

  • Takes personal responsibility for the quality and timeliness of work and achieves results with minimal oversight.

  • Must be a team player and work well in a deadline-driven environment with multiple priorities.

  • Ability to manage multiple projects, take direction, and produce defined results.

  • Good understanding of Master Data Management (MDM) concepts

Supervisory Responsibilities


USP offers an impressive benefits package , including:

  • Generous paid time off
  • 14 paid holidays, 10 sick days and 15 vacation days per year to start
  • An annual 401(k) contribution, beginning after 1 year of service, of 10% of pay (base and bonus) every pay period that vests immediately

  • Comprehensive individual and family healthcare plans with affordable premiums and low annual deductibles ($250/individual or $500/family)

The U.S. Pharmacopeial Convention (USP) is a scientific nonprofit organization that sets standards for the identity, strength, quality, and purity of medicines, food ingredients, and dietary supplements manufactured, distributed and consumed worldwide. USP's drug standards are enforceable in the United States by the Food and Drug Administration, and these standards are used in more than 140 countries.

Being a part of USP means belonging to a diverse culture made up of more than 1,000 talented professionals working together at five international locations. We share our expertise in science, IT, human resources, quality assurance, communications, administrative management, and more...all to support an overall mission dedicated to making a difference by providing standards and programs that help improve the quality of medicines, dietary supplements, and foods worldwide.

USP is proud to be an equal employment opportunity employer (EEOE) and affirmative action employer. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color, veteran status, sexual orientation, gender identity or any other protected class. We are committed to working with and providing reasonable accommodation to individuals with disabilities.

USP does not accept unsolicited resumes from 3rd party recruitment agencies and is not responsible for fees from recruiters or other agencies except under specific written agreement with USP.

Job Category Information Technology

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
Drupal Developer

Walter R. Mcdonald And Associates, Inc.

Posted 3 days ago

VIEW JOBS 6/2/2020 12:00:00 AM 2020-08-31T00:00 Overview Walter R. McDonald & Associates (WRMA), a woman-owned small business, has executed hundreds of customized social services projects for federal, state, and local governments, as well as for the private and non-profit sectors, and international corporations. Our company has 40 years of experience and expertise in research, evaluation, performance measurement and monitoring, and data and IT analytic services. We currently have 100 employees distributed across our two main locations in Arlington, Virginia and Rockville, Maryland. Our primary mission is to support system-wide improvements in the delivery of programs social services programs for children and families, communities, and at-risk populations. With our team of top research social scientists, we are committed to the delivery of quality, evidence-based deliverables for our clients. We are currently seeking a senior technical/management professional. Seeking a professional and highly motivated Drupal Developer to join our team and support federal, state, and local healthcare and human services projects. The Drupal Developer will help build and maintain cloud-based Drupal sites to be used internally within the company and externally by federal and state clients. These sites support dissemination of critical information to audiences including the general public. Responsibilities DUTIES: * Build, modify, enhance, and maintain websites built on the Drupal 7 or later framework. * Code, debug, test, demonstrate and implement all facets of the application. * Perform system updates and address bug fixes and assist with routine maintenance of websites * Participate in a variety of website development processes: analysis, planning, testing, development, maintenance. * Provide technical support to project staff and customers to maintain information on websites ABILITIES: * Hands-on experience in developing Drupal solutions to support information architecture and display data * Strong knowledge of database design concepts * Code and debug in PHP, HTML, CSS and JavaScript/jQuery * Experience working in an iterative development environment (Agile, SCRUM) * Develop wireframes and mockups for user interface and user interface design * Understand business context and provide feature recommendations * Work as part of a team to participate in the full application lifecycle, from design through testing and support * Prioritize multiple tasks to meet aggressive deadlines * Participate in meetings with clients and assess verbal and written requirements and transform them into working products. * Ability to dive into code and understand how it all works without handholding. * Enhance skill sets and learn new technologies PHYSICAL REQUIREMENTS: * Work in enclosed office with controlled temperature climates * Long periods of sitting * Long periods of computer use * Lifting up to 25 pounds * Long periods of focus and detail orientation TRAVEL: Occasional travel may be required PROMOTION POTENTIAL: Senior Developer Qualifications EDUCATION/EXPERIENCE: * Bachelor's degree in Computer Science or equivalent field is required * Minimum of three (4) years of experience with Drupal Content Management System and other web technology building multiple modules and leveraging existing modules * Full deployment experience: Installation, Configuration, and Production * Experience with implementing Web sites in HTML, CSS, JavaScript, and jQuery * Experience with the migration of existing CMS content into #JT Walter R. Mcdonald And Associates, Inc. Rockville MD

Obiee Developer

US Pharmacopeia