Senior Data Modeler (680810)
About the Opportunity
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- We are only considering local candidates who currently reside within 45 minutes of postal code 08611
- No Third Party Agencies
- $104 per hour 1099, $90 per hour W2 + benefits
- Location: 3 days work from home + 2 days on site in Trenton, NJ
- Job Id: CAI-680810
- Must be able to provide proof of COVID-19 vaccination plus booster shot
- Contract Term: Till end of the 2022 fiscal year with yearly extension based upon performance
Short Description
The State of New Jersey’s Administrative Office of the Courts (NJAOC) is seeking a Senior Data Modeler to design and implement modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet Judiciary needs using conceptual, logical, and physical data models for for various databases like AWS Redshift, RDS, S3, DynamoDB , DB2, and PostgreSQL.
Required Skills/Years of Experience
- Bachelor Degree or equivalent technical study
- 8+ years of DB2, AWS Redshift, DynamoDB, PostgreSQL, SQL Server
- 8+ years of strong SQL and data profiling using relational databases
- 8+ years of analyzing databases, data sets, and referential integrity
- 6+ years of data modeling software
- 3+ years of AWS and Other Cloud systems
- 3+ years of big data experience
- 2+ years of building data lakes using structured and unstructured data
Desired Skills/Years of Experience:
- 4+ years of database tuning techniques
Complete Description
The State of New Jersey’s Administrative Office of the Courts (NJAOC) is seeking a Senior Data Modeler to design and implement modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet Judiciary needs using conceptual, logical, and physical data models for for various databases like AWS Redshift, RDS, S3, DynamoDB , DB2, and PostgreSQL.
The Senior Data Modeler will be responsible for the design, develop, and implementation of data warehouse database structures and analytical database structures. This role will work with business groups and application teams during pre and post assessment periods. The position reports to Supervisor/Team Lead. The Senior Data Modeler must write complex SQL statements and stored procedures for data analysis. The Senior Data Modeler must come to understand the needs of the business team and BI team for building a proper data warehouse and data mart. The Senior Data Modeler must develop structured and unstructured data models for BI and Analytics.
The Senior Data Modeler will be tasked to:
- 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
Hiring Expectations
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- No Third Parties
- Right to Represent authorization is required
- Expect technical interview screening
- Expect F2F interview
- Background check and/or credit check will be required