Business Intelligence Developer BI

Halo Group; Elk Grove Village (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading IT talent provider in Elk Grove Village, Illinois is looking for an Oracle BI Specialist. This role is essential for leveraging company data and developing innovative BI solutions. The ideal candidate should possess 4-6 years of BI experience, with skills in SQL querying and OBIEE tools. Excellent communication skills are essential, along with the ability to work independently and collaboratively. This company offers a unique opportunity for growth within a rapidly expanding environment.

Qualifications

• 4-6 years of experience with Business Intelligence concepts.
• Strong background in developing complex SQL queries on Oracle database.
• Good understanding of Dimensional Data Models.

Responsibilities

• Enable the Business to leverage data assets for better decision making.
• Develop and support innovative BI solutions.
• Work closely with business users to refine BI requirements.

Skills

Oracle BI Publisher

Complex SQL Queries

Oracle BI Analyses

Dimensional Data Models

Oracle Database

OBIEE 11g

Job description

Halo Group is a premier provider of IT talent. We place technology experts within the teams of the world’s leading companiesandhelp clients build innovative businesses that keep them one step closer to their customers and one step ahead of the competition.

Job Description

The Oracle BI Specialist will be an integral part of a team enabling the Business to make better decisions by leveraging the company’s data assets by applying knowledge of Oracle Business Intelligence tools, principles of dimensional data modeling and data warehouse design to develop and support innovative BI solutions geared towards Operations, Sales, Supply Chain Management and other business areas. The solutions designed and deployed by the BI Specialist will directly impact the day to day work activities of the company’s business users and have a huge impact on the operational efficiencies in various departments and thus directly impact the company’s bottom line.

The candidate will have 4-6 years of experience with Business Intelligence concepts, working with Oracle database with a strong background in developing complex SQL queries as well as various components of OBIEE like BI Publisher, RPD Development, Analyses and Dashboards. The BI Specialist is expected to have a good understanding of Dimensional Data Models and any Oracle Data Integrator and Oracle Golden Gate knowledge will be a plus. This is a role for someone who is looking to build on his or her initial experience and grow with a stable, but rapidly growing company.

The candidate will have excellent communication skills and can work independently as well as part of a team and work closely with the business users to understand and refine BI requirements which will be translated into meaningful information delivered as ad-hoc queries, BI Publisher Reports or Analyses/Dashboards. Candidate is expected to be a self-starter and can learn existing and new tools and technologies.

Candidate is expected to follow, challenge and improve established processes surrounding design, development, testing and deployment of BI solutions.

Qualifications

• Provide support to business users by answering BI related questions and provide guidance and ad-hoc data as required in a timely manner
• Work with a cross functional team to understand the business issues or identify opportunities and gather BI system requirements
• Translate business requirements into BI Publisher Reports, Analyses and Dashboards
• Apply knowledge of custom database tables to design BI Publisher Data Models by developing simple to complex SQL queries
• Design and develop complex customer facing and internal business documents using RTF templates and Excel Templates in BI Publisher
• Participate in extending, refining and enhancing the company’s data warehouse
• Translate business requirements and knowledge of data warehouse to model the Physical Layer, BMM Layer and Presentation Layers in Oracle BI Administration Tool.
• Follow company’s change control procedures and perform deployment of BI artifacts
• Provide technical assistance and cross training to other team members as required
• Design and implement best practices, guidelines and repeatable processes

Required Skills:

• Report writing tools like Oracle BI Publisher; 4 years with OBIEE 11g or newer
• Develop Complex SQL Queries on Oracle Database; 3 years with Oracle 11g or newer
• Develop Oracle BI Analyses and Dashboard; 3 years with OBIEE 11g or newer
• Develop Oracle BI RPD (Physical, BMM, Presentation Layers; 2 years OBIEE 11g or newer
• Requirements Analysis and Design for Dimensional Data Models for deploying a Data Warehouse

Additional Information

All your information will be kept confidential according to EEO guidelines.