Senior Data Modeler
: Job Details :

Job ID Number

R4467

Employment Type

Full time

Worksite Flexibility

Hybrid

Job Summary

As the Senior Data Modeler, you will design and implement modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet the client's needs using conceptual, logical, and physical data models.

Job Description

We are looking for a Senior Data Modeler to design and implement modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet the client's needs using conceptual, logical, and physical data models. The data modeler should be capable of modelling for various data bases like AWS Redshift, S3, Dynamo DB , DB2, and post GRE. This role will be full-time and hybrid in Trenton, NJ.

What You'll Do

• 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 client 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

What You'll Need

Required:

• Candidate should have over all 8+ years of Data Modelling experience

• Bachelor's Degree

• 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

• 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

• Knowledge of recent modeling techniques that are adapted for data warehousing and analytical structures.

• Able to build logical data model and translate logical model into physical database

• Able to demonstrate expertise with the most recent and relevant technologies in the data modelling implementation

• Excellent communication skills and possess the ability to collaborate with internal and external groups including vendors

• 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)

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards

• Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable Accommodation Statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to ...@cai.io or (888) 824 – 8111.

Equal Employment Opportunity Policy Statement

It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.