Business Intelligence Analyst (Great Neck, NY)

.
Business Intelligence Analyst

• Will be responsible for analysis, design, development, and documentation of Data Warehouse and reporting related projects and software.
• Will implement High-Performance, Scalable Web and Windows Based Applications.
• Will work with customers to analyze requirements needed to support business processes and work with internal team members to deliver solutions in support of our Data Warehouse and Business Intelligence Reporting environment.
• This role requires comprehensive understanding of Microsoft Business Intelligence technologies and the ability to write software design specifications.
• Must have excellent oral and written communications skills and strong customer services skills to support a diverse, international customer base.

Activities Include:
• Requirements Analysis
• Coding Extract, Transform, Load (ETL) packages
• Dimensional Data Modeling and BI Universe/Report development.
• Provide input to BI team and help to achieve goals through the implementation of BI Best Practices.
• ETL Program and Mapping Development (specify, develop, test, deploy) using defined project methodology and internal standards as well as develop data transformation processes, automating load processes and maintain and update cleansing and validation process.

Requirements:
• Must have Strong Dimensional Data Modeling and OLAP Cube Design.
• Must have experience with analytics or quantitative business intelligence/metrics/reporting
• Must have experience with Microsoft SQL Server Reporting Services (Report design with SSRS, development with BIDS and SSIS, deployment)
• Must have experience with Microsoft SQL Server Analysis Services (Cube design, development, and management)
• Must have experience in data warehouse design strategies, knowledge in Data Modeling, Dimensional Modeling, and Data Mining
• Experience using Kimball approach in data warehouse implementation
• Experience using Business Intelligence Development Studio (BIDS) to create shared solutions with Analysis Services and Reporting Services
• Experience in using SQL Server Integration Services (SSIS) for writing Extract, Transform, Load (ETL) integration solutions
• Experience with change data capture capabilities of SQL Server 2008
• Expertise in T-SQL, MDX, DMX
• Experience implementing data mining models using SQL Server Analysis Services
• Experience in Microsoft SQL Server Business Intelligence Product Suite
• Experience in data visualization and data analysis using PowerPivot for Excel
• B.S. Degree in Computer Science
• Must have strong oral and written English communication skills; knowledge of Spanish is a plus.

This is a permanent, full time position. Please do not apply (or refer) unless authorized to work in the US.
All candidates must be either US Citizens or US Permanent Residents

All candidates MUST be local to Great Neck, L.I., NY.
Please do not refer / apply if you are not local, even if you would pay your own relocation.
Relocation is NOT offered.