BI Analyst (SQL)_Rosemead, CA

Currently I have a BI Analyst position in Rosemead, CA. This is a direct hire position, with a great benefit package. Please review the job description below and if you find it a good match to your skill set, please send a word copy of your resume with a daytime contact number.

SCOPE of the Position:

Responsibilities:

Ø Work with business users to clarify ETL requirements and business rules
Ø Translate business requirements into potentially complex technical solutions that meet or exceed those business needs
Ø Document all ETL related work per company's methodology
Ø Development of SSAS solutions.
Ø Optimize T-SQL code
Ø Maintain existing code and fix bugs whenever needed
Ø Ensure smooth functioning of our development, QA, staging and production ETL processes
Ø Develop and maintain Business Intelligence applications.
Ø Design, develop, implement and maintain extraction, transformation, and load (ETL) routines for importing data from heterogeneous data sources into the data warehouse.
Ø Design and develop OLAP/Analysis services cubes, SSIS packages, jobs, MDX scripting and OLAP cube performance tuning.
Ø Be able to develop Ad-hoc data requests against Data Warehouse.
Ø May need to perform SQL server database administration: user rights/accounts, performance tuning, database migration and testing.
Ø Participate in Optimizing and improving the performance of existing ETL, data warehouse and Business Intelligence applications.
Ø Ensuring that the development of ETL, Data Warehouse and Business Intelligence solutions follow the establish business process.

Requirements:

Ø Education: Bachelors degree, preferably in Computer Technology

Experience:
Ø 7+ Years SQL Server Developer experience is a MUST
Ø 3+ Years of Data Warehouse, ETL design and architecture experience
Ø Experience with large databases with high transaction volume in a fast-paced, production environment
Ø Experience in developing, tuning, managing, maintaining and administering reports
Ø Real-world experience in implementing large scale databases and data warehouses
Ø Data Mining experience a plus

Skills & Knowledge:
Ø Strong in Microsoft SQL 2005 SSIS, SSAS, SSRS
Ø Superb knowledge of Microsoft SQL Server, RDBMS, and Cube Design
Ø Expert in SQL Coding
Ø Expert in Query Performance Tuning
Ø Excellent problem-solving skills, a self-starting attitude and good communication skills are essential.
Ø Expert in T-SQL language
Ø Strong Data Modeling Experience
Ø Strong Relational and Data Warehouse design and implementation skills, with full understanding of the underlying fundamentals
Ø Abilities: Enthusiastic. Communicate effectively in English, both orally and written. Ability to establish and maintain effective working relationships with other employees and outside contacts and work well in a team environment. Good problem solving skills. Not afraid to contribute.