TrentonRecruiter Since 2001
the smart solution for Trenton jobs

Sr. Data Modeler - Design and Implementation in Trenton, NJ

Company: Super Technology Solutions, Inc.
Location: Trenton
Posted on: February 24, 2021

Job Description:

One of our premier clients is looking for a Senior Data Modeler in Trenton, NJ for 6-12 months' engagement. If interested, please submit your resume ASAP indicating (1) current location (2) desired hourly rate, W2 or 1099? (3) your email address.This Senior Data Modeler 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 DescriptionSenior 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 SQL's ,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.REQUIRED SKILLS / EXPERIENCE:--- 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 Snowflake's 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 communication skills and possess the ability to collaborate with internal and external groups including vendors.--- They must have the ability of working independently and with minimal supervisionREQUIRED Skills:--- 8+ years of experience in Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server, Pega Application.--- Data modeling software (6 years)--- AWS and Other Cloud systems experience is must (3 years)--- Strong SQL and data profiling skills in various relational databases (8 years)--- Analyzing source databases, source data, source database referential integrity and profiling source data (8 years)--- Database tuning techniques (minimum 4 years)--- Experience in building Data Lakes for both structured and unstructured data (2 years) - provided by Dice

Keywords: Super Technology Solutions, Inc., Trenton , Sr. Data Modeler - Design and Implementation in Trenton, NJ, Other , Trenton, New Jersey

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Make up to $21/hour - Deliver with DoorDash
Description: Your time. Your Goals. 10 What is DoorDash 10 Available in over 4,000 cities in the U.S., Canada, and Australia, DoorDash is about connecting people with possibilities: bigger savings accounts, (more...)
Company: Doordash
Location: Levittown
Posted on: 03/1/2021

Remote Transcriber - Law Enforcement Audios (Work from home)
Description: Net Transcripts is looking for many vendors / independent contractors who have experience transcribing audio content of criminal investigations, court proceedings, law enforcement interviews, jail calls, (more...)
Company: Net Transcripts
Location: Lancaster
Posted on: 03/1/2021

Private Investigator - Part Time
Description: SUMMARY: Conduct various types of investigations and covert surveillance with an emphasis on insurance fraud and insurance claims defense. DUTIES AND RESPONSIBILITIES: Investigates Insurance Claims. Develops (more...)
Company: Meridian Investigative Group, Inc.
Location: Levittown
Posted on: 03/1/2021


Biologics Testing Scientists: ALL LEVELS
Description: Company Description At Eurofins people are the most important element in our chemistry, and now more than ever. As the world is an uphill battle fighting this devastating pandemic, the need for insurmountable (more...)
Company: Eurofins USA
Location: Lancaster
Posted on: 03/1/2021

Make up to $19/hour - Deliver with DoorDash
Description: Your time. Your Goals. What is DoorDash Available in over 4,000 cities in the U.S., Canada, and Australia, DoorDash is about connecting people with possibilities: bigger savings accounts, wider nets, (more...)
Company: Doordash
Location: Westport
Posted on: 03/1/2021

Associate Sample Administration Specialist
Description: Company Description Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment (more...)
Company: Eurofins USA
Location: Lancaster
Posted on: 03/1/2021

Private Investigator - Part Time
Description: SUMMARY: Conduct various types of investigations and covert surveillance with an emphasis on insurance fraud and insurance claims defense. DUTIES AND RESPONSIBILITIES: Investigates Insurance Claims. Develops (more...)
Company: Meridian Investigative Group, Inc.
Location: Lancaster
Posted on: 03/1/2021

Injection Molding Apprentice
Description: Overview Stryten Manufacturing, a new company name with a long history in Lancaster County, operates a growing plastic injection molding facility in West Lampeter Township. We produce plastic components (more...)
Company: Motrex, LLC
Location: Lancaster
Posted on: 03/1/2021

Client Services Associate - Second Shift
Description: Company Description Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and our environment (more...)
Company: Eurofins USA
Location: Lancaster
Posted on: 03/1/2021

Packaging
Description: Adecco has partnered with a food manufacture in Lancaster PA. Start ASAP No Client Interview needed. Great location by Park City Mall. Adecco Staffing
Company: Adecco USA
Location: Lancaster
Posted on: 03/1/2021

Log In or Create An Account

Get the latest New Jersey jobs by following @recnetNJ on Twitter!

Trenton RSS job feeds