Note: The job is a remote job and is open to candidates in USA. FourLeaf Federal Credit Union is a financial services organization focused on providing strong member and employee experiences. The Solutions Architect – Data Engineering will design, build, and scale the enterprise data platform, leading architecture, ingestion, integration, governance, observability, cost optimization, analytics enablement, and AI/ML data infrastructure. The role combines strategic architecture with hands-on engineering and collaboration across business and technical teams.
Responsibilities
- Design and maintain an enterprise data platform that provides a unified, governed view of credit union operations across all domains
- Implement Bronze/Silver/Gold layer strategy with data contracts, transformation standards, and quality expectations
- Create and maintain enterprise data models for Member, Deposit, Transaction, Lending, Finance, Marketing, Digital, and Regulatory domains
- Define architectural patterns, modeling standards, naming conventions, and documentation practices
- Develop and maintain reference architectures and reusable design patterns for the broader EDAO team
- Lead the design of ingestion pipelines for 75+ systems of record including digital platforms, payment processors, lending systems, and third-party providers
- 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
- Define approaches for database connections, APIs, file transfers, and CDC-based ingestion
- Embed validation, profiling, and quality checks within ingestion workflows
- Lead mid-to-large data initiatives from requirements through deployment
- Translate complex business needs into technical specifications, data models, and implementation plans
- Build critical pipelines, transformations, and data products while setting engineering quality standards
- Serve as the expert problem solver for performance challenges, integration issues, and architectural decisions
- Work directly with business analysts, product owners, and subject matter experts to understand requirements and deliver solutions that meet business needs
- Design frameworks for monitoring data quality, freshness, pipeline reliability, and lineage
- Implement proactive alerts and incident-response processes
- Define, measure, and optimize SLAs for critical business processes
- Introduce automated testing, CI/CD pipelines, and environment management
- Develop runbooks and lead root-cause analysis for operational issues
- Implement Snowflake cost-management strategies including monitoring, warehouse optimization, and chargeback/showback models
- Optimize queries, warehouse sizing, and resource utilization to balance performance and cost
- Analyze consumption trends and identify optimization opportunities
- Partner with finance and IT to forecast and manage Snowflake spend
- Define and enforce development practices supporting cost-efficient usage
- Use AI tools to accelerate pipeline development, code generation, and documentation
- Leverage Cortex capabilities for data processing and enrichment
- Identify repetitive engineering tasks suitable for AI-driven automation
- Stay current on AI advancements relevant to data engineering and evaluate adoption opportunities
- Build and maintain a semantic layer with consistent business definitions, metrics, and data products
- Develop comprehensive member-centric data products that enable insights into behavior, engagement, and opportunities
- Deliver enterprise KPIs for Lending, Deposits, Digital, Branch Performance, and more
- Support NCUA, BSA/AML, GLBA, and other compliance requirements through curated data products
- Optimize models for consumption in Power BI and Sigma Computing
- Build the data infrastructure and feature stores required for predictive modeling (risk, churn, behavior, growth)
- Enable next-best-action and prescriptive decision-support pipelines
- Work with data scientists to operationalize models and ensure reliable data flows and monitoring
- Maintain secure, well-structured environments for experimentation and advanced analytics
Skills
- Bachelors Degree in Computer Science, Information Technology, or related field
- 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
- This position requires **at least one** of the certifications listed below
- 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)
- Bachelors Degree in Computer Science, Information Technology, or related field. Masters degree in Computer Science, Information Technology, or related field. is a plus
- 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
- Additional certifications are considered a plus
Benefits
- Medical, dental, and vision coverage
- Life and disability insurance
- Voluntary benefit programs
- A 401(k) plan with employer match
- Reimbursement and wellness programs
- An annual performance-based bonus
- 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
Company Overview