Sr. Business Objects Analyst

blueStone; Indianapolis (IN); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading executive search firm is seeking an experienced Sr. Data Warehouse / Business Analyst for a full-time permanent position. The role requires leadership in Business Intelligence, working with vendors to implement BI solutions. Candidates should have at least 5 years of hands-on experience, strong knowledge in data warehousing architectures, SQL, and BI tools. Excellent analytical and communication skills are essential for collaborating with team members and stakeholders.

Qualifications

• Minimum of 5 years hands-on experience implementing BI solutions.
• Extensive experience with Business Objects environment.
• Strong knowledge of star schema and snowflake schema.

Responsibilities

• Define and document key requirements for BI solutions.
• Analyze requirements and design the BI solutions.
• Provide support for all BI applications.

Skills

Business Intelligence solutions

SQL

Data warehousing

Data modeling

ETL design

Communication skills

Analytical skills

Education

4 year bachelor's degree in Information Technology

Tools

Business Objects

Informatica

Oracle

SQL Server

Job description

blueStone Executive Search specializes in technical searches, aligning top IT professionals with superior companies worldwide,

Job Description

We are seeking an experienced Sr. Data Warehouse / Business Analyst on a full-time, permanent basis for our client, a worldwide leader in the technology and media space. The Sr. Data Warehouse /Business Analyst will serve as a leader for Business Intelligence and work with vendors to implement BI solutions to meet their needs. This role is functional and technical with the qualified candidate having an understanding and experience with BI environments such as Business Objects or Informatica; data warehouse architecture and design experience, data modeling as well as a strong understanding of star schema and snowflake schemas; an understanding of normalization and denormalization; dashboards; ETL design; SQL queries; ad hoc reporting and strong analytical and communication skills to work with senior management and vendors.

Qualifications

Requirements

• Work as a business partner to define and document key requirements for BI solutions.
• Analyze requirements, design the solution, develop, implement and support the BI solutions.
• Provide support as needed for all BI applications.

Candidate Profile

• Minimum of 5 years hands on experience implementing BI solutions, from analysis through implementation with Business Objects
• 4 year bachelor’s degree is required, preferably in Information Technology.
• Must have passion to sell BI solutions.
• Very good verbal and written communication skills, including documenting solution requirements and design.
• Must be able to work with the remote based BI team, and offshore development team, staying closely coordinated with them, but not requiring day to day supervision.
• Working knowledge of the design and implementation of dimensional models
• Extensive experience administrating a Business Objects environment, creating and maintaining universes, and complex report development
• Experience with Business Objects Data Services
• Experience with Systems Development Life Cycle (SDLC) and Agile development
• PL/SQL experience against Oracle or SQL Server DBMS
• Data modeler/analyst must have strong knowledge of star schema and snow flake schema
• Data modeler/analyst must have good experience in rational database systems and architecture.
• Data modeler/analyst must have good experience in forms of normalization and transformations of data throughout the forms .
• Data modeler/analyst must have Database table and schema design experience (specially for Oracle)
• Data modeler/analyst must have knowledge of Business Intelligence Process
• SQL Language is a must.
• Gather requirements for data integration, data visualizations, dashboards, and reports.
• Must have experience on SDLC phases .
• Able to document mapping on ETL and Database tables and schema .