Go Back
Sr. Data Warehouse Analyst/ Specialist Location: Parsippany, NJ
Job Title: Sr. Data Warehouse Analyst/ SpecialistLocation:
- Parsippany, NJDuration: 6+monthsJob Description:The top requirements in this role are: (must)1) ETL - working with many packages2) Designing and developing/building data marts/data warehouses3) SSIS;4) T-SQL;5) Data Modeling.SSAS and MDX Development experience is preferred.Heathcare/insurance domain experienceRequirements:
- 3-7 years of related Data Warehouse experience.MUST have heavy ETL and SSIS experience to design and develop MARTs and/or Data Warehouses.
- Experience with ETL programming and customer support, database data matching, cleaning and load operations, and/ or database analysis and reporting.
- Expert in load design strategies and ETL optimization techniques.
- 3+ years of experience in design, development, and implementation of complex SSIS packages on Microsoft SQL Server 2005 or higher in data warehouse / data mart environments.
- Strong Transact-SQL ( T-SQL ) query and stored procedure development.
- Data modeling experience using Erwin or Power Designer.
- SQL Server Analysis Services ( multi-dimensional cube ) and MDX development experience is preferred.
- Excellent organizational, analytical, research, problem-solving, detail-oriented, multi-tasking, decision-making, negotiating, written/verbal communication, interpersonal, and teamwork skills.
- Bachelors Degree in Computer Science, Information Technology or related field.
- Health Care, Insurance or other relevant industry experience is preferred.
- Pluses: Visual Basic / MS .Net technology, Web Services, HP Quality Center Suite, Software AGs WebMethods, SAPs Business Objects / Crystal Reports, SAS, Oracle and/or ASGs Zena products-
Key Skills: