FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in building and managing dbt models on Snowflake, utilizing medallion architecture for effective data governance and reporting. Proficient in SQL, CDC pipelines, and orchestration tools to ensure data quality and accessibility in a multi-tenant SaaS environment.
Highest-signal resume keywords
SQL FundamentalsSnowflake ExperienceProduction Experience With dbtCDC Pipelines And ELT ToolsPower BI Familiarity
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Dbt Model BuildingData Pipeline ManagementData TestingData DocumentationData ModelingData Freshness MonitoringQuery Performance TuningPython ScriptingOrchestration Tool KnowledgeMulti-Tenant SaaS Experience
Soft Skills
Strong CommunicationCollaborationProblem OwnershipAdaptabilityStakeholder Translation
Tools & Technologies
FivetranPower BIDbt CloudAirflowDagsterGitCI/CD
Industry Keywords
Medallion ArchitectureSemantic LayerStar SchemasSlowly Changing DimensionsData OntologyHealthcare Data PrivacyHIPAA Compliance
Tech Stack
Tools & technologiesAirflowCloudPythonSnowflakeSQL
About the role
Key responsibilities & impact- Own and extend dbt models on Snowflake using medallion architecture (bronze/silver/gold) patterns
- Manage CDC-based ingestion pipelines using Fivetran and similar tools, landing transactional data in Snowflake
- Evolve Snowflake and dbt models into a governed semantic layer for reporting and analytics
- Build reliable, tested gold-layer datasets for BI reporting and downstream AI/agentic workloads
- Apply star schemas and slowly changing dimensions to support multi-tenant SaaS reporting
- Collaborate with data operations, platform engineering, product teams, and other stakeholders
- Write dbt tests and documentation
- Monitor pipeline health and data freshness; build alerting for data issues
- Monitor Snowflake warehouse usage and query performance; tune models and warehouses
- Translate reporting requests from Product, Sales, and Customer Success into well-modeled data
- Support row-level security and data access design for multi-tenant customer data isolation
Requirements
What you’ll need- Strong SQL fundamentals and hands-on Snowflake experience
- Production experience with dbt; building, testing, and maintaining models at scale
- Experience with CDC pipelines and ELT tools like Fivetran
- Familiarity with Power BI, ideally including semantic model / measures work
- Understanding of medallion architecture and how gold-layer data supports both BI and AI use cases
- Experience working in a multi-tenant SaaS environment strongly preferred
- Comfortable with git-based version control and CI/CD for analytics code (dbt/SQL changes reviewed and deployed like software)
- Working knowledge of an orchestration tool (dbt Cloud, Airflow, Dagster, or similar) for scheduling and monitoring pipelines
- Python for scripting and automation around data workflows
- Strong communicator who can translate technical modeling decisions for non-technical stakeholders
- Comfortable in a lean team environment where you may own a problem end-to-end rather than a narrow slice of it
- Bonus: exposure to data ontology/semantic modeling for AI/agentic workloads
- Bonus: familiarity with healthcare data privacy considerations (e.g. HIPAA) given the clinical data our platform touches