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
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.
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
USP offers an impressive benefits package , including:
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