Remote - Data analytics and reporting developer

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

Software technology inc