Lead Data Modeller
Lead Data Modeller
Posted on :
13-08-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Job Title: Lead Data Modeller
Experience: 8years
Location: Hyderabad/Bangalore
THE GIG
As a Lead Data Modeller you will:
Design and maintain conceptual logical and physical data models across key data domains
Collaborate with business analysts and business SMEs to understand business requirements and deliver data solutions aligning with organizational goals
Perform data profiling data analysis define and implement target state data model for OLTP and OLAP applications for global retail business
Design and implement Data Vault 2.0 and dimensional data models on Snowflake data platform.
Define source-to-target ETL mapping data dictionary data classification taxonomy data lineage and data catalogue
Optimize and maintain cloud-based data stores and databases e.g. Snowflake SQL Server Oracle and Azure Synapse for performance and cost-efficiency.
Support the implementation of data quality data security data privacy and governance practices standards and controls working closely with the data architects business SMEs and Data Governance Lead
Help assess and improve the quality traceability and integrity of data across systems
Stay updated on emerging technologies and best practices recommending improvements to existing processes and tools
THE STUFF THAT SETS YOU APART
Must-Have Experience:
8 - 10 years of experience in data modelling metadata management and database management systems
Strong experience in Entity-Relationship Dimensional (Star/Snowflake) and Data Vault 2.0 data modelling
Strong experience in SQL stored procedures functions data partitioning indexing and clustering
Strong experience in designing and building Data Lake Data Lakehouse Data-warehouse and Data Marts
Strong understanding on data integration and data migration approaches
Strong understanding of data quality data governance data lineage and metadata management
Good understanding of data mesh or data product-oriented framework
Ability to operate in fast-paced collaborative environments
Technical Skills:
Hands-on experience with data modelling tools such as Erwin ER/Studio Visual Paradigm Power Designer IBM Data Architect SQL DBM etc.
Hands-on experience in creating database schema table stored procedure and function objects
Understanding of file formats CSV JSON Apache Avro Parquet SQL and NoSQL databases
Familiarity with tools and frameworks likes of Snowflake Azure Synapse OneLake Apache Spark Python Hadoop Airflow and Atlan
Familiarity with cloud platforms (eg Azure AWS GCP) DevOps and CI/CD pipelines
Employment Type
Full-time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
