Finance Data Systems Specialist, Finance Architecture

At ATB, we exist to make it possible for our clients, team members and communities. Our purpose is more than aspirational. It's a real commitment we live every day through our values (what we call the ATB ID). Life at ATB is about more than work. In fact, we’re consistently recognized as one of Canada's top employers thanks to our high-care, high-performance culture, upheld by the three commitments we make to our team members: Impact in action: No matter where you are in the organization, you're empowered to make an impact in the lives of our clients and communities. Thrive together: We want you—the unique, authentic you—to feel safe and celebrated at work. We're on a continuous journey to build the most flexible and inclusive programs. Ready for tomorrow: We want to enable your success through interesting and challenging work, performance enablement, and learning and development. About the Role

As Finance Data Systems Specialist, you serve as a strategic architect of ATB’s financial data ecosystem. Reporting directly to the Director of Finance Architecture, you act as the vital bridge between high-level financial strategy and the data created by the underlying technical infrastructure that powers it. Your mandate is to champion data integration and lineage stewardship—ensuring every financial transaction, from source capture to final reporting, moves with absolute integrity across interconnected systems. You are tasked with proactively hunting for systemic gaps, anticipating data and system vulnerabilities, automating workflows, and engineering preventative controls to ensure seamless data flow across ATB’s financial landscape. At ATB, you will harmonize business motivations with technical execution, turning complex business requirements into reliable, automated system solutions. You will take full ownership of high-impact, data-intensive initiatives aligned with your domain, and play a central role in delivering key subledger projects—including upgrades, implementations, and support packs. Accountabilities

System Health & Vulnerability Management: Develop proactive, repeatable diagnostic frameworks and perform health checks using advanced analytics to identify anomalies, investigate root causes, and resolve system vulnerabilities. Framework Standardization & Capability Building: Standardize and document diagnostic frameworks to cross-train team, driving decentralized process adoption and safeguarding automated processing, data lineage, and financial reporting integrity. Process Optimization & Automation: Drive continuous improvement by identifying and executing opportunities to automate workflows—including but not limited to financial data collection, analysis, and reporting - maximizing operational efficiency and data reliability. Solution Delivery & Stakeholder Alignment: Partner across business and technical teams to design, build, and deliver reliable solutions that fulfill ATB’s accounting and financial reporting requirements Posting Schemas, Reconciliations & Balance Resolution: Investigate inconsistencies between subledger and general ledger balances. Analyze transaction-to-GL derivation logic to identify accounting configuration errors, recommending system updates and preventative controls to reduce operational disruptions. Knowledge, Skills and Experience

Distinctive Competencies & Technical Skills: Systems Architecture & Integration

Core Financial Platforms: Deep technical knowledge of core banking platforms, GL/subledgers (SAP FRDP, FPSL, S/4HANA Finance), enterprise data warehouses, and integration patterns. Solution Architecture: Proven capability to design end-to-end data flows and apply architectural principles to complex financial and accounting systems.

Technical & Data Engineering

Database Querying & Optimization: Expert-level SQL skills to query, tune, and extract insights from high-volume financial databases. Data Architecture & Analytics Automation: Design, transform, and automate large-scale financial data models using modern cloud platforms (BigQuery, GCP) and advanced programming tools (Python, JAVA, SQL, Apps Script). Data Harmonization: Hands-on expertise in data mining, curation, cleansing, and pattern recognition within multi-layered banking systems.

Reconciliations & Quality Assurance

Financial Diagnostics: Expert ability to perform root-cause analysis, tracing and resolving complex source-to-subledger and subledger-to-GL variance issues. Data Integrity Controls: Capability to design robust testing frameworks, automated validation scripts, and controls across production environments.Governance and Compliance: In-depth knowledge of financial data governance standards and data lineage tracking.

Technical Enablement & Cross Functional Collaboration

Technical-Business Translation: Skill in bridging technical and business teams by translating complex concepts both ways. Data Storytelling: Abil