Description

Role

The Data Architect will lead the strategic planning, design, and governance of data systems for the Bank. This includes defining architecture, designing models, establishing standards, and ensuring governance across the data landscape. The role involves leading the design, development, and implementation of robust data integration and transformation solutions in a Snowflake cloud data warehouse environment. This position is pivotal in shaping Capitol Federal's data infrastructure strategy, ensuring scalable and efficient data pipelines, and enabling high-quality analytics to meet reporting needs across the organization. The ideal candidate will have deep expertise in ETL/ELT design, data modeling, and Snowflake architecture, along with a strong understanding of modern data warehousing best practices. Collaboration with data engineers, analysts, and business stakeholders is essential to translate business requirements into data solutions that drive informed decision-making.

Essential Duties & Responsibilities

• Define data architecture and design data models.
• Establish and enforce data standards and governance policies.
• Oversee technology recommendations and architecture blueprints.
• Create and maintain documentation such as data flows and models.
• Support Business Analysts in gathering and defining requirements.
• Assist Data Engineers with development tasks when needed.
• Participate in meetings with business stakeholders to understand and translate requirements.
• Develop and optimize data models (star/snowflake schemas, normalized/denormalized structures) for efficient querying and storage in Snowflake.
• Develop and maintain data architecture documentation, data dictionaries, and source-to-target mappings.
• Design and implement scalable ETL/ELT pipelines using tools tailored for Snowflake.
• Ensure data quality, integrity, and security through robust validation processes, data governance, and access control mechanisms.
• Lead the migration of legacy data systems to modern Snowflake-based architecture.
• Collaborate with stakeholders to understand business requirements and translate them into technical solutions.
• Monitor and optimize Snowflake performance, including warehouse sizing, clustering, and query optimization.
• Establish best practices for data ingestion, transformation, and consumption within a cloud data platform.
• Provide mentorship and technical guidance to data engineers and developers.
• Performs other duties as assigned.
• Participate in proactive team efforts to achieve departmental and company goals.
• Must comply with current applicable laws, regulations and bank policies and procedures. Comply with all safety policies, practices and procedures. Report all unsafe activities to supervisor and/or Human Resources.

• 10+ years of software development and/or data engineering experience.
• 5+ years of experience in data architecture or data engineering roles with a focus on ETL/ELT development.
• Hands-on experience with Snowflake data warehouse, including performance tuning and optimization.
• Experience with SQL Server and Oracle database management systems.

Education

College degree required. Bachelor's or master's degree in Computer Science, Information Systems, or a related field preferred.

Physical Requirement

Perform primarily sedentary work with limited physical exertion and occasional lifting of up to 10 lbs. Must be capable of climbing / descending stairs in emergency situation. Must be able to operate routine office equipment including telephone, copier, facsimile, and calculator. Must be able to routinely perform work on computer for an average of 6-8 hours per day, when necessary. Must be able to work extended hours whenever required or requested by management.

Regular in-office attendance required.

Mental and/or Emotional Requirements

Must be able to perform job functions independently or with limited supervision and work effectively either on own or as part of a team. Must be able to complete complex mathematical calculations and spell accurately. Must be able to read and carry out various written instructions and follow oral instructions. Must be able to speak clearly and deliver information in a logical and understandable sequence. Must be capable of dealing calmly and professionally with numerous different personalities from diverse cultures at various levels within and outside of the organization and demonstrate highest levels of customer service and discretion when dealing with the public. Must be able to perform responsibilities with composure under the stress of deadlines / requirements for extreme accuracy and quality and/or fast pace. Must be able to effectively handle multiple, simultaneous, and changing priorities. Must be capable of exercising highest level of discretion on both internal and external confidential matters.

CapFed® is an equal opportunity employer.