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

Don’t meet all the requirements on the list?
A resume only goes so far in expressing who you are and the unique perspectives you bring. If you believe your skills and experience align with the role—but you might not check all the boxes—we want to hear from you. We encourage candidates from all work backgrounds, equity-seeking communities and experience levels to apply. If you’re seeking a career where your drive, perspective and growth are celebrated, we want to hear from you.

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. 

What happens next?
If you are shortlisted, you’ll hear from us after the posting closes. Check out our How We Hire page to learn more about our hiring process. If you need any accommodations throughout this process, please let us know at talentteam@atb.com

Stay in touch
We’re excited that you’re interested in a career with ATB. Follow us on LinkedIn, Facebook and Instagram to learn more about what our team is up to.