> Markdown version of [/jobs/ext/2557640-snowflake-data-architecture-insights-lead](https://www.wearedevelopers.com/jobs/ext/2557640-snowflake-data-architecture-insights-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Snowflake Data Architecture & Insights Lead - **Company:** Stearns Bank - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $150,000.0 - $180,000.0 - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Data Analysis, Microsoft Azure, Cloud Database, Cyber Security, Data Architecture, Data Governance, Data Warehousing, Power BI, SQL Databases, Data Streaming, Enterprise Data Management, Data Ingestion, Snowflake, Data Analytics, Data Management, Alteryx - **Published:** August 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=2c4e43c94acf7a81 ## About the Role * 8+ years in data architecture, engineering, or analytics. * Hands-on experience with Snowflake, Fivetran, dbt, SQL, and Power BI. * Experience building data warehouses from scratch. * Financial services industry experience. * Alteryx experience preferred. REQUIRED CERTIFICATIONS * Snowflake SnowPro Core Certification * Microsoft Power BI Data Analyst (PL-300) certification or equivalent experience PREFERRED CERTIFICATIONS * dbt Analytics Engineering Certification * Snowflake SnowPro Advanced (Architect or Data Engineer) * Alteryx Designer Core Certification * Cloud data engineering certification (Azure DP-203, AWS equivalent) * Data governance or data management certification (e.g., DAMA-CDMP) REQUIREMENTS * Occasionally lift and/or move up to 10 lbs. * Literacy in English. * Ability to sit for extended periods of time, twist, bend, sit, walk use hands to twist, handle or feel objects, tools, or controls, such as computer mouse, computer keyboard, calculator, stapler, telephone, staple puller, etc., reach with hands and arms, balance, stoop, kneel, talk, or hear. * Specific vision abilities required by the job include close vision, distance vision, peripheral vision, depth perception and the ability to adjust focus. ## Description Come see how we're doing business unusual and charting our own path to reimagine a more inclusive financial services and banking ecosystem for all., Stearns Bank is seeking a Data Architecture and Insights Lead to own the design, build, and evolution of the enterprise data platform and to unlock business value from data beyond traditional reporting. This role is responsible for the end-to-end data architecture and data flows across the organization, leveraging Snowflake, Fivetran, dbt, and Power BI, while also serving as the lead for data analysis, insight generation, and decision enablement. The role will move the organization from reporting what happened to understanding why it happened and what actions to take. This is a senior, hands-on role that combines technical architecture, analytics engineering, and business-facing insights within a regulated financial services environment., Enterprise Data Platform & Architecture Ownership * Own the enterprise data platform architecture, including source-to-target data flows, integration patterns, and analytical models. * Design, build, and manage the Snowflake-based enterprise data repository. * Define and enforce data architecture standards and best practices. * Maintain current and future-state data architecture documentation. Data Ingestion, Transformation & Modeling * Lead ingestion of enterprise data using Fivetran. * Design and maintain dbt transformation layers. * Ensure data quality, lineage, validation, and consistency. * Optimize pipelines for performance and scalability. Insights, Analytics & Decision Enablement * Analyze enterprise data to identify trends, drivers, risks, and opportunities. * Develop analytical models that support decision-making. * Partner with business leaders to define decision-oriented KPIs. * Support scenario and trend analysis. Reporting & Visualization * Design Power BI dashboards and executive scorecards. * Enable self-service analytics with governance. Data Governance & Security * Implement data governance, stewardship, and documentation. * Partner with Risk, Compliance, and Information Security. * Enforce role-based access and auditability. Leadership & Collaboration * Act as the enterprise data authority. * Translate data into actionable insights. * Mentor team members. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters)