Senior Software Engineer at United States Pharmacopeia

Description

Who is USP?

The U.S. Pharmacopeial Convention (USP) is an independent scientific organization that collaborates with the world's top authorities in health and science to develop quality standards for medicines, dietary supplements, and food ingredients. USP's fundamental belief that Equity = Excellence manifests in our

core value of Passion for Quality through our more than 1,300 hard-working professionals across twenty global locations to deliver the mission to strengthen the supply of safe, quality medicines and supplements worldwide.

At USP, we value inclusivity for all. We recognize the importance of building an organizational culture with meaningful opportunities for mentorship and professional growth. From the standards we create, the partnerships we build, and the conversations we foster, we affirm the value of Diversity, Equity,

Inclusion, and Belonging in building a world where everyone can be confident of quality in health and healthcare.

USP is proud to be an equal employment opportunity employer (EEOE) and affirmative action employer. We are committed to creating an inclusive environment in all aspects of our workan environment where every employee feels fully empowered and valued irrespective of, but not limited to, race, ethnicity, physical and mental abilities, education, religion, gender identity, and expression, life experience, sexual orientation, country of origin, regional differences, work experience, and family status. We are committed to working with and providing reasonable accommodation to individuals with disabilities.

Brief Job Overview

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.

How will YOU create impact here at USP?

In this role at USP, you contribute to USP's public health mission of increasing equitable access to high quality, safe medicine and improving global health through public standards and related programs. In addition, as part of our commitment to our employees, Global, People, and Culture, in partnership with the Equity Office, regularly invests in the professional development of all people managers. This includes training in inclusive management styles and other competencies necessary to ensure engaged and productive work environments.

The Senior Software Engineer has the following responsibilities:

Responsible for evaluating user needs, gathering requirements and specifications from business stakeholders.

Designs, codes, verifies, tests, documents, amends, and refactors substantially complex programs/scripts and application integrations as technical lead.

Creates, develops, modifies, writes programs and tests code thoroughly prior to deployment from lower to higher environments.

Investigates escalated, non-routine and high-impact incidents to responsible service owners and seeks resolution.

Leads assessment, analysis, planning and design of release packages, including assessment of risk.

Leads and implements enhancements by recommending best practices and providing technical support

Liaises with business and technology teams on release scheduling and communication of progress. Ensures release processes and procedures are applied and releases can be rolled back as needed.

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 modeling 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.

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.

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.

Who is USP Looking For?

The successful candidate will have a demonstrated understanding of our mission, commitment to excellence through inclusive and equitable behaviors and practices, ability to quickly build credibility with stakeholders, along with the following competencies and experience:

Bachelors degree in computer science or relevant field.

Overall, 8 years of experience in data warehouse and OBIEE, with focus on ETL/ODI.

Minimum 6 years of experience in end-to-end deployments of OBIEE.

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.

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 mapping.

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

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

Additional Desired Preferences

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

None.

Benefits

USP provides the benefits to protect yourself and your family today and tomorrow. From company-paid time off and comprehensive healthcare options to retirement savings, you can have peace of mind that your personal and financial well-being is protected.

Note: 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

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR 60-1.35(c)

Job Category Information Technology

Job Type Full-Time