Share this Job

Go Back

Sr. Data Warehouse Analyst/ Specialist Location: Parsippany, NJ


2015-10-18 16:04:13
Job Type: Contract

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: