Data Modeler

cognizant technologies; Philadelphia (Philadelphia County); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading technology consulting firm is seeking a data modeling specialist to enhance their data warehouse solutions. The ideal candidate will have 1-2 years of experience in database technologies and a strong background in data modeling, specifically with SSIS and Oracle/SQL. You will be responsible for designing logical and physical models and organizing sessions with business teams to understand data requirements. Excellent communication skills and experience in the insurance domain are preferable.

Qualifications

• 1-2 years of experience in database technologies and data design.
• Strong skills in data profiling and logical modeling.
• Experience with the Insurance domain is preferable.

Responsibilities

• Design logical and physical models across multiple Data Warehouses.
• Organize working sessions with business operations to understand data sources.
• Optimize performance for large OLAP & Data Warehouse solutions.

Skills

Data modeling

SSIS

Oracle/SQL

Entity Relationship Modeling

Tools

ERWin

Job description

Cognizant Technologies delivers value added turn-key solutions to our clients which accelerate their organization’s growth. Whether it’s entering new markets, introducing innovative new products, or initiating transformation process changes, Cognizant Technologies will provide consistent services to their clients.

Job Description

• Duration: Long Term
• Interview Process: Phone + In-person

Qualifications

• Design logical and physical models across multiple Data Warehouses
• Strong experience in SSIS.
• Organize working sessions with business operations team to understand sources of data and expected output.
• 1-2 years of experience in database technologies, data design and performance optimization for large OLAP & Data Warehouse solutions.
• Expert in relational and dimensional structures for large (multi-terabyte) operational, analytical, warehouse and BI systems
• Skilled in data profiling, business domain modeling, logical data modeling, physical relational data modeling and design
• Strong skills in Entity Relationship Modeling (ERWin modeling software preferred)
• Excellent written and verbal communication skills with strong relationship building skills
• Ability to work in a large, complex business and technical environment
• Experience with Insurance domain preferable
• Experience with Erwin or similar data modeling tool
• Strong Oracle/SQL expertise