Data Integration & Reporting Officer
Beacon Bank · Pittsfield, MA · 2 wk ago
Finance$96k–$177k/yrFull-time
Principal Objective
The Data Integration & Reporting Officer is responsible for enterprise data integration, data standardization, and trusted analytics capabilities across the organization.
Key Accountabilities
- Enterprise Data Integration, Standardization & Quality
- Lead integration and standardization of data from multiple source systems into the enterprise data platform, including Snowflake.
- Direct onboarding of historical and legacy data sources, including Jack Henry / jhaKnow, into governed reporting environments.
- Oversee resolution of data variances impacting management reporting, operational reporting, or analytics.
- Promote consistent, trusted, and scalable data assets across the organization.
- Data Transformation & Reporting Architecture
- Lead design and governance of SQL views, curated datasets, and reporting structures that convert raw data into usable business information.
- Ensure reporting structures align to key business dimensions such as region, officer, product, department, relationship, and customer.
- Improve consistency, usability, and performance of enterprise reporting assets.
- Define standards for approved and controlled reporting datasets.
- Data Conversion & Strategic Change Initiatives
- Lead conversion of critical data elements from legacy Jack Henry / jhaKnow structures into FIS reporting and enterprise data structures.
- Oversee mapping, transformation, and reconciliation of data between Jack Henry, FIS, and enterprise reporting platforms.
- Identify and resolve inconsistencies affecting trend analysis, management reporting, or strategic decision-making.
- AI & Advanced Analytics Data Foundation
- Establish and strengthen the trusted data foundation required for AI, machine learning, and advanced analytics use cases.
- Ensure availability of clean, governed, and well-documented datasets for model development, experimentation, and future intelligent solutions.
- Improve traceability, consistency, and reliability of data supporting advanced analytics initiatives.
- Partner with analytics and technology teams to enable scalable AI readiness.
- Governance, Controls & Leadership
- Maintain governance standards for data mapping, transformation, and validation.
- Support data governance, lineage, transparency, and audit readiness requirements.
- Promote use of approved, controlled, and standardized reporting source across the enterprise.
Education
Bachelor’s degree in a relevant field; advanced degree preferred.
Experience
- 5–7+ years of experience in enterprise data integration, reporting, analytics, or data warehousing environments.
- Strong experience with SQL Server, SQL development, relational databases, and enterprise reporting environments.
- Experience with enterprise data platforms such as Snowflake or similar cloud-based data warehouse technologies preferred.
- Experience integrating data from multiple source systems, including banking, loan, deposit, customer, or financial reporting platforms preferred.
- Experience with Jack Henry / jhaKnow, FIS, or similar banking and reporting platforms preferred.
- Experience working with data quality, reconciliation, validation, and standardized reporting processes.
Skills & Knowledge
- Strong background in data integration, reporting architecture, reconciliation, and data quality management.
- Proven ability to lead enterprise initiatives and cross-functional delivery.
- Strong communication, leadership, problem-solving, and organizational skills.