AWS SQL Modeler (Jobs in Trenton, NJ)   Requirement id 133195 Job title Modeler Job location in Trenton, NJ Skills required Data Modeling, AWS, SQL Server, Open Date 15-Apr-2022 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Modeler: Data Modeling, AWS, SQL Server, Start date : 04/24/2022 End date : 10/22/2022 Submission deadline : 4/21/2022 Client info : Judiciary Note: Contractor will work remotely with the expectation that they will come into the office to work On-Site a few times per month or more frequently if policies change. As such, Contractor needs to live locally. Agency Interview Type: iLinc Web Cam Interview Only Description: This SDM position is for designing and implementing modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet Judiciary needs using conceptual, logical, and physical data models. The SDM should be capable of modelling for various data bases like AWS Redshift, S3, Dynamo DB , DB2, Postgress. Complete Description Senior Data Modeler (SDM) Specialist will be responsible for the design, develop & implementation of Data Warehouse database structures and Analytical Database structures. SDM will work with Business groups and Application Teams during pre & post assessment periods. The SDM reports to Supervisor/Team Lead. DSM should be able to write complex SQLs ,write and execute Stored Procedures for analysis for data . SDM should understand the needs of the Business team and BI team for building proper Data Warehouse and DataMart. Should be capable of developing structured and unstructured data model for BI and Analytics. Tasks: • Understand and translate business needs into data models supporting long-term solutions for different Judiciary systems. • Work with the Application Development teams (ex: Pega Applications) to implement data strategies, build data flows and develop conceptual data models. • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy. • Optimize and update logical and physical data models to support Data Initiative project for different phases of implementation. • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models. • Recommend opportunities for reuse of data models in new environments. • Perform reverse engineering of physical data models from databases like DB2 and SQL scripts. • Evaluate data models and physical databases for variances and discrepancies across the different source systems in Judiciary. • Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to Judiciary Standards. • Work with all IT teams like System Analysts, Engineers, Programmers, BI and others on project limitations and capabilities, performance requirements and interfaces. • Review modifications to existing software to improve efficiency and performance. Qualifications: • Candidate should have over all 8+ years of Data Modelling experience. • Minimum 4 years of overall experience and 3 years into Bigdata Technologies • Strong work experience in Data modeling and usage of data modeling tools. • Exposure with Snowflakes Cloud Data Warehouse, if possible • He/she should be well versed in understanding relational data, dimensional data, unstructured data, and master data. • Should have recent data management trend skills such as developing data lake model along with traditional modelling practices like snowflake and star. • They should know modeling techniques latest that are adapted for data warehousing and analytical structures. • Able to build logical data model and translate logical model into physical database. • 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 data modelling implementation. • They must have excellent   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 133195 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), Data Modeling job openings in Trenton, NJ Jobs List NJAOC SC 1-PEGA SSA (739560) Create date: 06-Jun-2024 * Hybrid No of submissions : 1 Start date :06/30/2024 End date :08/14/2024 Submission deadline :6/11/2024 Client info : Judiciary Note: * Position is Hybrid. Local candidates will be asked to come into the office 1-2 Days / Week. * Position will be extended u.... (This job is for - job Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJAOC SC 1-PEGA SSA (717131) Create date: 02-Aug-2023 Start date :08/20/2023 End Date :09/27/2023 Submission deadline :8/7/2023 Client Info :Judiciary Note: Hybrid Description : Position is remote or hybrid depending on candidates location.. Local candidates will be asked to come into the office for meetings each month. This will b.... (This job is for - Pega Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJAOC Senior Consultant 1-PEGA SSA- UI/UX (714353) Create date: 27-Jul-2023 Hybrid Start date :07/30/2023 End Date :06/29/2024 Submission deadline :8/2/2023 Client Info :Judiciary Description : ------------------------------------------------------ Note:This is a Hybrid role requiring 2 Days / Week Onsite with the team. MINIMUM of 5 years Post PEGA.... (This job is for - Pega Jobs in NJ Trenton Consultant - (in Trenton, NJ)) NJ DOL - App Systems Analysis(702623) Create date: 20-Jan-2023 Job Title : NJ DOL - App Systems Analysis/Programming Mgr 3 - Jr. Oracle Developer (702623) start date : 02/06/2023 End date : 02/05/2024 submission deadline : 1/25/2023 client info : LWD - Information Technology Note : * Hybrid * Interview Type : Either iLinc Web Cam or .... (This job is for - job Jobs in NJ Trenton Analyst - (in Trenton, NJ)) NJAOC Senior Consultant 1 PEGA SSA (697896) Create date: 15-Nov-2022 Remote Start date :11/27/2022 End Date :01/27/2023 Submission deadline :11/17/2022 Client Info :Judiciary Description : --------------------------------------------- PEGA Certified Senior System Architect WITH A MINIMUM OF 5 YEARS WORKING EXPERIENCE after Pega SSA certification. Pleas.... (This job is for - Reporting Jobs in NJ Trenton Consultant - (in Trenton, NJ))    Data Modeling job openings in other states Jobs List Business Intelligence Developer-Data Analytics Strategy Lead Create date: 18-Dec-2024 No of Submissions: 2 Start date : 1/27/2025 End date : 01/23/2026 Submission deadline : 01/03/2025 Client info: CT DAS Note: * Position Location: Remote * Max Rate for this Position is USD 102.50 Per Hour Description: About the Role T.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) Database Analyst - Cloud Solution Analyst Create date: 12-Dec-2024 * Bill Rate: USD 75.00 Per Hour * Max Rate: USD 91.00 Per Hour No of Submissions : 1 Start date : 02/01/2025 End Date : 01/31/2026 Submission deadline : 12/17/2024 Client Info : CO CDPHE Note: * Position Location: Hybrid * Candidate Must Be Lo.... (This job is for - MS SQL Server Jobs in CO Denver Analyst - (in Denver, CO)) SOFTWARE ARCHITECT - CONSULTANT-11434-1 Create date: 29-Oct-2024 No of Submissions : 2 start date : 12/07/2024 submission deadline : 11/5/2024 client info : Department of Health and Human Services Note: Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? A) A video conference interview or in-person interview may be con.... (This job is for - JQuery Jobs in SC Columbia Architect - (in Columbia, SC)) DRC-Programmer 4/ PR 4Replacements (748107) Create date: 30-Sep-2024 No of Submissions : 2 start date :11/11/2024 End date :06/30/2025 submission deadline : 10/03/2024 client info : DRC Note: * AM: Shalaka * A more senior developer is responsible for planning, processing and performing all jobs in an efficient manner with little or no su.... (This job is for - NET FRAMEWORK Jobs in OH Columbus Consultant - (in Columbus, OH)) NC FAST Integration Engineer (743614) Create date: 19-Aug-2024 Hybrid No of Submissions : 1 start date :09/16/2024 End date :09/12/2025 submission deadline : 08/26/2024 client info : NCDHHS-NCFAST Note: * Agency Interview Type: Either Webcam Interview or In Person Description : .... (This job is for - JSON Jobs in NC Durham Engineer - (in Durham, NC))    Data Modeling job openings in NJ Jobs List NJDHS-DFD Database Manager/Administrator 4 (668919) Create date: 11-Dec-2021 Start Date :12/20/2021 End Date :06/30/2022 Submission Deadline :12/16/2021 Client Info : DHS - Division Of Family Development Note : * Agency Interview Type: In Person Only Description : Please note - this is a role where onsite/hybrid work will be.... (This job is for - T SQL Jobs in NJ MercerCounty Administrator - (in Mercer County, NJ)) Business Analyst Create date: 20-Nov-2019 Requirements Years of work experience: 8 year(s) Languages Must have English Native or bilingual proficiency Experience required Title: Business Analyst Location: Union, NJ Type: Contract Experience in agile methodologies, tools, standards.... (This job is for - job Jobs in NJ Union Analyst - (in Union, NJ)) Senior DataStage Developer - J-10-655-307 Create date: 09-Mar-2012 [Note : Submission Deadline : 03-19-2012] [Note : Start Date : 03-19-2012 End Date : 07-01-2012] Skills Required: Over 10 years of professional IT experience including 6+ years of expertise in data warehouse Design, Development and Implementation and Data migration projects using IBM Websphere DataStag.... (This job is for - Data Warehousing Jobs in NJ BerkeleyHeights Developer - (in BERKELEY HEIGHTS, NJ)) (Modeler: Data Modeling, AWS, SQL Server, in Trenton, NJ)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)