Data Architect and Data Engineer

Numerica Credit Union • Spokane Valley, WA

7h • $100,012 - $150,028

About The Position

The Data Architect / Data Engineer is a hands-on technical role combining data architecture and data engineering responsibilities. This position is responsible for designing, building, and maintaining scalable, reusable data structures and pipelines that support enterprise reporting and analytics. This role serves as a backup to the primary Data Engineer and has end-to-end accountability for data structures from conceptual design through physical implementation. A key near-term priority of this role is the design and implementation of a dimensional data model (star schema) with well-defined facts and conformed dimensions to support certified reporting and reuse across the organization. The role partners closely with the Business Intelligence (BI), Advanced Analytics, and Data Governance teams to ensure data assets are implemented consistently, accurately, and in alignment with enterprise standards. The role will also support evaluation and potential modernization of the data platform to a cloud-based data warehouse solution (e.g., Snowflake or similar).

Requirements

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, Mathematics, Statistics, or a related field.
• Five or more years of experience in data architecture and data engineering roles.
• Experience supporting enterprise data platforms in a regulated or data-sensitive environment.
• Experience in a credit union or community bank strongly preferred.
• Strong proficiency in SQL and relational databases (e.g., Oracle, SQL Server)
• Hands-on experience designing data models for analytical and reporting use cases
• Hands-on experience building dimensional modeling concepts (facts, dimensions, star schemas)
• Hands-on experience building and maintaining ETL/ELT pipelines
• Hands-on experience with data warehousing and analytical data architectures
• Experience with cloud-based data platforms (e.g., AWS, Azure)
• Strong analytical, problem-solving, and communication skills
• Strong communication skills and ability to work with cross-functional teams
• Strong experience with version control systems, particularly Git and GitHub
• Familiarity with code review processes and collaborative development workflows
• Experience implementing and enforcing coding standards within a team environment
• Ability to communicate complex technical concepts clearly and effectively in both written and verbal form to a variety of audiences, including technical teams, business stakeholders, and senior leadership.
• Ability to prepare clear documentation, analyses, and presentations that translate data architecture and engineering topics into business-relevant information.
• Ability to read, analyze, and interpret technical documentation, business publications, and applicable regulations, and to produce accurate reports, correspondence, and procedural documentation as required..
• Ability to establish trust and credibility with both technical and business partners through professionalism, diplomacy, and clear communication. Work involves frequent collaboration with individuals across the organization, including situations that may involve sensitive data, competing priorities, or differing perspectives.
• Must be able to effectively engage, influence, and collaborate with stakeholders to align technical solutions with business needs, and to foster productive working relationships with internal teams and external partners as necessary.
• Ability to operate all standard office machinery such as: computers, telephone, printers and projectors.
• Ability to lift up to 25 lbs.

Nice To Haves

• Experience in a community bank or credit union environment
• Master’s degree in a related field
• Familiarity with modern cloud data warehouses such as Snowflake or similar platforms
• Experience supporting analytics or data science teams
• Experience with financial industry data and regulatory considerations
• Experience with data modeling tools (e.g., ERwin, ER/Studio)
• Knowledge of machine learning concepts and their data requirements
• Experience with branching strategies (e.g., Git Flow, GitHub Flow) and their application in data engineering contexts
• Ability to mentor team members on version control best practices and efficient use of GitHub
• Experienced with financial institution accounting and finance terminology and standards as well as business processes

Responsibilities

• Design and maintain enterprise data models, including conceptual, logical, and physical models, with emphasis on dimensional modeling (star schemas) to support analytics and enterprise reporting.
• Define and maintain fact tables and conformed dimensions, including appropriate grain, keys, and modeling standards.
• Establish standardized, reusable data structures to ensure consistency across certified data assets.
• Ensure data architecture supports both current reporting needs and future scalability, including new data sources and analytical use cases.
• Maintain and evolve data models and architectural patterns in alignment with approved enterprise standards.
• Design, develop, and maintain ETL/ELT pipelines that integrate data from core systems and enterprise data sources into analytical and reporting platforms.
• Serve as a backup analytics data engineer for critical data pipelines and models, supporting shared ownership and continuity of operations.
• Monitor, optimize, and troubleshoot data pipelines and databases to ensure reliability, performance, and data accuracy.
• Support production issue resolution related to data availability, quality, and performance.
• Implement approved data quality, validation, and reconciliation controls to ensure accuracy and consistency of certified data assets.
• Partner with BI and Advanced Analytics teams to validate data requirements and ensure alignment with business definitions.
• Support audit, risk, and compliance activities by ensuring data assets are traceable, repeatable, and well-documented.
• Partner with the Data Governance team to implement approved data standards, definitions, and certification requirements within data models and pipelines.
• Ensure data structures align with enterprise data governance policies, including naming conventions, data domains, and data classification requirements.
• Support lineage and metadata capture through architectural design without owning governance tools, catalog administration, or stewardship workflows.
• Collaborate with BI, Advanced Analytics, and business teams to translate data and reporting requirements into scalable technical solutions.
• Participate in Agile delivery activities, including backlog refinement, design reviews, and iterative implementation.
• Communicate architectural designs, assumptions, and tradeoffs clearly to both technical and non-technical stakeholders.
• Follow established data architecture and engineering standards, patterns, and best practices.
• Use Git and GitHub for version control, code review, and collaboration
• Maintain clear technical documentation for data models, pipelines, and architectural decisions.
• Maintains knowledge and adheres to all BSA regulations and compliance standards on internal and external policies.
• Effectively incorporates CARES Principles in daily behaviors and interactions: Connect – Create meaningful relationships. Ask – Be intentionally curious. Resolve – Actively seek solutions. Elevate – Never stop improving. Strengthen – Be the difference.

Benefits

• Numerica Credit Union Benefits and Perks - Learn more about our Benefits and Perks here- https://www.numericacu.com/globalassets/images/pdfs/employee-benefits-summary-numerica.pdf

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level