FISPAN Logo

FISPAN

Financial Data Analytics Engineer

Posted 9 Days Ago
Be an Early Applicant
In-Office
Vancouver, BC
Mid level
In-Office
Vancouver, BC
Mid level
The role involves maintaining financial data models, optimizing data pipelines, executing financial reports, and providing strategic analysis leveraging SQL and BI tools.
The summary above was generated by AI

Our Business

FISPAN Services Inc. (FISPAN) is an Enterprise SaaS FinTech company that allows banks to deploy embedded financial products and services to create a seamless banking connection for their corporate clients. Our product aims to provide instant scale and reach for banks who want to remove friction and add value by enabling their commercial banking clients to access banking services through their preferred ERP / accounting platform.

Founded in 2016 and headquartered in downtown Vancouver, FISPAN is on a mission to create the best product in the FinTech industry and fundamentally change the way that companies bank. Being the market leader in ERP Banking, we work with the world’s Tier 1 banks with assets exceeding $3T, including J.P. Morgan Chase, Wells Fargo, TD and Bank of Montreal. 

The Role

We are looking for a Financial Data Analytics Engineer to join our team for a 4-month contract to cover a Paternity Leave. This is a unique hybrid role designed for a Data Analyst who possesses a deep understanding of accounting principles and corporate finance.

You will act as the technical owner of our automated financial intelligence infrastructure. Unlike traditional finance roles that rely on spreadsheets, you will manage, troubleshoot, and optimize data pipelines that feed our live 3-statement models and revenue forecasts in Sigma Computing and Redshift.

Who You Are

You are a Data Analyst first, but you speak the language of Finance. You know how to write complex SQL queries to manipulate large datasets, but you also understand how those datasets must aggregate to balance a Balance Sheet or calculate SaaS ARR. You are comfortable debugging a data discrepancy in the morning and presenting a variance analysis to leadership in the afternoon.

Key Responsibilities

Financial Data Engineering & Infrastructure

  • Model Stewardship: Maintain and optimize complex data models in Sigma Computing that power our Income Statement, Balance Sheet, and Cash Flow Statement.
  • Pipeline Management: Monitor data flows between our ERP/Accounting Systems and our data warehouse (Redshift). Troubleshoot ingestion errors and ensure source-to-report accuracy using SQL.
  • Governance: Manage row-level security and access controls to ensure stakeholders view only the data relevant to their role.

Automated Financial Reporting

  • Reporting Cadence: Execute the monthly financial close process using our automated tools. Deliver accurate Budget vs. Actuals (BvA) packets and operational dashboards to department heads.
  • Investor & Compliance Reporting: Generate high-fidelity monthly investor reports and quarterly board materials, ensuring all automated logic aligns with current compliance standards.
  • Revenue Analytics: Manage granular revenue recognition models, tracking implementation progress and recurring revenue cohorts.

Strategic Analysis

  • Forecasting: Maintain the integrated corporate forecast model, inputting actuals and updating assumptions to project rolling cash flow and margins.
  • Ad-Hoc Intelligence: Support the Executive Team with data-driven strategic insights, utilizing your ability to query raw data to answer questions about unit economics, pricing models, and retention.

Qualifications

Technical Skills

  • Advanced SQL (Required): You can write complex queries, joins, and window functions from scratch.
  • BI & Data Visualization: Expert-level proficiency in any modern BI platform (e.g., Tableau, Looker, Power BI, or Sigma Computing). Prior experience with Sigma is not required, but you must be comfortable learning new tools quickly.
  • Python (Preferred): Proficiency in Python (specifically pandas) for data manipulation and analysis is highly desirable.
  • Data Warehousing: Experience working with cloud data warehouses (Redshift, Snowflake, BigQuery).

Financial Domain Knowledge

  • Accounting Fluency: Deep understanding of ASPE, the relationship between the three financial statements, and revenue recognition principles.
  • FP&A Experience: 3+ years experience in a role involving financial forecasting, budgeting, or variance analysis.
  • SaaS Metrics: Familiarity with tracking and modeling ARR, NRR, CAC, and LTV.

