Data Warehouse Analyst & Developer

  •  

Trenton, NJ

Industry: Business Services

  •  

5 - 7 years

Posted 41 days ago

This job is no longer available.

Our direct client is looking for a Data Warehouse Analyst & Developer with Webfocus, DB2 in Trenton, NJ.

Role 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.

Responsibilities:

- 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

SKILL MATRIX:

- Experience in data warehouse environment facilitating requirements gathering sessions, documenting requirements, analyzing and evaluating – Required

- Experience in WebFocus – Required

- Experience in Tableau - Highly desired

- Experience in DB2 server client skills – Required

- 4 year degree – Required

- Experience with development, implementation, enhancement and support of operational and customer reporting information – Required

- Experience with analyzing raw system data – Required

- Experience with mining large datasets and drawing actionable insights – Required

- Ability to develop records management processes and policies – Required

- Ability to extract data from large, complex data warehouse – Required

- Prepare requirements for new data warehouse tables/structure, including summary information optimized for reporting – Required

- Ability to test new data warehouse content to ensure accuracy – Required

- Ability to support developing and maintaining ongoing customer required reporting in various BI tools (WebFocus/Tableau) – Required

- Proficient in SQL – Required

Question 1) One hour unpaid lunch. Do you accept this requirement?

Question 2) Fingerprinting full state & federal background check to be completed by the state.

Question 3) Travel within NJ is required and not reimbursed. Do you confirm you are fine with it?

Question 4) Client may decide to go for in-person interview. Do you confirm you are fine with it?

Location: Trenton, NJ