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 ---    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 Systems Architect II-128975 Create date: 04-Apr-2024 Start date : 05/20/2024 End Date : 06/30/2024 Submission deadline : 4/11/2024 at 4:00PM CST Client Info : ETF Note : * Interview Process: remote via MS Teams * Duration: 6/30/2024, likely to extend * Onsite or Remote? Candidates MUST be WI residents. No relocation is al.... (This job is for - job Jobs in WI Madison Architect - (in Madison, WI)) .NET Web Developer II - 128806 Create date: 01-Apr-2024 Start date : 05/06/2024 End date : 06/30/2024 Submission deadline : 4/5/2024 at 4:00PM CST. Client info : DCF Note : * INTERVIEW NOTES: PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uploaded to candidates bid upon confirming the interview. Please see "DCF Realtime Phot.... (This job is for - job Jobs in WV Madison Developer - (in Madison, WV)) Systems Architect II - 128587 Create date: 25-Mar-2024 Start date : 04/22/2024 End date : 06/30/2024 Submission deadline : 3/27/2024 at 4:00PM CST. Client info : ETF Note : * Interview Process: remote via MS Teams * Duration: 6/30/2024, likely to extend * Onsite or Remote? Candidates MUST be WI residents or willing to rel.... (This job is for - job Jobs in WI Madison Architect - (in Madison, WI)) Data Warehouse Developer III -128359 Create date: 18-Mar-2024 Start date : 04/08/2024 End Date : 06/30/2024 Submission deadline : 3/20/2024 at 4:00PM CST. Client Info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. * Duration: 6/30/2024, likely to extend. * Onsite or Remote? Candidates MUST be WI residents or willing to r.... (This job is for - ETL Alteryx Jobs in WI Madison Developer - (in Madison, WI)) NCDOT - AASHTOWare Project Support Specialist (727928) Create date: 26-Jan-2024 Start date : 02/09/2024 End date : 02/14/2025 Submission deadline : 02/01/2024 Client info : NCDOT Note : * Remote Description : This is technical and analytical work in designing, developing, implementing and supporting AASHT.... (This job is for - job 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 DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)