Data Architect

Position: DATA ARCHITECT
POSITION PURPOSE The Data Architect is a critical founding role responsible for transforming Mocse's data from a fragmented resource into a strategic asset. This role will establish automated reporting capabilities, build data governance foundations, develop advanced analytics, and drive continuous experimentation and optimization. This is a high-impact, high-visibility position reporting to the Vice President of Performance and Risk and working closely with executive leadership to make Mocse a truly data-driven organization.

ESSENTIAL JOB FUNCTIONS Data Access & Reporting Automated Reporting & Analytics Design, develop, and automate reports that deliver critical information to operational groups and provide analytics and KPIs for leadership

Reduce report turnaround times and enable self-service access to data Create and maintain dashboards for executives, department heads, and business users

Establish refresh schedules and monitoring procedures for all reporting

Migrate and optimize reports as systems and platforms evolve

Data Integration & Management Integrate disparate data sources across multiple database platforms (core banking, lending platform, digital platform, card systems)
Create direct connections to source systems and build automated data pipelines

Design standardized data models for member, account, and transaction entities

Determine appropriate software tools based on assignment goals

Document all transformations, data lineage, and business rules

Data Governance & Quality Data Documentation & Governance Catalog and document data sources, definitions, and business rules across all systems

Assess and monitor data quality; identify and resolve data issues

Support the Data Governance Council and implement governance policies

Develop and maintain data classification schema and access control principles

Ensure compliance with NCUA, FFIEC, CCPA, GLBA, and Right to Financial Privacy Act requirements

Draft and maintain documentation of procedures for generating reports and accessing data Advanced Analytics & Insights Strategic Analysis & Predictive Analytics Research and analyze data trends to identify areas of opportunity and inform strategic decision-making

Develop predictive models for member churn, loan default risk, fraud detection, and lifetime value

Create member segmentation and personalization analytics for targeted marketing

Build operational intelligence including anomaly detection, process optimization, and forecasting

Perform demographic and geographic analysis to contribute to operations and marketing planning

Risk Management & Fraud Analytics Develop real-time fraud monitoring dashboards and transaction anomaly detection

Create member risk segmentation and geographic risk analysis

Support compliance reporting and audit requirements

Monitor data security and privacy controls

Member Experience Analytics Build 360-degree member views combining all product relationships

Develop member journey analytics across channels

Create churn prediction and early warning indicators

Analyze product affinity and identify cross-sell opportunities

Track member satisfaction, NPS, and experience metrics

Operational Efficiency Analytics Measure process cycle times (loan approval, account opening, etc.)Analyze channel utilization and cost per transaction

Track employee productivity metrics and branch performance

Monitor system performance and data quality dashboards

Stakeholder Collaboration & Communication Business Partnership & Requirements Gathering Work directly with stakeholders to identify analytical needs

Translate business problems into data solutions

Regularly update stakeholders on progress and recommend improvements

Synthesize, visualize, and communicate complex information to diverse audiences

Assist teams with targeting and campaign analytics

Continuous Improvement & Innovation Platform Optimization & Experimentation Continuously optimize analytics platform performance and cost efficiency

Experiment with new analytical techniques, tools, and methodologies

Expand data integration and real-time capabilities as business needs evolve

Develop APIs for data access by applications

Stay current on BI tools, analytics best practices, and industry trends

Professional Development & Collaboration Enhance job performance by applying up-to-date professional and technical knowledge gained through training, publications, and professional relationships

Participate in committee, community, and group projects as assigned

Mentor others and build data literacy across the organization

Contribute to attaining Credit Union objectives by accomplishing related results as assigned.

KNOWLEDGE, SKILLS, AND ABILITIES

REQUIRED:

Technical Expertise (Must-Have)
Advanced SQL proficiency
- Ability to write complex queries, optimize performance, and work across multiple database platforms BI tool expertise
- Hands-on experience with modern BI platforms (Power BI, Tableau, Looker, or similar)
Data integration skills
- Proven ability to connect disparate data sources and build automated…