Senior Specialist - Data Engineering

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