Tagcor

Data Modeler Microsoft SQL Server Azure Data Warehouse

Design and develop data models for large-scale databases on the Azure platform, ensuring scalability, performance, and data integrity.
Collaborate with stakeholders, including data architects, developers, and business analysts, to understand data requirements and translate them into effective data models.
Optimize database structures and schemas to improve query performance and data retrieval efficiency.
Implement best practices for data modeling, including normalization, denormalization, indexing, and partitioning strategies.
Conduct data profiling and analysis to identify data quality issues and propose solutions for data cleansing and enrichment.
Work closely with the development team to ensure seamless integration of data models into application systems.
Perform data modeling reviews and provide guidance to ensure adherence to industry standards and best practices.
Stay up-to-date with the latest trends and advancements in data modeling techniques, tools, and technologies.
Collaborate with database administrators to monitor and optimize database performance, including query tuning and indexing strategies.
Document data models, data dictionaries, and related artifacts to facilitate knowledge sharing and maintain data lineage.
Monitor system performance by performing regular tests, troubleshooting, and integrating new features.
Guide and coach staff members on standards, guidelines, best practices, and adherence to set standards.