Financial Data Analyst

  • Full Time Job
  • Hybrid
  • nzd
Constantinople
Constantinople is the first of its kind: an all-in-one software and operational platform for banks. We provide our banking clients with a cloud-native infrastructure to host and manage their customers. We offer a comprehensive suite of banking products, together with all operational services needed to run a bank efficiently.
 
Constantinople’s state-of-the-art platform eliminates the need for expensive infrastructure, and replaces manual operational and compliance processes with automation at scale. By removing the operational complexity of banking, Constantinople enables its clients to focus on its customers and the business of banking.
 
The Role
 
We are seeking a Financial Data Analyst to join our growing team. You will be responsible for for ensuring the accuracy, integrity, and scalability of our finance and regulatory reporting solutions. You will leverage your fundamental proficiency in SQL, Python, DBT, data visualisation (e.g.Tableau), and Excel to maintain financial data accuracy, optimise reporting processes, and enhance reconciliation workflows.
 
What You'll Do
    • Collaborate with product and data engineering teams to gather necessary data inputs for new financial products.
    • Update SQL queries and Python scripts to incorporate new data inputs and produce updated output integration files.
    • Modify reconciliation processes and ensure they align with new product implementations.
    • Maintain and update platform integration specification files, including accounting manuals.
    • Generate test evidence for new features to validate data accuracy and integration.
    • Assess whether new products require updates to existing regulatory reports or changes to GL (General Ledger) behaviour.
    • Support client teams during migrations and new product integrations by updating accounting manuals and providing example data.
    • Create and maintain platform integration specifications, including accounting manuals and sample integration files.
    • Ensure seamless data mapping and system compatibility for clients integrating new financial products.
    • Perform daily reconciliation tasks to ensure all overnight technical reconciliations have passed.
    • Investigate and resolve reconciliation breaks through root cause analysis.
    • Implement technical adjustments, including journal entries and data corrections in collaboration with Payment Operations.
    • Maintain and own the business logic for Reg360 integration using the data platform.
    • Ensure regulatory reporting requirements are met and updated as needed.
Who You Are
    • Proficiency in SQL and Python for data processing and reconciliation.
    • Experience with DBT for data transformation and modeling.
    • Strong data visualisation skills using tools like Tableau or equivalent.
    • Advanced Excel proficiency for financial data analysis and reporting.
    • Basic client relationship management skills to support integration and migration efforts.
    • Foundational understanding of financial systems and accounting principles.
    • Strong problem-solving abilities with a keen eye for data accuracy and reconciliation issues.
    • Ability to work collaboratively with cross-functional teams including finance, product, and engineering.
Constantinople