Email me newest jobs similar to this one
16 days ago
only 12 days until close

Sr. Developer (Business Intelligence) - 5092


AAR Airlift Group
Location: Illinois
Job type: Contract/Locum
Contact: No Name
Category: Developer
Apply
Select how you want to share:
View similar

 

Description
 

The Senior BI Developer will ensure that the AAR OBIEE business intelligence tool is maintained and updated properly and in a timely manner. They will also ensure that the OBIEE dashboards and reports are representative of the company information  and easily navigated by customers.

 

ESSENTIAL DUTIES AND RESPONSIBILITIES:

 

Support of Data Warehouse/BI

  • Solution architect with extensive experience designing/building warehouse solutions in Oracle.
  • Expert OBIEE/Informatica in design/architect/implementation of various data warehouse and BI solutions using OBIEE 11 or higher/ BI Analytics 7 or higher / Informatica 8 or higher environments.
  • In-depth knowledge and experience in OBIEE RPD modeling/implementing complex OBIEE security model/expert in manipulating OBIEE RPD system/ session variables for RPD/Dashboard Answers solutions.
  • Implemented OBI with BI Server CLUSTER and High Availability Presentation services.
  • Expert OBIEE Administration - cache management, catalog migration and security setup - knowledgable in options like LDAP, SSO and external security table integration.
  • Experience setup/configuration/troubleshooting OBIEE (Schedule/Delivers).
  • Delivering reporting solutions based on OBIEE - Dashboard/Answers/RPD, BI Publisher, Hyperion Dashboard
  • Involved in all phases of SDLC functional requirement gathering, proof of concept, gap analysis, Design, Development, Testing and implementation of OBIEE/BI Analytics projects.
  • Architect solutions for performance related issues by tuning OBIEE requests/Dashboards using BI caching methods, aggregated navigation, partioning the warehouse tables, and materialized views.
  • SQL tuning and BI clustering solutions.
  • Experience as design/architect/development ETL solutions with SQL/Informatica/Jitterbit/Mulesoft/OWB integrations.
  • Expert in logical/physical design, snowflake schema, slowly changing dimensions for warehouse implementations.
  • Combine excellent written and verbal communications skills with in-depth, experience leading onshore/offshore development team for implementation projects.
  • Experienced as a lead of all aspects of the delivery of Distribution Sector BI solutions & related components: data warehousing, data management, BI architectures and tools, interfaces and conversions.
  • Interact with the other divisions of the company for their BI based application requirements.
  • All other duties as assigned.

 

CORE COMPETENCIES

 

Commitment to company values and ethics

Dependability: personally responsible, completes work in a timely manner, and performs tasks accurately

Motivation: must maintain a positive attitude and strong work energy Communication: excellent interpersonal and oral and written communication skills Organization: very detail oriented and always comes prepared

Initiative: plans work and carries out tasks without detailed instructions, prepares for problems or opportunities in advance, undertakes additional responsibilities Creativity: makes constructive suggestions and creates novel solutions to problems; evaluates new technology as potential solutions to existing problems

 

Qualifications
 

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

 

Knowledge and training of the following:

  • OBIEE Design/Architect/Administration 11+
  • Oracle Applications BI Analytics
  • Fast tracking in Business System Analyst
  • Oracle Warehouse Builder (OWB)/Business Intelligence
  • Hyperion BI 9.0
  • Some database like Access 

EDUCATION and/or EXPERIENCE

 

Bachelor of Arts degree (B.A.) or Bachelor of Science degree (B.S.) from four-year college or university; or eight years related experience and/or training; or equivalent combination of education and experience.

 

Oracle BI Certified Professional preferred.

Hyperion Certified BI Professional preferred.

Languages: PL/SQL, SQL, C/C++, PRO*C, 4GL, UNIX SHELLS,CRONTAB, ODBS, XML, JAVA, VISUAL BASIC, HTML & XML

 

PHYSICAL DEMANDS/WORK ENVIRONMENT

 

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee may be regularly required to sit, stand, bend, reach and move about the facility. The environmental characteristic for this position is an office setting. Candidates should be able to adapt to a traditional business environment.

Job

: Technical

Primary Location

: United States-Illinois-Wood Dale

Schedule

