Data Modeler

Senior Data Modeler

Onsite –5909 Omaha Avenue, Oak Park Heights MN

Contract

Exp- 12 years of Experience

Need a resource with Dimensional modelling & Semantic data modelling experience and Manufacturing Domain experience.

Certifications Required: Certified Data Management Professional (CDMP), Snowflake Certification, SQL Certification

Required Skills : Database and SQL, Pstf-SQL Tuning, Logical Data modelling, Data Modelling, Data Build Tool, Snowflake SQL, Physical Data Modelling

Job summary

• We are seeking a highly skilled Senior Data Modeler with 12 to 15 years of experience to join our team.
• The ideal candidate will have extensive expertise in SqlDBM Modeling tool, Dimension Modeling, SQL.
• Nice to have: DBT, DataVault, Performance optimization Pstf-SQL Tuning, Snowflake SQL, Database and SQL, Data Build Tool, Physical Data Modelling, and Logical Data Modelling.
• This role is based in our office and requires proficiency in English.

Responsibilities

• Lead the planning and execution of data-related projects, ensuring alignment with company goals.
• Oversee the optimization of Pstf-SQL queries to enhance database performance
• Provide expertise in Snowflake SQL to manage and analyze large datasets efficiently
• Develop and maintain robust database structures using advanced SQL techniques
• Utilize Data Build Tool to streamline data workflows and improve data quality.
• Implement Physical Data Modelling to create efficient and scalable database designs.
• Apply Logical Data Modelling to ensure data integrity and consistency across systems.
• Collaborate with cross-functional teams to gather requirements and deliver data solutions.
• Monitor and troubleshoot database performance issues to ensure optimal operation.
• Ensure compliance with data governance and security policies.
• Conduct regular reviews and updates of data models to adapt to changing business needs.
• Mentor and guide junior team members in best practices for data management.
• Report on project progress and outcomes to senior management.

Qualifications

• Possess a deep understanding of Pstf-SQL Tuning and its impact on database performance
• Demonstrate proficiency in Snowflake SQL for managing complex data environments
• Have extensive experience with Database and SQL for robust data management.
• Show expertise in using Data Build Tool for efficient data workflows.
• Exhibit strong skills in Physical Data Modelling for scalable database design
• Display proficiency in Logical Data Modelling for data integrity.
• Be fluent in English with excellent reading, writing, and speaking skills.
• Have a proven track record of managing data projects from inception to completion.
• Show ability to work effectively in a team-oriented environment.
• Demonstrate strong problem-solving skills and attention to detail.
• Be capable of mentoring and guiding junior team members.
• Have excellent communication skills for reporting and collaboration
• Be committed to continuous learning and staying updated with industry trends.