Solutions Architect - Data Engineering

It Starts With Our Employees

FourLeaf's ultimate goal is to provide the best-in-class member and employee experience, and it all begins with two things: hiring incredible people and giving them a great place to work.

What You’ll Do

The Solutions Architect – Data Engineering serves as the principal technical architect and hands-on engineer responsible for designing, building, and scaling FourLeaf's enterprise data platform. This role bridges strategic vision with technical execution, translating business requirements into robust, scalable data solutions that power analytics, AI, and operational decision-making across the organization. 

This position is open to flexible work options including a remote set up. 

Core Contributions

• Enterprise Data Architecture
  • End‑to‑End Architecture Ownership: Design and maintain an enterprise data platform that provides a unified, governed view of credit union operations across all domains.
  • Medallion Architecture: Implement Bronze/Silver/Gold layer strategy with data contracts, transformation standards, and quality expectations.
  • Domain Data Modeling: Create and maintain enterprise data models for Member, Deposit, Transaction, Lending, Finance, Marketing, Digital, and Regulatory domains.
  • Governance & Standards: Define architectural patterns, modeling standards, naming conventions, and documentation practices.
  • Reference Architecture: Develop and maintain reference architectures and reusable design patterns for the broader EDAO team.
• Data Ingestion & Integration
  • Pipeline Strategy & Implementation: Lead the design of ingestion pipelines for 75+ systems of record including digital platforms, payment processors, lending systems, and third‑party providers.
  • Matillion Framework Development:
    • Build reusable ETL/ELT patterns, templates, and parameterized components.
    • Standardize batch, near‑real‑time, and streaming ingestion methods.
    • Implement error handling, retry logic, and alerting frameworks.
  • Integration Patterns: Define approaches for database connections, APIs, file transfers, and CDC‑based ingestion.
  • Quality at Source: Embed validation, profiling, and quality checks within ingestion workflows.
• Solution Architecture & Hands‑On Engineering
  • End-to-End Project Delivery: Lead mid‑to‑large data initiatives from requirements through deployment.
  • Technical Solution Design: Translate complex business needs into technical specifications, data models, and implementation plans.
  • Hands‑On Delivery: Build critical pipelines, transformations, and data products while setting engineering quality standards.
  • Technical Problem-Solving: Serve as the expert problem solver for performance challenges, integration issues, and architectural decisions.
  • Stakeholder Collaboration: Work directly with business analysts, product owners, and subject matter experts to understand requirements and deliver solutions that meet business needs.
• DataOps & Observability
  • End‑to‑End Observability: Design frameworks for monitoring data quality, freshness, pipeline reliability, and lineage.
  • Monitoring and Alerting: Implement proactive alerts and incident‑response processes.
  • SLA & Reliability Management: Define, measure, and optimize SLAs for critical business processes.
  • Operational Excellence: Introduce automated testing, CI/CD pipelines, and environment management.
  • Incident Management: Develop runbooks and lead root‑cause analysis for operational issues.
• Snowflake FinOps & Cost Optimization
  • Cost Governance: Implement Snowflake cost‑management strategies including monitoring, warehouse optimization, and chargeback/showback models.
  • Performance Optimization: Optimize queries, warehouse sizing, and resource utilization to balance performance and cost.
  • Usage Analytics: Analyze consumption trends and identify optimization opportunities.
  • Budget Management: Partner with finance and IT to forecast and manage Snowflake spend.
  • Standards Enforcement: Define and enforce development practices supporting cost‑efficient usage.
• AI‑Accelerated Development
  • AI‑Assisted Engineering: Use AI tools to accelerate pipeline development, code generation, and documentation.
  • Snowflake Cortex Integration: Leverage Cortex capabilities for data processing and enrichment.
  • Automation Strategy: Identify repetitive engineering tasks suitable for AI‑driven automation.
  • Innovation Leadership: Stay current on AI advancements relevant to data engineering and evaluate adoption opportunities.
• Semantic Layer & Analytics Enablement
  • Semantic Architecture: Build and maintain a semantic layer with consistent business definitions, metrics, and data products.
  • Member 360: Develop comprehensive member‑centric data products that enable insights into behavior, engagement, and opportunities.
  • Standardized Metrics: Deliver enterprise KPIs for Lending, Deposits, Digital, Branch Performance, and more.
  • Regulatory Analytics: Support NCUA, BSA/AML, GLBA, and other compliance requirements through curated data products.
  • BI Integration: Optimize models for consumption in Power BI and Sigma Computing.
