What are the responsibilities and job description for the Senior Data Modeler @ Oak Park Heights MN position at Diverse Lynx?
Job title : Senior Data Modeler
Location : Oak Park Heights MN (Onsite)
Required Skills : Database and SQL,Pstf-SQL Tuning, Logical Data modelling, Data Modelling, Data Build Tool, Snowflake SQL, Physical Data Modelling
Job summary
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.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
