Job Title: Data analytics and reporting developer- hybrid
Location:25 Market Street, Trenton, NJ
Interview Type: In Person Only
Description:
The candidate must:-
-Use excellent communication skills, work closely with lines of business, including Research Analysts to address data needs for analytics.
-Be proficient in SQL, App Studio, and WebFocus
-Analyze raw system data.
-Mine large datasets and draw valid inferences and actionable insights using statistical methods.
-Use SQL, App Studio, and WebFocus to extract data from large and complex data warehouses and conduct analysis to ensure the proper data is available to support business needs.
-Be able to link tables together
-Align data attributes across disparate systems to ensure common connection points are utilized when joining or integrating data sets.
-Work with technical teams to identify data sources.
-Prepare data requirements, data models, and transformation rules for new data warehouse structures, including summary information optimized for analytics.
-Identify areas to increase efficiency and automation of data-related processes.
-Create test cases and perform quality validation of data warehouse content to ensure accuracy.
-Create data flow diagrams to illustrate data lineage and mapping from the data warehouse to end-point publication.
- Analyze code in BI tools (e.g., WebFocus, Tableau) to determine data usage and assist with determining the data usage accuracy.
-Conduct data profiling to identify data quality issues and work with Business and IT teams to resolve the issues.
Qualifications:
* They must be able to compare actual project procedures to the specified standards and procedures.
* They should be able to demonstrate expertise with the most recent and relevant technologies in the WebFocus processes.
* They must have excellent communication skills and possess the ability to collaborate with internal and external groups including vendors.
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience |
| Experience working closely with lines of business, including Research Analysts to address data needs for analytics | Required | 5 | Years |
| Experience with analyzing raw system data | Required | 5 | Years |
| Experience with mining large datasets and drawing actionable insights using statistical methods. | Required | 5 | Years |
| Experience extracting data from large, complex data warehouse | Required | 5 | Years |
| Exp preparing data reqs, data models and transformation rules for new data warehouse structures, incl. summary info optimized for analytics | Required | 5 | Years |
| Proficiency in SQL | Required | 5 | Years |
| Experience conducting data profiling to identify data quality issues and work with the Business and IT teams to resolve issues | Required | 5 | Years |
| Experience creating data flow diagrams to illustrate data lineage and mapping from data warehouse to end point publication | Required | 5 | Years |
| Experience in DB2 server client skills | Required | 5 | Years |
| Experience preparing data for use in Tableau | Highly desired | 3 | Years |
| Experience creating data extracts and reports using WebFocus InfoAssist and the most recent and relevant technologies in the WebFocus processes. | Required | 3 | Years |
| Knowledge of AppStudio and the ability to use it to code reports | Required | 3 | Years |