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.