OBIEE Solutions Architect

Location: Toronto, ca

Company Description

SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

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.