JobScans.in

Job description

Job Description - -------------- **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)