: Full-time

Overtime Status

: Exempt
Equal Opportunity Employer Minority/Female/Disability/Veteran

 

Description
 

The Senior BI Developer will ensure that the AAR OBIEE business intelligence tool is maintained and updated properly and in a timely manner. They will also ensure that the OBIEE dashboards and reports are representative of the company information  and easily navigated by customers.

 

ESSENTIAL DUTIES AND RESPONSIBILITIES:

 

Support of Data Warehouse/BI

  • Solution architect with extensive experience designing/building warehouse solutions in Oracle.
  • Expert OBIEE/Informatica in design/architect/implementation of various data warehouse and BI solutions using OBIEE 11 or higher/ BI Analytics 7 or higher / Informatica 8 or higher environments.
  • In-depth knowledge and experience in OBIEE RPD modeling/implementing complex OBIEE security model/expert in manipulating OBIEE RPD system/ session variables for RPD/Dashboard Answers solutions.
  • Implemented OBI with BI Server CLUSTER and High Availability Presentation services.
  • Expert OBIEE Administration - cache management, catalog migration and security setup - knowledgable in options like LDAP, SSO and external security table integration.
  • Experience setup/configuration/troubleshooting OBIEE (Schedule/Delivers).
  • Delivering reporting solutions based on OBIEE - Dashboard/Answers/RPD, BI Publisher, Hyperion Dashboard
  • Involved in all phases of SDLC functional requirement gathering, proof of concept, gap analysis, Design, Development, Testing and implementation of OBIEE/BI Analytics projects.
  • Architect solutions for performance related issues by tuning OBIEE requests/Dashboards using BI caching methods, aggregated navigation, partioning the warehouse tables, and materialized views.
  • SQL tuning and BI clustering solutions.
  • Experience as design/architect/development ETL solutions with SQL/Informatica/Jitterbit/Mulesoft/OWB integrations.
  • Expert in logical/physical design, snowflake schema, slowly changing dimensions for warehouse implementations.
  • Combine excellent written and verbal communications skills with in-depth, experience leading onshore/offshore development team for implementation projects.
  • Experienced as a lead of all aspects of the delivery of Distribution Sector BI solutions & related components: data warehousing, data management, BI architectures and tools, interfaces and conversions.
  • Interact with the other divisions of the company for their BI based application requirements.
  • All other duties as assigned.

 

CORE COMPETENCIES

 

Commitment to company values and ethics

Dependability: personally responsible, completes work in a timely manner, and performs tasks accurately

Motivation: must maintain a positive attitude and strong work energy Communication: excellent interpersonal and oral and written communication skills Organization: very detail oriented and always comes prepared

Initiative: plans work and carries out tasks without detailed instructions, prepares for problems or opportunities in advance, undertakes additional responsibilities Creativity: makes constructive suggestions and creates novel solutions to problems; evaluates new technology as potential solutions to existing problems

 

Qualifications
 

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

 

Knowledge and training of the following:

  • OBIEE Design/Architect/Administration 11+
  • Oracle Applications BI Analytics
  • Fast tracking in Business System Analyst
  • Oracle Warehouse Builder (OWB)/Business Intelligence
  • Hyperion BI 9.0
  • Some database like Access 

EDUCATION and/or EXPERIENCE

 

Bachelor of Arts degree (B.A.) or Bachelor of Science degree (B.S.) from four-year college or university; or eight years related experience and/or training; or equivalent combination of education and experience.

 

Oracle BI Certified Professional preferred.

Hyperion Certified BI Professional preferred.

Languages: PL/SQL, SQL, C/C++, PRO*C, 4GL, UNIX SHELLS,CRONTAB, ODBS, XML, JAVA, VISUAL BASIC, HTML & XML

 

PHYSICAL DEMANDS/WORK ENVIRONMENT

 

The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee may be regularly required to sit, stand, bend, reach and move about the facility. The environmental characteristic for this position is an office setting. Candidates should be able to adapt to a traditional business environment.

Job

: Technical

Primary Location

: United States-Illinois-Wood Dale

Schedule

: Full-time

Overtime Status

: Exempt
Equal Opportunity Employer Minority/Female/Disability/Veteran

Email me newest jobs similar to this one

  Back to the top