Financial Data Analytics Engineer

Posted 25 Days Ago
Be an Early Applicant
Vancouver, BC
In-Office
90-100 Hourly
Mid level
Financial Services
The Role
The role involves maintaining financial data models, optimizing data pipelines, executing financial reports, and providing strategic analysis leveraging SQL and BI tools.
Summary Generated by Built In

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
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Vancouver, British Columbia
114 Employees
Year Founded: 2016

What We Do

FISPAN connects your business bank directly into your ERP environment, simplifying your treasury management processes, which saves you both time and money. With our plugin integration, you can automate your accounting entries, eliminate dual screen accounting and significantly streamline your treasury management experience. With a swift onboarding process, you can start paying your bills directly from your ERP in less than 30 minutes after deciding to install.

Similar Jobs

Remitly Logo Remitly

Development Engineer

eCommerce • Fintech • Payments • Software • Financial Services
In-Office
Burnaby, BC, CAN
2800 Employees
112K-140K Annually

Kraft Heinz Logo Kraft Heinz

Quality Assurance and Control Specialist

Big Data • Cloud • Food • Machine Learning • Software • Database • Analytics
Hybrid
Vancouver, BC, CAN
38000 Employees
75K-94K Annually

Kraft Heinz Logo Kraft Heinz

General Manager

Big Data • Cloud • Food • Machine Learning • Software • Database • Analytics
Hybrid
Vancouver, BC, CAN
38000 Employees
119K-148K Annually

Boeing Logo Boeing

Product Operations lead

Aerospace • Information Technology • Cybersecurity • Defense • Manufacturing
In-Office
Richmond, BC, CAN
141000 Employees
96K-170K Annually

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Rain Thumbnail
Web3 • Payments • Infrastructure as a Service (IaaS) • Fintech • Financial Services • Cryptocurrency • Blockchain
New York, NY
70 Employees
Granted Thumbnail
Mobile • Insurance • Healthtech • Financial Services • Artificial Intelligence
New York, New York
23 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account