Lead Data Modeler with Snowflake- Remote

Cognizant; Columbus (OH); Remote; USD 100,000 - 120,000; Full time

Job summary

Join a leading provider of IT and consulting services as a Data Modeler in a dynamic environment focused on AI and analytics. This role involves collaborating with stakeholders to design and optimize data models that meet business needs. You'll work with cutting-edge tools and methodologies, applying your expertise in Python and SQL to drive data-driven decision-making. With a commitment to innovation and excellence, this established firm offers a collaborative workplace where your contributions will significantly impact clients' success. If you're passionate about data and eager to make a difference, this is the perfect opportunity for you.

Benefits

Medical/Dental/Vision/Life Insurance

Paid holidays plus Paid Time Off

401(k) plan and contributions

Long-term/Short-term Disability

Paid Parental Leave

Employee Stock Purchase Plan

Qualifications

• Fluency in Python, SQL, and Unix with strong data modeling skills.
• Experience in Agile environments and excellent communication abilities.

Responsibilities

• Collaborate with stakeholders to elicit data requirements and design data models.
• Execute data analysis and design models for data warehouse and BI applications.

Skills

Python

SQL

Unix

Data Analysis

Data Modeling

Communication Skills

Agile Methodologies

Tools

Erwin

ER Studio

Toad DM

Power Designer

Git

Liquibase

Job description

Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.), Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 1000, and the Fortune 500 and we are among the top performing and fastest growing companies in the world.

*Please note, this role is not able to offer visa transfer or sponsorship now or in the future*

Practice - AIA - Artificial Intelligence and Analytics

About AI & Analytics: Artificial intelligence (AI) and the data it collects and analyzes will soon sit at the core of all intelligent, human-centric businesses. By decoding customer needs, preferences, and behaviors, our clients can understand exactly what services, products, and experiences their consumers need. Within AI & Analytics, we work to design the future—a future in which trial-and-error business decisions have been replaced by informed choices and data-supported strategies.

By applying AI and data science, we help leading companies to prototype, refine, validate, and scale their AI and analytics products and delivery models. Cognizant’s AIA practice takes insights that are buried in data and provides businesses a clear way to transform how they source, interpret, and consume their information. Our clients need flexible data structures and a streamlined data architecture that quickly turns data resources into informative, meaningful intelligence.

Responsibilities

• Demonstrated skill working directly with stakeholders, business partners, SMEs, systems peers, and cross-functional teams to elicit data requirements and design appropriate data models that align with business needs.
• Structured execution of data analysis, data profiling, and data mapping tasks.
• Translating current and future business requirements into conceptual, logical, and physical data model designs. Proficiency in utilizing standard data modeling tools (e.g. Erwin, ER Studio, Toad DM, Power Designer, etc.).
• Designing data models for multiple distinct patterns (e.g. relational, dimensional, hybrid) associated with data warehouse, BI, and big data applications.
• Creation of new and extension of existing data models across multiple DBMS platforms (e.g. Oracle, SQL Server, DB2, Snowflake, Teradata, NoSQL).
• Ability to understand and explain complex data integration and extraction/transformation/load processes.
• Demonstrated experience identifying and resolving data model performance issues to optimize database performance and enhance overall system functionality.
• Documenting and communicating data model designs and standards to ensure understanding and compliance with expectations for interoperability across the organization.
• Proven communication skills illustrating ability to effectively interact with people at all levels of business and technology organizations.
• Fluency in Python, SQL, and Unix. High proficiency with generating complex SQL queries is required.
• Version control of databases and metadata management tools (e.g. Git, Liquibase, etc).
• Insurance and Financial domain experience is highly desired.
• Experience working in an Agile environment using Lean, Kanban and Scrum practices.

Application Expiration Date: 2/18/2025

The annual salary for this position is between $100,000 - $120,000 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant’s discretionary annual incentive program and stock awards, based on performance and subject to the terms of Cognizant’s applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.