Job Description

Role description

We are seeking an experienced Data Modeler with 4 to 9 years of experience to join our team.



The ideal candidate will be responsible for designing implementing and supporting data structures that ensure data integrity and facilitate accurate timely information retrieval.



The Data Modeler will work closely with analysts architects and database developers to design datasets that align with business requirements and technical constraints.

Responsibilities

Design and implement data models to support business requirements ensuring consistency and integration across various data sources.



Develop and maintain conceptual logical and physical data models optimizing them for performance scalability and ease of use.



Collaborate with stakeholders to identify data requirements and translate them into technical specifications.



Ensure data models align with the organizations data architecture and data governance standards.



Design and implement data integration processes using ETL extract transform load tools and technologies ensuring data quality and completeness.



Work with database administrators to ensure database designs support business needs and are optimized for performance.



Maintain and update data dictionaries metadata repositories and data modeling documentation.



Troubleshoot and resolve issues related to data quality integration and model design.



Provide guidance and mentorship to junior team members as needed.



Stay current with industry best practices and emerging trends in data modeling and data architecture.

Requirements

2 to 5 years of experience in developing data pipelines and solutions using Azure Data Factory ADF Azure Synapse Analytics and Databricks



Strong proficiency in SQL TSQL and familiarity with Azure SQL Database andor Azure Synapse Analytics SQL pools



Experience with ADF pipeline orchestration and data ingestion from various sources such as databases APIs and file systems



Knowledge of Spark and Databricks for data processing transformations and data analytics



Familiarity with data modeling and schema design in Azure Synapse and Azure SQL Databases



Understanding of data integration data warehousing and ETL concepts



Proficiency in Azure cloud services and infrastructure particularly related to data processing and analytics



Strong problemsolving and troubleshooting skills

Qualifications

Bachelors degree in Computer Science Information Technology or a related field



4 to 9 years of experience in data modeling data architecture or related areas



Proficiency in data modeling tools such as ERStudio Erwin or similar



Strong understanding of relational databases data warehousing concepts and SQL



Experience with big data technologies and platforms Hadoop Spark NoSQL databases is a plus



Strong analytical problemsolving and communication skills



Ability to work collaboratively in a team environment and with crossfunctional stakeholders



Experience in AgileScrum development environments is advantageous

Skills

Mandatory Skills :

ERWIN,MS SQL Server,TOAD Data Modeler,Data Vault (ODS) Modeling,ANSI-SQL,Dimensional Data Modeling,ER Studio,Microsoft Fabric,GCP BigQuery,Redshift,Snowflake,Databricks,TOAD

About LTIMindtree

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by 83,000+ talented and entrepreneurial professionals across more than 40 countries, LTIMindtree -- a Larsen & Toubro Group company -- solves the most complex business challenges and delivers transformation at scale. For more information, please visit https://www.ltimindtree.com/. Please also note that neither LTIMindtree nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTIMindtree for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTIMindtree disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltimindtree.com/recruitment-fraud-alert/