Senior Data Modeler

What makes Cognizant a unique place to work? The combination of rapid growth and an international and innovative environment! This is creating many opportunities for people like YOU — people with an entrepreneurial spirit who want to make a difference in this world.

At Cognizant, together with your colleagues from all around the world, you will collaborate on creating solutions for the world's leading companies and help them become more flexible, more innovative, and successful. Moreover, this is your chance to be part of the success story.

Position Summary

Join Cognizant as a Data Modeler; collaborate with our experienced Engineering teams on exciting client projects where you will be able to create data models optimized across different data domains and for various purposes, working with enterprise requirements from business analysts, data architects, data administrators, database developers, and data scientists.

Mandatory Skills

Primary Skills

• Data Modeling – Expert
• Informatica Power Center Expert Teradata SQL - Expert
• Oracle – Expert
• Informatica – Push Down optimization
• Python – Expert
• Shell Script – Expert

Database and Other skills

• HBase - Basic

• Teradata - Expert
• Hive - Expert
• Oracle – Expert
• Alex - Expert

Tools

• Pycharm - Expert
• ControlM - Expert
• Project Management tools (JIRA, ServiceNOW, Remedy etc. ) – Advanced
• MS Visio Clearcase Versioning tool-Expert
• HP ALM/QC- Expert
• Erwin - Expert

Roles And Responsibilities

Project Management

• Implement business and IT 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 modeling 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.
• Hands-on modeling, design, performance tuning etc.
• Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.

Sprint Delivery Management:

• Participate daily stand-up, iteration planning, sprint review, and iteration retrospective.
• Engage in communications with management and stakeholders.
• Work with the team to resolve project roadblocks if any
• Proactively identify and eliminate impediments and facilitate flow
• Experience in project management software (i.e. JIRA, Confluence, etc.)
• Manage other special tasks as assigned.

Stakeholder Management

• Manage the relationship with the client and all stakeholders
• Establish and maintain relationships with third parties/vendors
• Report and update the management/customer about the issues/blockers on time to mitigate risk

Technical Contribution

• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy using Erin tool.
• Understand and translate business needs into data models supporting long-term solutions.
• Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Recommend opportunities for reuse of data models in new environments.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Review modifications to existing software to improve efficiency and performance.
• Examine new application design and recommend corrections if required.
• Develop data models according to company standards.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Work with development and UAT teams to support the test phase in terms of design issues.
• Perform source data analysis and understand the business requirement to provide the solutions and prepare data models.
• Strong experience in estimations that includes operational costs, resources, governance costs etc.
• Extensive experience in database tools like Teradata, Big data, Oracle etc.

Knowledge Management:

• Create/Update Knowledge Repository /artifacts based on project/customer needs inclusive of business/ application levels requirements.

Knowledge Transition:

• Understand and analyze business requirements based on the review of documents (functional specifications document, technical specification documents etc.) as received from client / onsite.
• Participate in KT calls to understand the requirements.
• Conduct reverse KT with the client / onsite or share the understanding document detailing out the requirement or application/domain knowledge to ensure understanding on the same.
• Prepare and share query log (tracker) to track queries.
• Follow-up to ensure resolution of queries as documented in the query log.
• Seek signoff from the client.

What does success look like?

• Providing technical innovation to guide environment/operation and development teams in the automation of operational processes.
• Identify dependencies and impediments of overall sprint process and remove to success
• Supporting engineers on implementing solutions within complex enterprise environments
• Ensuring all components provide quality, security, scalability, stability, efficiency and reliability, maintaining compliance with client processes and governing standards.
• Experience with Data science and Analytics.
• Responsible to understand the business needs /requirements and efficiently design an end-to-end solution for big data batch pipelines in an agile development environment.
• Involve on architecture design discussions, competitive displacement, proof-of-concept engagements, solution demonstrations and technical workshops.
• Translate business need/requirements into technical specifications, develop application strategy and high-level design documentation.
• Design and build robust generic frameworks for both streaming and batch pipelines.
• Provide roadmaps and impact analysis for the proposed solution.
• Provide estimates for end -to-end solution that includes operational costs, resources etc...
• Communicate and collaborate primarily with the engineering teams, customer and higher management.

Salary Range: >$100,000

Date of Posting: 26th May 2025

Next Steps: If you feel this opportunity suits you, or Cognizant is the type of organization you would like to join, we want to have a conversation with you! Please apply directly with us.

For a complete list of open opportunities with Cognizant, visit http://www.cognizant.com/careers. Cognizant is committed to providing Equal Employment Opportunities. Successful candidates will be required to undergo a background check.