Department: Organizational Data Management (ODM)
Report To: VP ODM
Grade: 14 Exempt
Salary: $100,012 to $150,028 annually
To limit AI generated applicants and support our candidate first recruiting experience, please know that only fully completed applications, including screener questions, will be considered for this position.
SUMMARY:
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).
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- 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.
SUPERVISORY RESPONSIBILITIES:
This position has no formal, direct supervisory responsibilities although will work with leaders and peers in the organization to drive results.
PERFORMANCE STANDARDS:
Data models and pipelines are scalable, reusable, and aligned with enterprise standards
Certified data assets are accurate, reconciled, and delivered within agreed timeframes
Data pipelines operate reliably with minimal business disruption
Demonstrates sound technical judgment, accountability, and collaboration
Contributes to the organization's mission statement and goals by providing the highest quality of service, treating each person professionally - with warmth, courtesy, and respect, and making a personal effort to make members feel they belong and are important to the credit union.
EDUCATION and/or EXPERIENCE:
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.
Preferred Qualifications:
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
CERTIFICATES, LICENSES, REGISTRATIONS:
No requirement.
SKILLS and ABILITIES:
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.
The job description doesn’t imply an employment contract, nor is it intended to include every duty, task or instruction for which the employee is responsible. Other tasks may be assigned, based on business need and at Management’s request.
Numerica Credit Union is an Equal Opportunity/Affirmative Action Employer
Numerica Credit Union provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation for purposes of participating in the application/hiring process with Numerica Credit Union. If you are unable or limited in your ability to use or access Numerica Credit Union’s career page at www.numericacu.com as a result of your disability, you can request reasonable accommodations by reaching out to your recruiter.
Numerica Credit Union Benefits and Perks -