Data Modeler

Job Title: Senior Data ModelerPreferred Location Onsite 5909 Omaha Avenue, Oak Park Heights MNRequired Skills : Database and SQL, Pstf-SQL Tuning, Logical Data modelling, Data Modelling, Data Build Tool, Snowflake SQL, Physical Data ModellingJob summaryWe are seeking a highly skilled Senior Data Modeler with 11 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.ResponsibilitiesLead the planning and execution of data-related projects, ensuring alignment with company goals.Oversee the optimization of Pstf-SQL queries to enhance database performanceProvide expertise in Snowflake SQL to manage and analyze large datasets efficientlyDevelop and maintain robust database structures using advanced SQL techniquesUtilize 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.QualificationsPossess a deep understanding of Pstf-SQL Tuning and its impact on database performanceDemonstrate proficiency in Snowflake SQL for managing complex data environmentsHave 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 designDisplay 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 collaborationBe committed to continuous learning and staying updated with industry trends.Certifications Required : Certified Data Management Professional (CDMP), Snowflake Certification, SQL Certification