Systems

  • Familiarity with modern ERPs and Accounting Systems (API-level understanding is a plus).

Why Work With Us? 

  • Experienced Team: Our CEO is Lisa Shields, a renowned tech entrepreneur whose previous venture, Hyperwallet, was purchased by Paypal and ranks as one of the largest Canadian technology company acquisitions. Lisa is backed by a seasoned leadership team with vast experience scaling technology companies from start-up through growth phases to acquisition. In joining our team you will benefit from that experience and associated mentorship opportunities, and further build your network and knowledge base.
  • High Growth Environment: FISPAN is an emerging high growth company, and that implies autonomy and leadership over projects. Our employees hold a higher level of responsibility and are presented with various hands-on opportunities from the get-go. We want our team to reach their full potential and career aspirations, and FISPAN helps foster that.
  • Rich Culture: The Company’s culture is its greatest asset, and our team members form bonds that last a lifetime. We plan company-wide events, both virtual and in-person, and other activities to foster togetherness and help drive engagement. We also understand that personal growth happens on multiple levels, and so encourage a work-life balance with ample time to spend with family, explore new ideas and develop hobbies. 
  • Perks: Our prime downtown Vancouver office is close to a Skytrain, prestige shopping, and coastal views. FISPAN employees have access to our building fitness center and amenities, fully stocked cupboards, weekly team lunches, and daily coffee runs. We also set our employees up for success by providing the most modern MacBook and Apple equipment.

Compensation Package
FISPAN believes in an atmosphere and culture when innovation can flourish, collaboration and teamwork are valued and transparency is at the core of it all. We want our employees to see how the ideas they help generate today have an impact on how we do business tomorrow. With that, the hiring salary range for this position is $90 to $100 per hour for the duration of the contract; the base pay offered is based on comparable market data from companies of similar employee size, revenue and location.As part of our total rewards offering, permanent employees in this position may be eligible for our competitive semi-annual bonus program, subject to program eligibility requirements. 

Diversity, Equity & Inclusion

As FISPAN continues to grow, we are committed to celebrating diversity, endorsing equity, and encouraging inclusion, and eliminating bias in our recruitment process.
For any inquiries, please contact [email protected] or 604-343-7750.


Vancouver Office Location:
1700 -1055 W Hastings St

Vancouver, British Columbia

V6E 2E9

Top Skills

Cloud Data Warehouses
Python
Redshift
Sigma Computing
SQL
HQ

FISPAN Vancouver, British Columbia, CAN Office

355 Burrard St, Vancouver, British Columbia, Canada, V6C 0C5

Similar Jobs

Yesterday
Easy Apply
Hybrid
11 Locations
Easy Apply
Mid level
Mid level
Big Data • Cloud • Software • Database
The role involves enhancing developer productivity by creating solutions for cross-team challenges, building tools, and providing support within MongoDB's engineering environment. It requires collaboration, understanding customer needs, and mentoring junior team members.
Top Skills: AWSC++GoKubernetesPython
Yesterday
Easy Apply
Hybrid
4 Locations
Easy Apply
Senior level
Senior level
Big Data • Cloud • Software • Database
The role involves guiding product vision in search infrastructure, collaborating with engineering teams, and enhancing customer value through technical strategy. Key responsibilities include technical immersion, operational excellence, and driving long-term platform health.
Top Skills: Ai ApplicationsDistributed SystemsElasticsearchLuceneSolrVector Databases
4 Days Ago
Easy Apply
Hybrid
6 Locations
Easy Apply
Senior level
Senior level
Big Data • Cloud • Software • Database
Lead the Server Programmability team, managing engineers, improving processes and tools, and delivering new features for MongoDB's server architecture and performance.
Top Skills: C++

What you need to know about the Vancouver Tech Scene

Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account