DB2 Data Requirements Analysis Data Models IT Systems Engineering DynamoDB Red Shif   Requirement id 133696 Job title Consultant Job location in New Jersey, NJ Skills required SQL Analyst, DB2, Complete Life Cycle Projects, Data Requirements Analysis Data Models I Open Date 11-May-2022 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Consultant: SQL Analyst, DB2, Complete Life Cycle Projects, Data Requirements Analysis Data Models I Start Date :04/17/2022 End Date :10/15/2022 Submission Deadline :5/16/2022 Client Info :Judiciary Description : Note: Position is remote. Local candidates will be asked to work onsite 1-2 days a week unless policy changes. Must be an Excellent communicator with superior verbal, written, technical and presentation skills This Data Analyst position is to work with Business Teams and bridge the gap between Judiciary business partners and the technology solution providers by translating business needs into Warehouse solutions for BI. Data Analyst should have extensive SQL writing experience. This position will also involve identification/Verifications of test plans to ensure that technical solutions meet the needs of the business. In addition to being experienced in gathering and documenting requirements, facilitating meetings, and delivering results, this person must also be a highly organized, self-starter who thrives in a fast-paced and rapidly changing environment. 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., 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. Responsibilities: Collaborate with stakeholders from multiple disciplines to elicit business, data and functional requirements into Technical requirements The role is to act as a liaison between Judiciary business units and data warehouse technical development team to ensure business requirements are understood and translated into functional and technical requirements. Document business data glossaries including business definitions and business rules for technical team to develop logical and physical data model design. Data Analysts will understand raw data for various departments and consolidate it into information useful for decision-making by users for Unified Enterprise Judiciary System. Translate data requirements into clearly defined and easily understood documents, including business use cases, process flows, data flows, business rules, data definitions and process-to-data mapping diagrams etc. Required experience on SQL writing like DB2 , AWS (Dynamo, Redshift) as well as have a High-l   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 133696 while calling.   Other jobs in NJ: Edison (2), Englewood Cliffs (1), Ewing (2), Franklin Lakes (7), Hamilton (3), Hightstown (7), Hopewell (2), Jersey City (3), Little Falls (1), Maplewood (1), Mercer County (3), Mount Laurel (11), Mt Laurel (4), New Brunswick (1), Newark (1), Princeton (4), Somerset (9), Trenton (123), Unknown (2), Warren (7), Wayne (1), SQL Analyst job openings in New Jersey, NJ Jobs List NJATCSU BSC4 - Reporting/Dashboard Analyst (683149) Create date: 23-May-2022 Start Date :05/22/2022 End Date :11/19/2022 Submission Deadline :5/20/2022 Client Info : Description : Note: Remote position. Local candidates may be asked to come to the office in Trenton for meetings. Short Description in full: Responsible for facilitating requirements gathering sessio.... (This job is for - job Jobs in NJ NewJersey Analyst - (in New Jersey, NJ)) NJAOC Senior Consultant 1 Mid-Level Data Analyst (679682) Create date: 10-May-2022 Start Date :04/17/2022 End date :10/15/2022 Submission Deadline :5/12/2022 Client Info :Judiciary Description : Note: Position is remote. Local candidates will be asked to work onsite 1-2 days a week unless policy changes. Must be an Excellent communicator with superior verbal, writt.... (This job is for - job Jobs in NJ NewJersey Architect - (in New Jersey, NJ))    SQL Analyst job openings in other states Jobs List DCY - Programmer 5 (764660) Create date: 29-May-2025 Start date : 06/23/2025 End Date : 06/30/2026 Submission deadline : 06/03/2025 Client Info : DCY Note: * In Person Interviews * On Site 5 days a week to start - potential for hybrid later * Local candidates to Columbus, Ohio highly preferred Would like candidate to st.... (This job is for - JavaScript CSS Jobs in OH Columbus Consultant - (in Columbus, OH)) NCDOT - AASHTOWare Project Data Analytics (751368) Create date: 20-Nov-2024 **Remote Max Submittals by Vendor: 2 Start date : 12/09/2024 End Date : 12/18/2025 Submission deadline : 11/26/2024 Client Info : NCDOT Description : ***The candidate will need to use their own equipment from home to remote into the worksite (PC set up in the organizatio.... (This job is for - Team Work Jobs in NC Raleigh Analyst - (in Raleigh, NC)) NCDOT - AASHTOWare Project (AWP) Developer (751410) Create date: 20-Nov-2024 **Remote Max Submittals by Vendor: 2 Start date : 01/13/2025 End Date : 01/23/2026 Submission deadline : 11/26/2024 Client Info : NCDOT Description : ---------------------------------------------------- ****Preference will be given to candidates living in North Caro.... (This job is for - Programming Jobs in NC Raleigh Consultant - (in Raleigh, NC)) NCDOT - AASHTOWare Project (AWP) Developer (751406) Create date: 20-Nov-2024 **Remote Max Submittals by Vendor: 2 Start date : 01/13/2025 End Date : 01/23/2026 Submission deadline : 11/26/2024 Client Info : NCDOT Description : ****Preference will be given to candidates living in North Carolina.The candidate will need to use their own equipment.... (This job is for - SCRUM Jobs in NC Raleigh Consultant - (in Raleigh, NC)) NCDOT - Technical Specialist- Junior (749745) Create date: 31-Oct-2024 No of Submissions : 2 Start date : 10/19/2024 End Date : 10/18/2025 Submission deadline : 11/06/2024 Client Info : NCDOT Note: * Agency Interview Type : Webcam Interview Only * Hybrid Description : *The candidate must come onsite on the first d.... (This job is for - Azure Jobs in NC Raleigh Specialist - (in Raleigh, NC))    SQL Analyst job openings in NJ Jobs List NJATCSU BSC4 - Reporting/Dashboard Analyst (716511) Create date: 01-Aug-2023 Hybrid Start date :08/12/2023 End Date :09/23/2023 Submission deadline :8/29/2023 Client Info :Judiciary Description : ------------------------------------------------------ Note: Excellent communication, requirements documentation skills, and attention to detail are required. Experi.... (This job is for - Queries Jobs in NJ MercerCounty Analyst - (in Mercer County, NJ)) NJAOC Quality Assurance Specialist (687363) Create date: 28-Jul-2022 Start date :07/31/2022 End Date :01/28/2023 Submission deadline :8/2/2022 Client Info :Judiciary Description : Note: Role is 100% remote in the foreseeable future. Quality Assurance Specialist is responsible for the design, pilot, & implementation of the software quality assura.... (This job is for - job Jobs in NJ Trenton Specialist - (in Trenton, NJ)) NJDOH ASAPM Back End/DB Developer (683192) Create date: 23-May-2022 Start Date :05/23/2022 End Date :06/30/2022 Submission Deadline :5/20/2022 Client Info :DOH Description : Please do not submit any candidates that are in need of remote work - this is 100% onsite role. Please do not submit any candidates that interviewed for NJDOH ASAPM Back End/DB Develo.... (This job is for - job Jobs in NJ Trenton Developer - (in Trenton, NJ)) NJDOH Database Manager/Administrator 3 - Badisa (606291) Create date: 24-Oct-2019 Start Date :11/28/2019 End Date :12/27/2019 Submission Dead Line :10/30/2019 Client Info :DOH Description : Database administrator is needed for redesigning CDRSS. The New Jersey Department of Health (NJDOH) is currently developing a replacement system for our existing disease surveil.... (This job is for - job Jobs in NJ Trenton Administrator - (in Trenton, NJ)) (Consultant: SQL Analyst, DB2, Complete Life Cycle Projects, Data Requirements Analysis Data Models I in New Jersey, NJ)

Featured Jobs SharePoint Analyst (Jobs in Pontiac, Michigan) IIS Troubleshooting Architecting JAVA Architect (Jobs in Madison, Wisconsin DAX ETL Administrator (Jobs in Lansing, Michigan) IIS Architecting Business Architect (Jobs in Madison, Wisconsin) HCM SaaS IT Analyst (Jobs in Raleigh, North Carolina) ITSM Architect (Jobs in Madison, Wisconsin) Analytical Skills System Architect (Jobs in Madison, Wisconsin) OOAD C# Developer (Jobs in Richmond, Virginia) DHCP Firewall Written Engineer (Jobs in Richmond, Virginia) Business Consultant (Jobs in Richmond, Virginia)