Data Integration Analyst

Description

The Data Integration Analyst is responsible for understanding, documenting, monitoring, and improving how data moves among the credit union’s core processing platform, loan origination and processing systems, digital platforms, ancillary applications, vendors, and reporting solutions. The position develops and maintains data extracts, interfaces, reconciliations, reporting datasets, and operational reports so information is complete, accurate, timely, secure, and usable. The role works side by side with Core Applications, Information Technology, Digital Transformation, Finance, Risk, and business departments, and provides assigned backup support for core application and data-processing functions.

All employees are expected to actively support the credit union’s mission, strategic goals and direction, and core values. Employees must also provide service and support that is consistent with the Credit Union’s commitment to meeting member needs, resolving problems, and providing financial solutions. Perform daily work from the perspective of serving the member.

Competency: Data & Systems Integration (35%)

• Map and document end-to-end data flows among source applications, middleware, file-transfer processes, application programming interfaces, the core processing system, data repositories, business intelligence tools, and downstream reporting systems.
• Develop and maintain data lineage documentation, interface inventories, field mappings, data dictionaries, report catalogs, file specifications, schedules, dependencies, owners, controls, and support procedures.
• Create, maintain, and monitor data extracts, imports, exports, interfaces, queries, scheduled reports, and automation routines for assigned applications.
• Participate in system implementations, conversions, upgrades, patches, releases, and vendor integrations. Prepare test plans and test data, execute interface and regression testing, document results, and support production validation.

Competency: Data Quality & Analytical Reporting (30%)

• Validate and reconcile data as it moves between systems. Investigate missing, duplicated, rejected, delayed, or inconsistent records and coordinate correction with internal stakeholders and vendors.
• Establish and maintain control totals, exception reporting, balancing procedures, data-quality checks, and documented evidence for critical data transfers and recurring reports.
• Provide timely, relevant, accurate, and user-friendly operational, financial, regulatory, and management reporting from approved data sources.
• Work with business areas to define reporting requirements, calculations, key metrics, source systems, data ownership, refresh frequency, access needs, and acceptance criteria.
• Review and audit scheduled and ad hoc reports for accuracy, consistency, clarity, timeliness, and appropriate presentation. Resolve discrepancies before information is distributed when practical.

Competency: Operational Reliability & Risk Stewardship (20%)

• Maintain change management records for report logic, interfaces, mappings, automation routines, data structures, schedules, and production deployments.
• Monitor production jobs and interface failures for assigned processes. Document incidents, assess business impact, escalate when appropriate, coordinate resolution, and verify successful recovery.
• Support information security, privilege access, confidentiality, data retention, secure file transfer, vendor management, and audit requirements applicable to assigned data and applications.
• Serve as an assigned backup for selected Core Applications Specialist responsibilities, including application monitoring, service-desk support, vendor follow-up, testing, and routine processing. 
• Assist internal and external auditors, examiners, and management by providing data, system documentation, control evidence, and explanations for assigned processes.
• Advise management of unusual events, control weaknesses, recurring failures, data-quality concerns, or improvement opportunities that affect the Credit Union.
• Participate in disaster recovery and business continuity testing for assigned applications, interfaces, reports, and data processes.

Competency: Service-Oriented Collaboration & Continuous Improvement (15%)

• Partner with Core Applications Specialists on core monitoring, incident and problem tracking, application support, database refreshes, vendor cases, release testing, change management, and post-implementation support.
• Partner with the Program Manager - Digital Transformation and business teams to identify data requirements, measure results, perform gap analysis, test integrated solutions, and support digital initiatives.
• Assist with root cause analysis for data, application, and reporting issues. Recommend controls, process changes, automation, or system improvements that reduce operational risk and manual effort.
• Cross-train other team members on assigned interfaces, reports, controls, and procedures. Maintain current documentation so another qualified employee can perform critical processes.
• Participate in special projects and perform other duties as assigned.

Requirements

• Equivalent to a four-year high school education or general education degree (GED).  
• A minimum of three years of related experience in data integration, reporting, business intelligence, application support, systems analysis, or financial institution operations preferred.
• Experience with a credit union or bank core processing platform, loan origination or processing system, digital banking platform, is preferred.
• Working knowledge of relational databases, data structures, file layouts, interfaces, secure file transfer, APIs, ETL or similar integration concepts, data validation, and reconciliation controls.
• Proficiency in Microsoft Excel required. Experience with SQL and reporting or business intelligence tools required. 
• Experience with automation, scripting, or data-preparation tools is preferred.
• Ability to read technical documentation, translate business requirements into data and reporting requirements, and explain technical issues in clear business terms.
• Ability to define problems, collect and evaluate data, establish facts, identify root causes, draw valid conclusions, and recommend practical resolutions.
• Ability to manage recurring production responsibilities and multiple projects in a deadline-driven environment without losing control of documentation, testing, or follow-up.
• Working knowledge of change management, incident management, test management, access controls, data governance, and vendor support practices preferred.
• Professional written, verbal, and interpersonal skills. Proven ability to work effectively with technical staff, business users, management, vendors, auditors, and examiners.
• Requires sound and accurate judgment. Ability to independently make and act upon decisions within assigned authority that support department and Credit Union goals, objectives, policies, and risk tolerances.