Attention prospective job seekers! Beware of fraudulent offers Read more

Data Modeler

New York, New York, United States
Apply
Back to Results Click to Back to Results
Data Modeler - CREQ170479
Description

Title: Data Modeler

Location: Clinton, NJ (Hybrid role)

Job Description:

Responsibilities
Responsible for the development of the conceptual, logical, and physical data models on Cloud Data Warehouse, data marts, and data lakes on target platforms like Redshift.
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
Implement data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL)and data tools (reporting, visualization, analytics, and machine learning).
Work with business and application/solution teams to implement data strategies,build data flows, and develop conceptual/logical/physical data models Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
Skills & Experience
10years of hands on design and implementation of Data Warehouse, Dimensional model and business semantic models
Should have hands on experience in designing and build data models from scratch on Cloud Data Warehouse like Redshift, Aurora , Dynamo DB
Experience in using data modelling tools like Erwin or ER Studio or others is required.
Experience on modelling in Big data environment on -premise implementation, Hive Database is preferable
Have a experience in SQL and good understanding of source systems like Oracle , SQL Server , Teradata etc is must
Should have knowledge of Knowledge of any ETL tool,Informatica is preferable
Strong communication skills
Exposure to Insurance domain is preferable

Primary Location
New York, New York, United States
Job Type
Experienced
Skill
Data-AWS Redshift with AWS NativeServices,EMR,S3,Traditional or Cloud ETL Tools.
Qualification

Title: Data Modeler

Location: Clinton, NJ (Hybrid role)

Job Description:

Responsibilities
Responsible for the development of the conceptual, logical, and physical data models on Cloud Data Warehouse, data marts, and data lakes on target platforms like Redshift.
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
Implement data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL)and data tools (reporting, visualization, analytics, and machine learning).
Work with business and application/solution teams to implement data strategies,build data flows, and develop conceptual/logical/physical data models Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
Skills & Experience
10years of hands on design and implementation of Data Warehouse, Dimensional model and business semantic models
Should have hands on experience in designing and build data models from scratch on Cloud Data Warehouse like Redshift, Aurora , Dynamo DB
Experience in using data modelling tools like Erwin or ER Studio or others is required.
Experience on modelling in Big data environment on -premise implementation, Hive Database is preferable
Have a experience in SQL and good understanding of source systems like Oracle , SQL Server , Teradata etc is must
Should have knowledge of Knowledge of any ETL tool,Informatica is preferable
Strong communication skills
Exposure to Insurance domain is preferable

Travel
No
Job Posting
15/09/2023
Salary range
$120,000.00 - $130,000.00 (USD)
Job Search Form

Join Virtusa

 

We only accept the following file extensions: .pdf, .docx or .doc
Maximum file size: 1 MB
File name must not include special characters or spaces (e.g. “name_resume.pdf”)

Please attach your CV/Resume, ensure it is in the correct format and smaller than 1MB.
We only accept the following file extensions:

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 36,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa is an Equal Opportunity Employer. All applicants will receive fair and impartial treatment without regard to race, color, religion, sex, national origin, ancestry, age, legally protected physical or mental disability, protected veteran status, status in the U.S. uniformed services, sexual orientation, gender identity or expression, marital status, genetic information or on any other basis which is protected under applicable federal, state or local law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government-issued ID during each interview. All candidates must be authorized to work in the USA.

Learn more

Back to Results Click to Back to Results
Related jobs