Previous Job
NJATCSU Data Warehouse Analyst
Ref No.: 19-13047
Location: Trenton, New Jersey
Job Description
  • Evaluates existing systems and/or user needs to analyze, design, recommend, and implement information system changes. Experience developing and maintaining ongoing customer required reporting in various BI tools (WebFocus/Tableau) is needed.
  • The ideal candidate will have extensive experience in a data warehouse environment facilitating requirements gathering session, documenting requirements, analyzing and evaluating possible solutions to meet requirements and designing tables to be created in a data warehouse.
  • Responsible for the development, implementation, enhancement an support of operational and customer reporting information
  • Proficient in SQL.
  • Analyze raw system data.
  • Mine large datasets and draw actionable insights.
  • Work to align data set attributes/fields across different systems to ensure common connection. points are in place when connecting, and blending data sets.
  • Support developing and maintaining ongoing customer required reporting in various BI tools (WebFocus/Tableau).
  • Support developing and maintaining ongoing customer required reporting in various.
  • Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool.
  • Present discoveries and insights to line of business teams, relating them to specific programs and initiatives.
  • Ability to extract data from a large, complex data warehouse
  • Understanding of statistical principles, and able to apply them in data analytics.
  • Work with technical teams to identify data sources and provide requirements for reporting to support dashboard development.
  • Develop records management processes and policies.
  • Identify areas to increase efficiency and automation of processes.
  • Set up and maintain automated data processes.
  • Identify, evaluate and implement external services and tools to support data validation and cleansing.
  • Document current contents of data warehouse including plain-English descriptions and mapping back to data entry screens.
  • Prepare requirements for new data warehouse table/structure, including summary information optimized for reporting.
  • Test new data warehouse content to ensure accuracy.
  • Develop and support reporting processes.54
Relevant Work Experience
  • 5 to 8 years
  • 4 year college degree or equivalent technical study or advanced degree
Aravind. S| Lead Recruiter
Sunrise Systems Inc.
Transforming Business. Enhancing Careers
105 Fieldcrest Ave Suite# 504, Edison, NJ 08837 USA
Desk (732) 272-0279
Email: | URL:


Sunrise Systems Inc.
Desk: (732) 313 0266
Email: | URL: