Hello Vendors,
This is Urvish from Cambay Consulting LLC, I tried calling you regarding an amazing opportunity with State of New Jersey Attorney General's Office, Dept. of Law and Public Safety (NJATCSU) for the position of Data Analyst at St. Trenton NJ.
Kindly go through the email below and let me know the best time to reach you.
Position Details:
Client: | Attorney General's Office, Dept. of Law and Public Safety |
Job Title: | Data Analyst |
Job ID: | 654075 |
Interview Mode | Either Webcam Interview or In Person |
Location: | 25 Market St. Trenton NJ |
Duration: | 6+ Months |
Questions
- One hour unpaid lunch. Do you accept this requirement?
- Fingerprinting full state & federal background check to be completed by the state.
- Travel within NJ is required and not reimbursed.
Job Description:
As a member of the Data Analytics, Research and Standards Team within Trial Courts Services Unit of the NJ Judiciary, the candidate will extract, analyze, and integrate or join data from various systems to assist lines of business with analytical report.
- The ideal candidate will be responsible for working closely with Research Analysts to assist with conducting data analysis to make informed decisions. The ideal will also conduct data extraction via SQL as well as prepare and document data requirements and conduct data validation for the automation of data extractions to be used in analytics. The candidate will have experience in designing new data warehouse structures to meet business needs.
The candidate must:
- Using excellent communication skills, work closely with lines of business, including Research Analysts to address data needs for analytics.
- Be proficient in SQL.
- Analyze raw system data.
- Mine large datasets and draw valid inferences and actionable insights.
- Use SQL to extract data from a large and complex data warehouse and conduct analysis to ensure the proper data is available to support business needs.
- 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., Web Focus, 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.
Relevant Work Experience: 5 to 8 years
Preferred Education: 4 year college degree or equivalent technical study or advanced degree
Skill Matrix:
Skill | Required / Desired | Amount | Experience |
Experience Working closely with lines of business, including Research Analysts to address data needs for analytics. | Required | 5 | |
Experience with analyzing raw system data | Required | 5 | |
Experience with mining large datasets and drawing actionable insights | Required | 5 | |
Experience extracting data from large, complex data warehouse | Required | 5 | |
Exp. Preparing data Reqs, data models and transformation rules for new data warehouse structures, incl. summary info optimized for analytics. | Required | 5 | |
Experience Creating test cases and performing quality validation of data warehouse content to ensure accuracy | Required | 5 | |
Proficiency in SQL | Required | 5 | |
Experience Conducting data profiling to identify data quality issues and work with the Business and IT teams to resolve issues. | Required | 5 | |
Experience Creating data flow diagrams to illustrate data lineage and mapping from data warehouse to end-point publication. | Required | 5 | |
Experience in DB2 Server client skills | Required | 5 | |
Experience preparing data for use in Tableau | Highly desired | 3 | |
Experience creating data extracts and basic reports using Web FOCUS Info Assist | Desired | 3 |
Thanks and Best regards,
Urvish Rai
Ph.: 832-761-3192
Cambay Consulting LLC.
1838 Snake River Road,
Suite A, Katy, TX 77449
::DISCLAIMER::
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or CAMBAY or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of CAMBAY or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of CAMBAY is strictly prohibited. If you have received this email in error, please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.