-Review business requirements and current data models to develop a framework for BI reporting / Data Warehouse.
-Responsible for incremental data warehouse design, development, testing, support and configuration.
-Design dimensional data models to create star schemas/data warehousing repositories
-Expert in utilizing Data Warehouse modeling tools in SQL Server envirionment (SSIS, SSAS, SSRS, SQL Server, SharePoint, etc.)
-Develop reporting from multiple internal and external data sources to support
-Work independently and with other developers to implement the logical database design in the physical environment
-Create SSIS/DTS ETL Packages
- 7 plus years experience in data warehousing, datamarts, definitions, OLAP, report writers, data mining tools, Dash Board design, SQL, and layouts, Oracle and SQL Server Databases
- 3 plus years in building reports and dashboards off the data warehouse
- Strong experience with T-SQL, DTS, SSIS, Data Mining, OLAP, SSAS, SSRS, Cubes and MDX
- Strong data modeling skills
- Must have experience working in Agile environment - incremental implementation
- Must be able to work with multiple teams - BAs, SMEs, Infrastructure team, DBA, etc.
Other Technology Requirements:
• Intermeidate experience with Linux, Unix, C#, VB, ASP, and Agile
• Advanced experience with Windows, T-SQL, PL/SQL/Dynamic SQL, and SSAS
Additional Information :
- "All your information will be kept confidential according to EEO guidelines".
- All candidates who are authorized to work in US are encouraged to apply.
- Candidates must clear the Background check prior to commencing the assignment.
THIRD PARTY CANDIDATES:
Email your candidate/s resume to joseph dot shelton at idealforce.com along with the following details: Rate, Current location and Availability.
Disclaimer :
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.