We are currently seeking to fill a Business Intelligence Analyst position for our client in Chicago, IL. We invite you to review the position requirements below and apply today if your skills match our need.



Overview:

As a member of cross-functional project team(s), advises and consults on definition of reporting solution requirements and applicable technologies to ensure overall successful project execution; pays particular attention to BI related issues and acts as an advocate for the BI Department. Position seeks to fully understand client business issues to deliver effective client solutions. Manages and disseminates information for decision support. Consults and advises regarding report data, related technologies and general business operations. Overall OLAP Developer with MSAS skill set. The reporting system utilizes SQL and OLAP cubes (SQL Server 2000, Microsoft Analysis Services, Microsoft Reporting Services, and ProClarity). This role reports to the Director, Business Intelligence.



Responsibilities:

- Create post-collection quality control specifications; programming and executing code on audit data using SQL and DTS.

- Monitor, analyze, and create audit data quality reports using a combination of statistical concepts and SQL/DTS.

- Designs, builds, tests, deploys and maintains relational &multidimensional databases, reports & presentations.

- Assembles and compiles data from various sources.

- Designs, builds, tests, deploys, executes and maintains data extraction, transformation and load (ETL) jobs to populate databases

- Perform quality assurance of report content and reporting/analytic tool operations/functionality to eliminate errors, ensure accuracy

- Trains both internal and external end-users; may include preparation of training documents or classroom materials

- Maintains broad knowledge of current and emerging technologies, trends, issues, techniques and approaches in area of expertise

- Develops or assists with the development and implementation of policies, procedures and standards consistent with those of the organization to ensure efficient and safe operation of the department

- Performs miscellaneous job-related duties as assigned



Qualifications:

- Microsoft SQL Server 2000 (3+ years)

* Relational Database, T-SQL and Stored Procedures

* Analysis Services and MDX

* Data Transformation Services (DTS) and ActiveX Scripting (VBScript)

* Reporting Services

- Excellent debugging and issues resolution skills related to all aspects of a database environment

- Experience managing large volumes of data, extraction of data from SQL Server tables (ETL) and building cubes with many dimensions

- Strong written and verbal communication; ability to explain technical concepts to non-technical audience

- Possesses a passion for solving problems and business issues to drive growth and operational efficiency

- Embraces teamwork & possesses ability to effectively work cross functionally

- Experience in ProClarity is a plus

- Understands data warehousing concepts in order to translate the data via business intelligence into the proper tool

- Experience with summarized data marts and architecture of data warehouses

- Experience managing large volumes of data, extraction of data from SQL Server tables (ETL)

- Report Development and Deployment

- Excellent debugging and issues resolution skills related to all aspects of a database environment

- Experience building large cubes with many dimensions

- Experience with different partition methodologies

- Bachelors Degree in related Information Technology field

- 3 years experience directly related to the position requirements as specified



Apply now if your skills and experience are a good match for the position and remember this: At Harvey Nash, the door to opportunity is always wide open.

To Apply to this job go to http://www.GadBall.com or click here