Snowflake Data Architect & Insights Leader

Stearns Bank N.A.; United States; On-site; USD 150,000 - 180,000; Full time

Benefits offered by this job

Employee Stock Ownership Plan & 401k

Healthcare (Medical, Dental, Vision)

Parental Leave

Family Care Reimbursement

PTO 13-23 days

Sick Time 10 days

11 Holidays

Self Allowance Time

Tuition Assistance

Job summary

Stearns Bank is seeking a Snowflake Data Architecture & Insights Lead to own the design, build, and evolution of the enterprise data platform, leveraging Snowflake, Fivetran, dbt, and Power BI. This senior, hands-on role combines technical architecture, analytics engineering, and business-facing insights within a regulated financial services environment.

The role will move the organization from reporting what happened to understanding why it happened and what actions to take, partnering with

Qualifications

• 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.

Responsibilities

• 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.
• 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.
• 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.
• Design Power BI dashboards and executive scorecards.
• Enable self-service analytics with governance.
• Implement data governance, stewardship, and documentation.
• Partner with Risk, Compliance, and Information Security.
• Enforce role-based access and auditability.
• Act as the enterprise data authority.
• Mentor team members.

Tools

Snowflake

Fivetran

dbt

SQL

Power BI

Job description

Stearns Bank is seeking a Snowflake Data Architecture & Insights Lead to own the design, build, and evolution of the enterprise data platform, leveraging Snowflake, Fivetran, dbt, and Power BI. This senior, hands-on role combines technical architecture, analytics engineering, and business-facing insights within a regulated financial services environment.

The role will move the organization from reporting what happened to understanding why it happened and what actions to take, partnering with