Data Modeler

Cognizant; City of Melbourne; On-site; AUD 110,000 - 150,000; Full time

Job summary

Cognizant in Melbourne is seeking an experienced Data Modeler to design and develop scalable data models across modern data platforms. You will work with business stakeholders, data architects, and data engineering teams to build data foundations, analytical data marts, and business-ready data products.

The ideal candidate has strong expertise in data warehousing, dimensional modeling (Kimball), data governance, and cloud-based analytics platforms, with a track record of delivering performant

Qualifications

• Experience in logical/physical data modeling and dimensional modeling.
• Ability to design fact and dimension tables for BI.
• Proficiency with cloud data platforms and ETL/ELT concepts.
• Knowledge of data lineage, metadata, and data quality frameworks.

Responsibilities

• Design and maintain logical and physical data models.
• Define fact, dimension, and aggregate tables for reporting.
• Develop scalable data structures for BI and analytics.
• Create source-to-target mapping documentation.
• Define data relationships and transformation logic.
• Design data models across Raw Data Layer, Curated Data Layer and Business/Semantic Layer.
• Build and optimize dimensional models using Kimball methodology.
• Ensure consistency, reusability, and performance of analytical datasets.
• Collaborate with governance teams to ensure compliance with data policies.
• Translate business requirements into scalable data solutions.
• Provide guidance to data engineers during implementation.

Skills

Data Modeling

Dimensional Modeling

Kimball Methodology

Star Schema

Snowflake Schema

Cloud Platforms

Data Governance

Job description

Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.), Cognizant combines a passion for client satisfaction, technology innovation, deep industry and business process expertise, and a global, collaborative workforce that embodies the future of work. Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 2000, and the Fortune 500 and is ranked among the top performing and fastest growing companies in the world.

Our Culture:

Your passion, integrity and experience are integral to Cognizant's success. You will join a dynamic and expanding global leader in IT and Business consultancy where you will be valued for who you are. We take pride in our partnership with our clients, so your ability to add value and provide exceptional service to our clients is fundamental to your success. In return, you will be presented with opportunities to develop your career and collaborate with talented colleagues in a supportive, diverse environment.

At Cognizant we recognize that companies that are open and welcoming to a multi-culturally diverse workforce will thrive with fresh perspectives and collaborative knowledge. Cognizant focuses on promoting & increasing gender diversity and providing a workplace which encourages great participation and an equal playing field, where merit and accomplishment are the only criteria for success.

Role Summary:

We are looking for an experienced Data Modeler to design and develop scalable data models across modern data platforms. The role involves working closely with business stakeholders, data architects, and data engineering teams to build data foundations, analytical data marts, and business-ready data products.

The ideal candidate should have strong experience in data warehousing, dimensional modeling, data governance, and cloud-based analytics platforms.

Key Responsibilities:

• Design and maintain logical and physical data models.
• Define fact, dimension, and aggregate tables for reporting and analytics.
• Develop scalable data structures that support business intelligence and data-driven decision-making.
• Create and maintain source-to-target mapping documentation.
• Define business rules, data relationships, and transformation logic.
• Design data models across:
  • Raw Data Layer
  • Curated Data Layer
  • Business/Semantic Layer
• Build and optimize dimensional models using Kimball methodology.
• Ensure consistency, reusability, and performance of analytical datasets.
• Support development of enterprise data marts and data products.
• Establish data standards, naming conventions, and modeling best practices.
• Ensure data lineage, metadata, and data dictionary documentation are maintained.
• Collaborate with governance teams to ensure compliance with data policies.
• Support data quality and reconciliation activities.
• Work closely with business analysts and stakeholders to understand reporting requirements.
• Facilitate data modeling workshops and design reviews.
• Translate business requirements into scalable data solutions.
• Provide guidance to data engineers during implementation.

Required Skills:

• Logical, Physical Data Modeling & Dimensional Modeling (Kimball)
• Star Schema & Snowflake Schema
• Fact & Dimension Design
• Snowflake / Databricks / Azure / AWS (any cloud data platform)
• Data Pipelines and ETL/ELT Concepts
• Metadata Management , Data Lineage , Data Dictionary & Data Quality Frameworks