Five years of Oracle Business Intelligence Enterprise Edition and/or Siebel Analytics development experience.
Five years of Informatica development experience.
Previous experience implementing Oracle/Siebel customer relationship management solutions, including Sales Force Automation, Call Center, and Marketing.
Strong knowledge of Oracle databases, SQL, and PL/SQL.
Strong knowledge of OBIEE server infrastructure and network architecture.
Ability to provide quality assurance checkpoints related to business intelligence development.
Familiarity with agile development methodologies.
Experience managing multiple pre-production environments, including server maintenance, OBIEE architecture, network infrastructure, and mobile tablet computing platforms.
Ability to work independently and create working prototypes.
Ability to lead and provide technical guidance to global delivery team members.
Responsibilities
Collaborate with product managers, analysts, and business representatives to translate business and integration requirements into scalable designs and solutions.
Design, develop, and test technical solutions based on predefined requirements, including data models, master data management, dashboards, repository files, reports, extract-transform-load jobs, server setup, and proof-of-concepts on technology platforms other than OBIEE.
Enhance performance in the business intelligence environment by tuning code, reviewing tables, and applying indexes where needed.
Continuously improve documentation, version control, testing, and migration standards.
Apply the technical development lifecycle from technical design and unit testing through user testing and production migration, while enforcing standards and controls and conducting quality assurance before migration to production.
Act as the single point of contact for technical matters during the Design, Build, and Deploy phases where required.
Coordinate technical subteams, including offshore, architecture, network, and service groups, to ensure planned activities are completed on time and to the required quality.
Assist with planning design, build, migration, and deployment activities and work with the project manager to track and regularly update progress.
Technically assess change requests and requirements, identifying and fully documenting dependencies, impacts, risks, and issues.
Ensure deliverables conform to company technical standards and policies.
Ensure documentation conforms to program standards.
Identify and report risks and issues to the project manager and assist with their mitigation and resolution.
Ensure requirements are fully traceable from design through build.
Ensure a configuration baseline is established and documented between each release.
Ensure deployment activities are transitioned to the service team with appropriate approved documentation before production release.
Attend project delivery team meetings.
Desired Qualifications
Previous experience in the pharmaceutical industry.
Previous experience working with a global delivery model.
Excellent oral and written communication skills.
Strong conceptual and analytical skills and problem-solving ability.
Ability to manage multiple time-sensitive priorities and complex work in a rapidly changing global environment.
Ability to collaborate effectively with business users, system analysts, project managers, developers, testers, clients, and teammates.
Job Description
Technical Skills
Collaborate proactively with product managers, analysts and business representatives to translate business and integration requirements into scalable designs and solutions.
Design, develop and test technical solutions based on pre-defined requirements. Development responsibilities include Data Models, MDM, Dashboards, RPD, Reports, ETL jobs, Server setup and proof of concepts (POC) on technology platforms other than OBIEE.
Enhance performance in the BI environment. Tuning code, reviewing tables and applying indexes where needed.
Continuously improve documentation, version control, testing, and migration standards.
Strong understanding of the lifecycle of technical development from technical design, unit testing to user testing, to production migration. Emphasize adherence to standards and controls, and conduct quality assurance over programs before migration to production
Contribute to a cooperative environment that fosters knowledge sharing
Ability to lead and provide technical guidance to global delivery team members.
Ability to work independently and create working prototypes
Familiar with agile development methodologies
Flexible to work with a team and clients that span multiple countries and time zones.
Experience with managing multiple pre-production environments including server maintenance, OBIEE architecture, network infrastructure and mobile (tablet) computing platforms.
Soft Skills
Excellent oral and written communication skills
Self-starter with the ability to prioritize and plan complex work for self and a large team in a rapidly changing, global environment
Result oriented – Ability to produce products that demonstrate results
Strong critical thinker with problem solving aptitude and takes initiative
Experienced team player - experience leading and collaborating cross-team to ensure successful delivery of solutions
Strong conceptual and analytical skills - demonstrated outside-the-box problem solving skill
Ability to manage multiple time-sensitive priorities
Ability to get along with various personalities (business users, system analysts, project managers, developers, testers, etc.) is crucial
Excellent follow-through and attention to detail
Self starter that can deal with ambiguity
Actively listens to client and teammates; makes others better
Positive attitude in challenging environments
Driven to produce a quality product; is goal-oriented
Ability to make tough decisions that may not be appreciated by the customer, and communicate same in a way that they can at minimum appreciate and accept rationale.
Ability to probe for enough details to understand and clarify the real business need/value versus the request, and be able to confirm same back with the customer
Project Tasks & Deliverables
Acts as single point of contact for technical related matters for the Design, Build and Deploy phases where required.
Co-ordinates technical sub teams; Offshore and, Architecture, Network and Service groups to ensures all planned activities are completed to time and quality
Assists in the planning of design, build, migration and deployment activities and works with PM to ensure progress are tracked and updated regularly
Ensures all changes requests or requirements are technical assessed, dependencies, impacts, risks and issues are identified and fully documented
Ensures all deliverable produced conform to company technical standards and polices
Ensures all documentation produced conform to programme standards.
Identifies and reports risks and issues to PM and assists in the mitigation and resolution of such risks and issues
Ensures requirements are fully traceable from Design -> Build
Ensures a configuration baseline is established and documented between each release
Ensure deployment activities are transitioned to Service Team, supported by the appropriate approved documentation, prior to production release.
Attends Project Delivery Team meetings
Job Requirements:
5 years of Oracle Business Intelligence Enterprise Edition and/or Siebel Analytics development experience
5 years of Informatica development experience
Previous experience with implementing Oracle/Siebel CRM solutions: (Sales Force Automation, Call Center, Marketing)
Strong knowledge of the Oracle databases, SQL and PL/SQL
Strong knowledge of OBIEE server infrastructure and network architecture.
Provide quality assurance checkpoints related to BI development
Previous experience in the Pharma industry a plus.
Previous experience working with a global delivery model a plus.