Data Modeler

JOB SUMMARY:

This role is responsible for designing enterprise-wide data modeling standards - conceptual, logical & physical data models that power governed, performant, reusable data products on Snowflake. You'll turn business concepts/CDEs (Critical Data Elements) and analytics needs into star schemas, vault/3NF structures, and semantic definitions that are consistent, documented, and easy to use. Wired into our catalog, lineage, quality checks, and access controls.

ESSENTIAL FUNCTIONS:

• Gathers and analyzes data requirements and data flows to other systems.
• Transforming database requirements into logical data models.
• Developing physical data models to define the database structure.
• Optimizing database performance through efficient indexing and table relationships.
• Spotting trends; writing reports and recommendations for internal or external clients; data modeling
• Creating data architecture and logical/physical data models for databases and data warehouses.
• Designing, developing, implementing, and maintaining a data warehouse to integrate data from various sources/systems within an organization.
• Developing strategies for data acquisition, archive recovery, and database implementation. Managing data migrations/conversions and troubleshooting data processing issues.
• Applies advanced knowledge of job area typically obtained through advanced education and work experience.
• Working independently with limited supervision.
• Coaching and reviewing the work of fellow team members.

QUALIFICATIONS:

• 6+ years of data modeling experience across multiple RDBS, OLAP, Data Warehouse and Data Marts.
• 3+ years of experience modeling data lineage and translations between systems with different data schemas

• 2+ years of software development experience in Snowflake, DBT, Semantic views and Cortex AI.

•Use of JIRA in Agile development.

• Ability to set goals and work with little direction.
• Demonstrated critical thinking and analytical skills.
• Results Driven (Prioritizing, Taking Initiative, and Taking Ownership)
• Outstanding soft skills including communication, mentoring, conflict resolution, facilitation, leading by example, work ethic, and emotional intelligence
• Normal Office Working Conditions

•Bachelor's degree in computer science or related field (Information Systems, Mathematics, Software Engineering)