Snowflake Data Architecture & Insights Lead

ADP, Inc.; United States; Remote; USD 150.000 - 180.000; Vollzeit

Benefits dieser Stelle

Employee Stock Ownership Plan & 401k

Healthcare (Medical, Dental, Vision)

12-week Paid Parental Leave

Family Care Reimbursement

PTO 13–23 days

11 Paid Holidays

Tuition Assistance

Zusammenfassung

Stearns Bank is seeking a Data Architecture and Insights Lead to own the design, build, and evolution of the enterprise data platform, leveraging Snowflake, Fivetran, dbt, and Power BI, while also serving as the lead for data analysis and decision enablement.

This senior, hands‑on role combines technical architecture, analytics engineering, and business‑facing insights within a regulated financial services environment.

Qualifikationen

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

Aufgaben

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

Kenntnisse

Snowflake

Fivetran

dbt

SQL

Power BI

Jobbeschreibung

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Snowflake Data Architecture & Insights Lead

Full Time Remote, US

Salary Range: $150,000.00 To $180,000.00 Annually

At Stearns Bank, we’re helping people, entrepreneurs, small businesses, and local communities nationwide reach their full financial potential. Sound like something you want to be a part of? If so, we’re currently looking for a Snowflake Data Architecture & Insights Lead. This is a Connected Mobile Work Environment.

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.

BENEFITS

Stearns Bank understands and respects that everyone is managing unique career, family, and wellness needs. That’s why we offer industry-leading benefits to employees to help them live healthy lives and bring their full selves to work every day. Benefits may vary for part‑time positions. Some of those benefits include:

Employee Stock Ownership Plan & 401k Plan

Healthcare (Medical, Dental, Vision, Telehealth, Life insurance)

12-week Paid Parental Leave and Medical Leave: With a cap of 20 weeks for eligible team members who qualify for both Medical and Parental Leave related to the birth of a child.

$5,000 Family Care Reimbursement: Childcare, Elder Care, Student Loan Debt, Pet expenses, Down Payment Assistance

PTO from 13 to 23 days depending on tenure. Cashout and Carryover options

10 Days Sick Time

11 Paid Holidays

2 Days Self Allowance Time

Tuition Assistance

For this position, we anticipate a salary range between $150,000 - $180,000.Final employment offers will be dependent upon the selected candidate’s relevant qualifications and experience.

JOB SUMMARY

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.

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.

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.
• 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.
• Act as the enterprise data authority.
• Mentor team members.

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.

REQUIRED CERTIFICATIONS

• Snowflake SnowPro Core Certification
• Microsoft Power BI Data Analyst (PL-300) certification or equivalent experience

PREFERRED CERTIFICATIONS

• Snowflake SnowPro Advanced (Architect or Data Engineer)
• Alteryx Designer Core Certification
• 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.

THE COMPANY

Founded in 1912, Stearns Financial Services Inc. (SFSI) is a $3.2 billion, independently owned financial institution with locations in Minnesota, Florida and Arizona, and over 35,000 small business customers nationwide. Specializing in affordable housing financing, USDA and SBA lending, and small business and equipment financing, Stearns Bank is regularly recognized as one of the country’s top‑performing banks and “Best Banks to Work For” by American Banker .

As a Star Tribune Top Workplaces award recipient and an award recipient of the Minnesota Business Magazine 100 Best Places to Work in Minnesota, Stearns takes pride in their team and holds their employees in extremely high regard. We offer a competitive salary and benefit package including our Employee Stock Ownership Program-one of the best long‑term incentive programs in the nation. To learn more about Stearns Bank, visit www.StearnsBank.com

EQUAL OPPORTUNITY EMPLOYER /AFFIRMATIVE ACTION PLAN

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, or creed, religion, sex, marital status, familial status, sexual orientation, national origin, age, disability, veteran’s status, status with regard to public assistance, or any other class protected by Federal, State, local laws governing nondiscrimination in employment.