Overview
On Site
Contract - W2
Contract - 20 day(s)
Skills
data lake
DB@
Job Details
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.
Tasks:
Understand and translate business needs into data models supporting long-term solutions for different 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 .
Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to 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 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:
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.
Strong SQL and data profiling skills in various relational databases.
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)
Required/Desired Skills
Questions
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.
Tasks:
Understand and translate business needs into data models supporting long-term solutions for different 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 .
Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to 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 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:
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.
Strong SQL and data profiling skills in various relational databases.
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)
Required/Desired Skills
| Skill | Required /Desired | Amount | of Experience | Candidate Experience (in Years) | Last Used (Year) |
|---|---|---|---|---|---|
| Experience in Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server | Required | 8 | Years | ||
| Data modeling software | Required | 6 | Years | ||
| AWS and Other Cloud systems | Required | 3 | Years | ||
| Strong SQL and data profiling skills in various relational databases. | Required | 8 | Years | ||
| Analyzing source databases, source data, source database referential integrity and profiling source data | Required | 8 | Years | ||
| Database tuning techniques | Nice to have | 4 | Years | ||
| Experience in building Data Lakes for both structured and unstructured data | Required | 2 | Years | ||
| 4 years College Degree or equivalent technical study | Required | 4 | Years |
| No. | Question | Candidate Response |
|---|---|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? | |
| Question2 | Please list candidate's email address. | |
| Question3 | Where is the candidate currently geographically located? | |
| Question4 | If the candidate resides more than 1 hour from the client site, will the candidate relocate for the position? | |
| Question5 | Please provide address to LinkedIn profile if available. |
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.