Build and maintain Snowflake and dbt data models using medallion architecture, CDC ingestion, star schemas, and slowly changing dimensions. Develop governed semantic datasets for BI and AI workloads, implement testing, documentation, monitoring, alerting, row-level security, and performance tuning. Partner with product and business stakeholders to translate reporting needs into reliable multi-tenant SaaS data solutions.
Aline is building the resident lifecycle platform for senior living: one record that follows every resident from first inquiry through end of life. As part of our Data Platform team, you will build the data foundation behind that vision, giving operators a canonical, reliable record of their residents and communities. This is not just about better dashboards. The models you build become the ground truth that AI agents reason over, the layer that will one day flag a resident at risk, recommend the next best action, and act on it, not just report on it after the fact. You are building the foundation that both humans and agents will rely on to drive better care, retention, and outcomes.
What You'll Do- Own and extend our dbt models on Snowflake, following medallion architecture (bronze/silver/gold) patterns
- Manage CDC-based ingestion pipelines (Fivetran and similar tools) landing data from transactional systems into Snowflake
- Broaden Snowflake and dbt models to become the semantic layer for our reporting and analytics, evolving existing logic out of point tools like Power BI and into a single, governed source of truth
- Build reliable, well-tested gold-layer datasets that support BI reporting and downstream AI/agentic workloads
- Apply data modeling best practices (star schemas, SCDs) to support multi-tenant SaaS reporting needs
- Collaborate cross-functionally with data operations, platform engineering, product teams and others
- Write dbt tests and documentation so models are trustworthy and self-explanatory for downstream consumers
- Monitor pipeline health and data freshness, and build alerting so issues surface before they reach a report or dashboard
- Keep an eye on Snowflake warehouse usage and query performance, and tune models/warehouses as the data volume grows
- Work directly with stakeholders in Product, Sales, and Customer Success to turn reporting requests into well-modeled data
- Support row-level security and data access design so multi-tenant customer data stays properly isolated
- 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
Similar Jobs
Edtech
Own the architecture, technical direction, reliability, and evolution of a shared cloud data platform. Lead hands-on development of streaming and batch pipelines using infrastructure-as-code, build governed analytical data products, and establish data contracts, quality, security, lineage, and observability standards. Serve as the final technical escalation point, mentor engineers, lead design and code reviews, promote responsible AI-assisted coding, respond to incidents, and communicate technical tradeoffs across stakeholders.
Top Skills:
Amazon AthenaAmazon CloudwatchAmazon DynamodbAmazon EmrAmazon EventbridgeAmazon KinesisAmazon RedshiftAmazon S3Amazon SagemakerAmazon SnsAmazon SqsApache FlinkAws CdkAws GlueAws LambdaDuckdbGrafanaInfluxdbJavaScriptKinesis Data FirehoseTypescript
Artificial Intelligence • eCommerce • Fintech • Payments • Retail • Software • Analytics
Sell Scotch’s POS and operating system—including hardware, software, payments, and e-commerce—to liquor store owners. Manage inbound and outbound sales activity, educate SMB buyers on operational and profit benefits, meet sales targets, and collaborate with onboarding and support teams to ensure successful merchant transitions. The role requires Michigan residency and experience in SMB technology sales, beverage alcohol, or retail liquor.
Top Skills:
E-CommerceInventory ManagementPayment ProcessingPosReporting SoftwareSales Enablement Tools
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Leads architecture and scaling of Block’s finance technology stack across Oracle Fusion, accounting, tax, treasury, procurement, and FP&A. Designs financial data models, builds SQL/PL/SQL and REST/SOAP integrations, automates workflows, and translates accounting requirements into scalable technical solutions. Partners with finance, product, data engineering, and integration teams while applying AI-assisted development to improve delivery speed and financial operations.
Top Skills:
ClaudeCursorData LakesEnterprise LlmsFccsGithub CopilotGoJavaJSONOracle BipOracle FahOracle FusionOracle GlOracle SlaPl/SqlPythonRelational DatabasesRestSoapSQLXML
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
