Sr. Data Analyst

Location: Chicago, IL, us

Company Description

bluestone Executive Search specializes in aligning top companies across vast industries with superior, high-level IT professionals 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

High level job description

• 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, including technologies such as Business Objects XI and Informatica, and concepts such as dashboards.

• 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.

• 5+ years’ experience in BI data analysis supporting BI solutions. 

  Data Analyst details

• 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 Technical , Business and Functional Requirements

• Able to document mapping on ETL and Database tables and schema .

• Able to provide test cases for testing purposes on BI

• Able to create end user documentation .

• Collaborate with customers and technical colleagues to define the project requirements, business process, work-flow, and data flow on business projects and ad-hoc application support

   

Additional Information