Data Modeler

Job Description : We are seeking an experienced Data Modeler with 4-7 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 organization's 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-4 years of experience in developing data pipelines and solutions using Azure Data Factory (ADF), Azure Synapse Analytics, and Databricks

Strong proficiency in SQL, T-SQL, and familiarity with Azure SQL Database and / or 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 problem-solving and troubleshooting skills.

Qualifications :

Bachelor's degree in Computer Science, Information Technology, or a related field.

4-7 years of experience in data modeling, data architecture, or related areas.

Proficiency in data modeling tools such as ER / Studio, 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, problem-solving, and communication skills.

Ability to work collaboratively in a team environment and with cross-functional stakeholders.

Experience in Agile / Scrum development environments is advantageous.