Application Specialist Level 2-Business Intelligence

SA TECHNOLOGIES; Montreal (administrative region); On-site; CAD 90,000 - 120,000; Full time

Job summary

SA Technologies Inc. in Montreal, QC is seeking an Application Specialist Level 2 to develop, implement, and support OBIEE-based BI solutions across the enterprise.

You will apply Oracle database knowledge, ODI/ETL design, and data modeling to deliver robust data warehousing and reporting capabilities for business users. Reporting to the APM Business Intelligence team, you will collaborate with BI developers, operations, and end users, ensure adherence to change control, and support production

Qualifications

• 5–9 years in Information Technology
• Retail industry experience is a plus
• Bilingual: English and French
• Solid OBIEE 11g and data warehouse implementation experience
• Solid ODI 11g knowledge
• OBIEE/ODI architecture knowledge
• OBIEE RPD design and reports design
• BI Publisher knowledge
• PL/SQL and SQL proficiency
• Experience in data warehousing design and ETL development with ODI
• Unix/Linux scripting knowledge
• WebLogic administration knowledge
• Oracle OLAP knowledge a plus
• SSIS knowledge an asset
• Strong BI/DW technical skillset; OBIEE, Oracle DB, data modeling, ETL, ODI, performance tuning
• Ability to work independently and communicate with business users in business terms
• Team member of Applications management

Responsibilities

• Design, test, implement, and support OBIEE platform components
• Follow change control processes
• Collaborate to understand data schema and reuse queries for business users
• Work in a team and build new BI solutions
• Contribute on processes needing SSIS ETL knowledge
• Support end users in production and ETL batches
• Take directions from senior Application Management members

Skills

OBIEE

ODI

ETL design

Data warehousing

SQL

PL/SQL

Unix/Linux scripting

WebLogic administration

Communication with business users

Bilingual English/French

Tools

OBIEE tools

ODI Studio

BI Publisher

SSIS

Oracle Database

RPD design

WebLogic

Oracle OLAP

Job description

Company Description

SA Technologies Inc. (www.satincorp.com) is a market leader and one of the fastest growing IT consulting firms with operations in US, Canada, Mexico & India. SAT is an Oracle Gold Partner, SAP Services Partner & IBM Certified enterprise.

All SA Technologies requirements are Direct Client Requirements from IT Hiring Managers. We guarantee you the best rate for your skills and performance.

Job Description

Duration: Full time

Location: Montreal, QC

Reporting to the APM Business Intelligence, the Application specialist Level 2 will develop, implement, support, document, and provide analytical services for the Oracle Business Intelligence Enterprise Edition (OBIEE) platform. The candidate applies knowledge of the Oracle database, OBIEE tools, dimensional data modeling, data warehouse design, ETL design and development using ODI, Metadata Repository(RPD) design and development, Oracle Database Tools coupled with strong analytical skills, sound development methodologies and business intelligence / data warehouse best practices to develop and support Business Intelligence solutions geared towards all departments of Groupe Dynamite.

Key Responsibilities

• Designs software, tests, implements, and supports all aspects of the OBIEE platform (databases, data models, data warehouse design, ETL processes using ODI, Repository (RPD) design, OBIEE reporting and dash-boarding tools, performance tuning, server processes, etc.).
• Work within prescribed change control processes and procedures.
• Collaborate with all Application Portfolio groups to understand the data schema and leverage existing queries and extracts into information tools for the business users using the OBIEE platform.
• Work in a team environment, and collaborate with other Business Intelligence/ Data Warehouse and other developers to understand current applications and build new solutions.
• Contribute and collaborate on processes requiring Microsoft SSIS ETL knowledge.
• Provide support to end users in the production environment and availability on a rotation to support ETL batches and OBIEE Service Level Agreements.
• Takes directions from and works with senior members of the Application Management team on projects and tasks.

Qualifications And Competencies

• At least five years, less than ten years in Information Technology
• Retail Industry Experience an asset
• Bilingual: English and French
• Solid knowledge in OBIEE 11g and data warehouse implementation projects.
• Solid knowledge in ODI 11g
• Solid knowledge on OBIEE, ODI architecture
• Solid knowledge of OBIEE RPD design and reports design and good knowledge of ODI
• Solid knowledge of BI Publisher
• Solid knowledge of PL/SQL and SQL
• Extensive experience in gathering requirements, designing & developing OBIEE & ODI
• Extensive experience in data modeling in data warehousing
• Solid knowledge of performance tuning in OBIEE 11g
• Solid knowledge in Unix/Linux scripting
• Solid knowledge of Weblogic administration
• Knowledge of Oracle OLAP/Cube an asset
• Knowledge of SSIS an asset
• Strong technical data warehousing/business intelligence skillset; Oracle Business Intelligence Enterprise Edition(OBIEE ), Oracle database, PL/SQL, data warehouse database design, data modeling, ETL process design and development, ODI, performance tuning
• Ability to work independently; strong motivation and initiative to identify and do what needs to be done
• Ability to effectively communicate with and educate business users about data warehousing/business intelligence technology in business terms
• Ability to work effectively as a member of the Applications management team.

Additional Information

408-598-3037*120