• Advanced Analytics & ML Support
  • Predictive Analytics Infrastructure: Build the data infrastructure and feature stores required for predictive modeling (risk, churn, behavior, growth).
  • Prescriptive Analytics: Enable next‑best‑action and prescriptive decision‑support pipelines.
  • MLOps Collaboration: Work with data scientists to operationalize models and ensure reliable data flows and monitoring.
  • Analytics Sandbox: Maintain secure, well‑structured environments for experimentation and advanced analytics.

Assets You Will Bring

• Bachelors Degree in Computer Science, Information Technology, or related field. Masters degree in Computer Science, Information Technology, or related field. is a plus.
• 15+ years of progressive experience in data engineering, data architecture, database development, and enterprise analytics with experience in solution architecture and technical leadership roles with demonstrated ownership of enterprise-scale data platforms.
• Hands-on experience with cloud data platforms (Snowflake required; additional cloud DW experience valued). Experience with modern ETL/ELT tools, with Matillion expertise strongly preferred.
• Certifications:  This position requires at least one of the certifications listed below. Additional certifications are considered a plus
  • SnowPro Advanced: Architect and SnowPro Advanced: Data Engineer
  • Matillion Associate or Professional Certification
  • Databricks Certified Data Engineer Professional or Databricks Certified Machine Learning Professional
  • AWS Certified Data Analytics or Solutions Architect
• Computer Skills: Snowflake ecosystem (SnowSQL, SnowPipe, and Snowflake Data Sharing), SQL, Python, ETL tools, Data Visualization tools (Power BI, Sigma, and or Tableau), cloud platforms (AWS, Azure, or Google Cloud). Microsoft Office (Excel, Word, PowerPoint, Teams, Outlook).

The estimated salary for this role is $117,456.00 to $146,819.00 annually. (FourLeaf Federal Credit Union offers a comprehensive benefits package, including medical, dental, and vision coverage; life and disability insurance; voluntary benefit programs; a 401(k) plan with employer match; reimbursement and wellness programs; and an annual performance-based bonus.) In addition to the salary or hourly rate listed above there may be other compensation & benefits available.

#LI-Remote

What Sets Us Apart?

In addition to our comprehensive benefits, we invest in employee connection and well-being through:

• Competitive 401(k)
• Tuition and fitness reimbursement programs
• Flexible work options
• Volunteer opportunities
• Executive “Water Cooler Chats”
• Clubs, sports, and social events
• Food truck days

….and more!

Who is FourLeaf?

FourLeaf Federal Credit Union (FourLeaf) has been committed to the financial well-being of our members for over 80 years. Through our full range of competitive savings and loan products, you can trust us in every step of your financial journey. From applying for a credit card to closing on your mortgage to opening your child’s first savings account, FourLeaf is here to help you reach your financial goals.

We are proud to be an award-winning place to work! Some of our recent recognitions include Certified Great Place to Work 2024-2025, America’s Greatest Midsize Workplaces 2025, and Fortune’s Best Workplaces in Financial Services & Insurance 2024. 

As a credit union, our vision is to enrich the lives of our members, employees, and communities. Since 2002, we have been an integral community partner through our charitable giving and community development programs in New York and beyond.

Bachelor's in computer science or related field; 15+ years data engineering/architecture experience; Snowflake required, Matillion preferred; at least one listed certification; proficiency in SQL, Python, ETL tools, data visualization, cloud platforms, and Microsoft Office.

Key Responsibilities

• designing data architecture
• building data pipelines
• implementing data governance

Skills & Tools

Snowflake, SnowSQL, SnowPipe, Snowflake Data Sharing, Matillion, SQL, Python, Power BI, Sigma, Tableau, AWS, Azure, Google Cloud, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Teams, Microsoft Outlook

Job Details

• Category: Information Technology
• Seniority: Senior Level
• Commitment: Full Time
• Workplace: Remote — Bethpage, New York, United States
• Salary: USD 117,456 – 146,819 / year
• Languages: English

Benefits

• 401k matching
• Tuition reimbursement
• Retirement plan

About FourLeaf Federal Credit Union

A credit union committed to the financial well-being of its members for over 80 years. — Industry: Finance