Designs and maintains enterprise data models and architectures using Bronze, Silver, and Gold patterns. Establishes data governance with Microsoft Purview, Collibra, and Unity Catalog; develops relational, bridge, link, business key, and surrogate key models; applies Data Vault 2.0; documents schemas in Erwin or ER Studio; optimizes SQL and supports Azure Databricks data platforms while collaborating with business and technical teams.
Data Modeller
Summary
We are seeking an experienced Data Modeller to design, implement, and maintain robust data architectures within the IT Services sector. This pivotal role involves translating complex business requirements into precise data models that support scalable analytics and governance initiatives. The successful candidate will leverage advanced modeling techniques and industry-leading tools to optimize data flow, ensure data integrity, and facilitate seamless integration across enterprise systems. This position is critical for driving data strategy, enabling high-performance data platforms, and ensuring compliance with organizational standards in a dynamic technology environment.
Responsibilities
- Design and develop comprehensive logical and physical data models utilizing Bronze, Silver, and Gold architecture principles to support advanced analytics.
- Implement and manage enterprise data governance frameworks using tools such as Microsoft Purview, Collibra, and Unity Catalog to ensure data quality and regulatory adherence.
- Construct complex data structures, including Many-to-Many, Bridge, and Link models, to accurately represent intricate business relationships and hierarchies.
- Define and enforce standards for Business Keys and Surrogate Keys to maintain referential integrity across diverse data sources.
- Utilize industry-standard modeling software like Erwin and ER Studio to create detailed documentation and visual representations of data schemas.
- Apply Data Vault 2.0 methodology to build flexible, scalable, and auditable data warehouses capable of handling historical data changes.
- Write and optimize complex SQL queries to validate data models, perform data transformations, and support backend processing within Azure Databricks environments.
- Collaborate with cross-functional teams to align data architecture with business objectives and technical requirements.
Requirements
Requirements:
- Minimum of 12 to 15 years of professional experience in data modeling, data architecture, or related IT services domains.
- Proven expertise in modern data architecture patterns, specifically the Bronze/Silver/Gold layering approach.
- Hands-on proficiency with data governance and cataloging platforms, including Unity Catalog, Microsoft Purview, and Collibra.
- Deep understanding of advanced relational modeling concepts, such as Many-to-Many relationships, Bridge tables, and Link tables.
- Strong command of key management strategies, including the implementation of Business Keys and Surrogate Keys.
- Extensive experience with professional data modeling tools, specifically Erwin or ER Studio.
- Demonstrated ability to apply Data Vault 2.0 design principles in enterprise-scale projects.
- Advanced proficiency in SQL for data manipulation, validation, and optimization.
- Practical experience working with cloud-based data platforms, particularly Azure Databricks.
Similar Jobs
Artificial Intelligence • Consulting
The Data Modeller will design data models, conduct reviews, collaborate with data teams, and maintain industry knowledge to enhance systems.
Top Skills:
Aws Cloud (VpcAws RedshiftDatabricks SparkDelta TechnologiesDmsEc2ErwinGlue)Graph DbInformatica EtlOracle DatabaseOracle SqlPl/SqlS3
Digital Media • Information Technology • News + Entertainment
Develop and maintain automated and functional tests for ServiceNow workflows, APIs, user interfaces, integrations, and enterprise applications. Build ATF suites, Bruno or Playwright API tests, and regression coverage; execute smoke, sanity, regression, and end-to-end validation. Support defect triage, root-cause analysis, release readiness, pipeline troubleshooting, documentation, and collaboration with developers, architects, product owners, and QA teams.
Top Skills:
Api TestingBrunoPlaywrightServicenowServicenow Atf
Digital Media • Information Technology • News + Entertainment
Designs, implements, and maintains secure enterprise and data center network infrastructure. Responsibilities include firewall management, F5 load balancing, routing and switching, network security architecture, incident response, monitoring, troubleshooting, compliance documentation, stakeholder collaboration, and automation using Python, Ansible, Git, and APIs. The role supports high-availability and disaster recovery environments, manages complex security incidents, and mentors junior engineers.
Top Skills:
AnsibleBgpF5 Big-IpF5 DnsF5 GtmF5 LtmFortinetGitHsrpIgmpLacpMlagMulticastOspfPalo Alto FirewallsPimPort-ChannelPythonRest ApisStpVpcVrfVrrp
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
