Overview
Design and implement scalable Snowflake data platform patterns that support analytics, governed consumption and AI-enabled use cases, partnering with data engineers, analytics teams, AI specialists, security, governance and business stakeholders.
What you'll do
- Design and evolve Snowflake architecture across ingestion, medallion layers, transformation, semantic and consumption patterns.
- Build reusable dimensional models, including star schemas, fact tables, conformed dimensions, surrogate keys, defined grain and slowly changing dimension (SCD) patterns.
- Develop governed semantic views and certified datasets that support consistent measures, business definitions and relationships across business intelligence (BI), analytics and AI consumption channels.
- Lead Snowflake-based dbt development, including project structure, model layering, reusable macros, tests, documentation, lineage, incremental models and deployment standards.
- Integrate dbt workflows with Git-based version control, code review, continuous integration and continuous delivery (CI/CD), release management and multi-developer collaboration.
- Design and operationalize Snowflake Cortex capabilities, including Cortex Agents, Cortex Analyst, semantic models, search services, natural-language analytics and agent skills.
- Apply security and governance controls, including role-based access controls (RBAC), row-access policies, masking policies, secure views, data classification and least-privilege access.
What you'll need
- 10+ years of experience in data engineering, analytics engineering, data architecture or AI-enabled data platforms using enterprise data warehouse technologies.
- 3+ years of experience designing and implementing Snowflake architecture in production environments, including workload isolation, warehouse sizing, performance tuning, observability, reliability and cost optimization.
- 8+ years of experience designing relational data warehouse models using dimensional modeling, star schemas, semantic layers and data-quality practices.
- 3+ years of experience developing dbt models in Snowflake, including testing, documentation, lineage, incremental processing, snapshots, SCD patterns and CI/CD integration.
- 2+ years of experience designing secure extract, load, transform (ELT), extract, transform, load (ETL) or data-consumption patterns across multiple source systems and user communities.
- 1+ year of experience with Snowflake Cortex or equivalent AI-assisted analytics capabilities grounded in governed enterprise data and Fiserv systems.
- Bachelor's degree or higher in Computer Science, Data Engineering, Information Systems, Engineering or a related field, or equivalent combination of education, related experience and/or military experience.
Nice to have
- SnowPro Core, SnowPro Advanced Architect, SnowPro Advanced Data Engineer or equivalent Snowflake credential.
- dbt Analytics Engineering certification or equivalent analytics engineering credential.
- Experience with Power BI, Sigma, enterprise semantic-model patterns or AI-enabled analytics platforms.
- Experience working in a large, regulated, multi-team enterprise environment.
Details
- Location line: Remote, Florida.
- This role is not eligible to be performed in Colorado, California, District of Columbia, Hawaii, Illinois, Massachusetts, Maryland, Minnesota, New Jersey, New York, Nevada, Rhode Island, Vermont, Virginia, Maine or Washington.
Read the full description and apply on the company’s own careers page.