Finance Data Systems Specialist, Finance Architecture

ATB; Calgary; Hybrid; CAD 120,000 - 160,000; Full time

Job summary

ATB is seeking a Finance Data Systems Specialist to architect ATB’s financial data ecosystem and bridge financial strategy with underlying data infrastructure. You’ll own high-impact, data-intensive initiatives, drive data integrity, and lead subledger projects including upgrades and support packs.

The role emphasizes proactive data governance, automated workflows, and collaboration with business and IT teams to deliver reliable financial reporting solutions.

Qualifications

• Bachelor’s degree and 4+ years experience in financial systems or data engineering.
• CPA designation or candidate status is a plus.

Responsibilities

• System Health & Vulnerability Management: develop proactive diagnostic frameworks and health checks to identify anomalies and resolve vulnerabilities.
• Framework Standardization & Capability Building: standardize diagnostic frameworks and cross-train the team to safeguard automated processing and data integrity.
• Process Optimization & Automation: automate workflows for financial data collection, analysis, and reporting to maximize efficiency and reliability.
• Solution Delivery & Stakeholder Alignment: design, build, and deliver reliable solutions for ATB’s accounting and financial reporting needs.
• Posting Schemas, Reconciliations & Balance Resolution: investigate subledger vs GL variances and implement preventative controls.

Skills

Data integration

SQL

Data storytelling

Automation

Cross-functional collaboration

Problem solving

Autonomous execution

Data governance

Education

Bachelor’s degree in Finance, Accounting, MIS, Data Analytics, CS

Tools

SAP FPSL

S/4HANA Finance

BigQuery

GCP

Python

Apps Script

Job description

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: Ability to synthesize raw, complex financial data into actionable business insights.
  • Autonomous Execution: High degree of self-direction in managing day-to-day role requirements and deliverables within defined timelines.
  • Technical Knowledge Transfer and Peer Upskilling: Act as an informal mentor to the team , elevating overall team data capabilities, preventative daily monitoring, and workflow automation.

Key Qualifications & Requirements

• Education & Experience: Bachelor’s degree in Finance, Accounting, Management Information Systems (MIS), Data Analytics, Computer Science, or a related field, combined with 4+ years of experience in financial systems or data engineering.
• Accounting Domain (Highly Preferred): Strong understanding of General Ledger concepts, subledger-to-GL reconciliations, and financial reporting standards (CPA designation or candidate status is an asset).
• SAP & Systems Certifications (Preferred): SAP Certified Application Associate – SAP S/4HANA for Financial Accounting, SAP Financial Products Subledger (FPSL), or cloud data engineering credentials (GCP/AWS).

Additional Information

This position has a hybrid work arrangement. You’ll work both remote and onsite, where time onsite is based on your job accountabilities and performance objectives.

We’re dedicated to building a workforce reflective of those within our communities, and a culture where our team members are equipped with what they need to succeed—their way. Part of creating an inclusive workplace is recognizing our role in advancing Truth and Reconciliation. We are committed to meeting and exceeding the standards set out in the Partnership Accreditation in Indigenous Relations program created by the Canadian Council for Aboriginal Business.