Current Openings

Data Warehouse Analyst

Trenton, NEW JERSEY | Contract
Post Date: 01/12/21
Job ID: 21-00041
Job Type: Contract

Job Description

 Job title               :  Data Warehouse Analyst
Location               :  Trenton NJ
Type                      :  10 months+
 
Job description :
 
Responsible for eliciting ETL requirements and designing and validating data structures for the data warehouse in support of the analytics needs of the organization. Experience in Requirements Gathering and Documentation, Data Warehouse Design see below.
 
Short Description in full:
Responsible for eliciting ETL requirements and designing and validating data structures for the data warehouse in support of the analytics needs of the organization. Experience in Requirements Gathering and Documentation, Data Warehouse Design Methodologies and conducting data validation is required.  Master Data Management and Data Governance experience is a plus.
 
Complete Description:
  • The ideal candidate will have extensive experience facilitating interviews with Subject Matter Experts for data-related requirements and working with technical teams to ensure system data is made available for analytics.
  • Creates requirements, business rules documents, data mappings, workflows and ER diagrams for data warehouse loading and data transformation processes.
  • Provides requirements, rules, data mappings and diagrams to technical teams, including data warehouse and data integration developers. Provides guidance to the technical teams on building solutions.
  • Proficiency in SQL
  • Strong data analysis skills including the ability to analyze raw system data.
  • Analyzes data integration errors and works with business and technical teams to provide solutions and improve data quality.
  • Works with technical teams to identify data sources to support reports and dashboard development.
  • Validates data warehouse structures and data to ensure accuracy.
  • Ensures data joins and referential integrity are in place in data sets.
  • Ensures reference data is available and accessible for analytics.
  • Identifies work efforts involved inside and outside of the scope of a data-centric project.
  • RELEVANT WORK EXPERIENCE: 5 to 8 years
  • PREFERRED EDUCATION: 4-year college degree or
  • equivalent technical study or advanced degree
 
Required:
  • Experience facilitating interviews with Subject Matter Experts for data-related requirements.
  • Experience creating requirements, business rules documents, data mappings, workflows and ER diagrams for data warehouse loading/data transformation
  • Experience providing requirements, rules, data mapping and diagrams to technical teams.
  • Experience analyzing integration errors and assisting business and technical teams to improve data quality.
  • Proficient in SQL
  • Experience in relational data base management system (DBMS)
  • Experience in DB2 server client skills
  • Experience with designing tables and entity-relationship diagrams for a data warehouse
  • Experience analyzing raw system data
  • Experience validating data warehouse structures and data to ensure accuracy
  • Experience ensuring data joins and referential integrity are in place in data sets
  • Experience ensuring reference data is available and accessible for reporting.
  • Experience with Master Data Management
  • Experience with Data Governance
  • 4 Year College Degree