Mocse Credit Union · 3 hours ago
DATA ARCHITECT
Coffee Road - MODESTO, CA 95355
Full-time
Onsite
Mid Level
$38.39/hr - $47.99/hr
3+ years expMocse Credit Union is seeking a Data Architect to transform their data into a strategic asset. The role involves establishing automated reporting capabilities, building data governance foundations, and developing advanced analytics to drive continuous improvement and optimization within the organization.
BankingCustomer ServiceFinancial Services
Responsibilities
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
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
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
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
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
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
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
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
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
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
Qualification
Required
Bachelor's degree in a quantitative field - Business Information Systems, Computer Science, Data Analytics, Statistics, Finance, Mathematics, Engineering, or related field
Minimum 3-5 years of hands-on experience in business intelligence, data analytics, or reporting roles
Proven track record of delivering automated reporting solutions and building analytics capabilities
Demonstrated experience working with multiple data sources and integrating disparate systems
Must be bondable
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 data pipelines
Advanced Excel proficiency - Pivot tables, advanced formulas, macros, Power Query
Data visualization mastery - Ability to create compelling, intuitive dashboards and reports for diverse audiences
Relational database understanding - Strong grasp of database design, normalization, and data modeling principles
Artificial intelligence – Ability to utilize AI comfortably to assist with Mocse's strategic initiatives
Self-starter mentality - Ability to work independently with minimal supervision and take ownership of deliverables
Excellent communication skills - Written, oral, and presentation abilities to communicate complex data insights to non-technical stakeholders
Analytical and problem-solving skills - Ability to identify root causes, spot trends, and recommend actionable solutions
Project management capability - Strong organizational skills, ability to prioritize competing demands, and deliver results
Attention to detail - Work accurately with close attention to data quality and report accuracy
Adaptability and experimentation mindset - Comfortable with ambiguity, excited by experimentation, and able to pivot quickly based on business needs
Collaboration - Ability to build relationships across departments and influence without authority
Ethical conduct - Demonstrates highest level of integrity when handling confidential member and business data
Initiative and continuous improvement orientation - Takes proactive action, anticipates needs, and continuously seeks optimization opportunities
Ability to maintain confidentiality of sensitive member and business information
Professional demeanor - Exhibits a professional, businesslike appearance and approach
Preferred
Experience with Python, R, or SAS for statistical analysis and predictive modeling
Familiarity with cloud-based analytics platforms (AWS, Azure, Snowflake, or similar)
Knowledge of ETL/ELT processes and tools
Understanding of data governance frameworks and master data management
Experience with machine learning and predictive analytics
Financial services experience - Credit union or banking background
Data governance experience - Participation in data quality, documentation, or governance initiatives
Cloud analytics platform experience - Modern BI and cloud data warehouse implementations
Predictive analytics experience - Building and deploying machine learning models
Professional certifications - Microsoft Certified Data Analyst, Tableau Desktop Specialist, or similar
Company
Mocse Credit Union
A central valley refuge from cold, impersonal banking. Don't bank boring, bank with Mocse!
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase