Project Role : Custom Software Engineer
Project Role Description : Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.
Must have skills : Data Modeling Techniques and Methodologies, Data Governance, Snowflake Schema, Data Building Tool, RDBS, OLAP
Good to have skills : NA
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education
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)
15 years full time education
