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.
