Data Warehouse AnalystResponsible 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.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.Required/desired skills:Experience facilitating interviews with Subject Matter Experts for data-related requirements. - Required - 5 YearsExperience creating requirements, business rules documents, data mappings, workflows and ER diagrams for data warehouse loading/data transformation processes. - Required - 5 YearsExperience providing requirements, rules, data mapping and diagrams to technical teams. - Required - 5 YearsExperience analyzing integration errors and assisting business and technical teams to improve data quality. - Required - 4 YearsProficient in SQL - Required - 5 YearsExperience in relational database management system (DBMS) - Required - 5 YearsExperience in DB2 server client skills - Required - 2 YearsExperience with designing tables and entity-relationship diagrams for a data warehouse - Required - 5 YearsExperience analyzing raw system data - Required - 4 YearsExperience validating data warehouse structures and data to ensure accuracy - Required - 3 YearsExperience ensuring data joins and referential integrity are in place in data sets. - Required - 3 YearsExperience ensuring reference data is available and accessible for reporting. - Required - 2 YearsExperience with Master Data Management - Desired - 2 YearsExperience with Data Governance - Desired - 2 Years4 Year College Degree - Required - 4 YearsWarm regards,Ramakrishna Aripalli!! Talent Acquisition SpecialistSoftware Technology Inc (STI)100 Overlook Center, Suite 200Princeton, NJ 08540Email: no:(609)- Hangouts::krishna.sms86
Data Warehouse Analyst-Trenton, NJ-(Immediate Position) in trenton at Unknown Company
This position is listed as full time and onsite.