App Tech Specialist - Senior Data Modeler

Job Title : App Tech Specialist - Senior Data Modeler

Job ID : 25-11239

Location : Trenton, NJ (Hybrid)

Duration : 06 months of contract.

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.

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.

This position will be extended past the end date listed.

Short 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 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.

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 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 supervision

Skills :

Skill Matrix :

Skill Required / Desired Amount of Experience

Compensation :

The hourly rate for this position is between $77.00 - $85.00 per hour.

Factors which may affect starting pay within this range may include [geography / market, skills, education, experience and other qualifications of the successful candidate].

Benefits :

Sunrise offers ACA compliant medical coverage / dental insurance / vision insurance to all employees. We also offer Sick time benefits as required per State regulations.