Data Integration Analyst

The Data Integration Analyst is responsible for understanding documenting monitoring and improving how data moves among the credit unions 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 unions mission strategic goals and direction and core values. Employees must also provide service and support that is consistent with the Credit Unions 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.

• 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.