Design, build, and maintain scalable batch and streaming data pipelines and domain-oriented data models using dbt and cloud warehouses. Ensure data quality, documentation, and usability for analytics, ML, and reporting while collaborating with Product, Analytics, and ML teams.
As a Data Engineer on the R&D Team, you will help FreshBooks build and evolve high-quality, trusted data assets that power analytics, business decision-making, and machine learning initiatives. You will focus on data modeling, transformation, and domain-oriented data architecture, working closely with Product, Analytics, and Machine Learning teams to ensure data is well-structured, well-documented, and easy to consume. You will contribute to building scalable, reliable datasets that serve as a foundation for reporting, experimentation, and operational use cases, with exposure to both batch and event-driven data.
NOTE: This role can be worked remotely from the above location(s).
What You'll Do
- Architect, design, and develop clean, high-performance datasets using modern tools like dbt and BigQuery, focusing on usability and scalability for analytical consumption.
- Be a key contributor to our domain-oriented data architecture, defining how core business entities (e.g., customers, payments) are modeled, governed, and exposed across the organization.
- Build and maintain robust batch and streaming data pipelines that transform raw data into trusted, analytics-ready assets to support both near real-time and traditional use cases.
- Collaborate closely with Analytics, Product, and Machine Learning teams to translate complex requirements into reusable, well-governed data models and contracts.
- Champion data quality, reliability, and documentation by implementing rigorous testing, validation, and monitoring practices.
- Leverage cutting-edge tools, including AI/agentic workflows, to accelerate development, enhance productivity, and improve data exploration and lineage.
- Participate in code reviews, contribute to improving engineering standards, and partner with platform teams to ensure our data solutions meet ambitious performance, cost, and scalability goals.
What You'll Bring
- 2+ years of experience working in data engineering, analytics engineering, or a related field.
- Experience building and maintaining data models and transformation pipelines (e.g., dbt or similar tools).
- Strong SQL skills and proficiency in Python (or similar language).
- Solid understanding of data modeling concepts (e.g., dimensional modeling, normalization, data warehousing patterns).
- Experience working with a cloud data warehouse (e.g., BigQuery, Snowflake, Redshift).
- Familiarity with orchestrators such as Airflow, GCC, Dagster, Prefect (or similar tools).
- Basic understanding or exposure to streaming/event-driven systems (e.g., Pub/Sub, Kafka, Kinesis, Dataflow).
- Understanding of data quality, testing, and validation practices.
- Ability to work cross-functionally and communicate clearly with both technical and non-technical stakeholders.
You'll Stand Out If You Have
- Experience in analytics engineering or working closely with analytics teams.
- Experience building or contributing to near real-time data pipelines.
- Familiarity with data governance, metadata management, or lineage tools.
- Experience using AI-assisted or agentic tools to improve development workflows.
- Experience in SaaS, fintech, or payments-related domains.
#LI-SR1 #LI-Remote
At FreshBooks, we approach each individual's compensation with a promise of fair market value and internal equity commensurate with experience and specific skill set.
The total compensation for this role ranges from CA$102,400 - CA$128,000 per year, which may include participation in our incentive programs. Additionally, this position offers an equity grant and immediate enrollment in FreshBooks' comprehensive benefits program, detailed below.
NOTE: This posting is reflective of an existing vacancy at FreshBooks.
Perks and BenefitsWe understand that you'll weigh many factors when deciding if FreshBooks is the right next step in your career. Here are some of our offerings for our employees (we call ourselves ✨ FreshBookers✨) to support their growth:
- 🩺 Comprehensive health and wellness benefits. Generous time off including a flexible vacation plan, a retirement savings program or pension plan matched to your local office, stock options for every full-time employee, parental leave and new parent support, annual healthy living credit, comprehensive medical and dental benefits, fertility and gender-affirming benefits dependent on your region, and more.
- 📚 Perks that matter. Including a Peer Recognition Program, an Employee Assistance Program, headphone credit, meaningful in-person gatherings to bring onsite and remote employees together, and more perks matched to your local cluster.
- 🌱 Working environments to help you thrive. Beautiful office spaces welcome you in Toronto, Amsterdam, and San Luis Potosi. If you don't have access to a FreshBooks office, you receive a home office credit to set up your home office.
- 🤗 Supportive peer group, mentors, and leaders. We care about each other across the organization and have programs to support this so everyone feels a strong sense of belonging, and believes in collective impact.
- 🚀 Accelerated growth. Comprehensive company onboarding, career development through continuous coaching, training, and learning on the job.
You've probably learned a bit about FreshBooks before making it to this point, but let us take a moment to introduce ourselves: At FreshBooks, we believe that small business owners are the backbone of the economy, yet they are often the most underserved when it comes to technology. For over 20 years, we’ve been on a mission to support owners, from the scrappy solopreneur with a big dream to the growing business with employees to manage.
Our leading platform is more than just business software; it’s an all-in-one financial toolkit that automates invoicing, expenses, payments and payroll, allowing our customers to spend less time on paperwork and more time doing the work they love.
We believe in human-centric connections that empower teams to do their best work. Headquartered in Toronto, Canada, our team operates in clusters across North America and Europe using a variety of working environments - remote, hybrid, and in-office - all based on what’s best for the team, collaboration, and mental well-being. We are committed to creating a supportive and flexible workplace where everyone can thrive, grow, and make an impact on the lives of small business owners worldwide.
Even if your experience doesn't meet every bullet on the above lists, we'd love to learn more about you and why you think FreshBooks is the next step in your career. FreshBooks is an equal-opportunity employer. We do not discriminate based on gender, religion, race, mental disability, sexual orientation, age, or any other status. All applicants are considered based on their qualifications and merits. At FreshBooks, we inspire an environment of mutual respect and we believe diversity and inclusion are crucial to our success. FreshBooks provides employment accommodation during the recruitment process. Should you require any accommodation, please indicate this on your application and we will work with you to meet your accessibility needs. For any questions, suggestions or required documents regarding accessibility in a different format, please contact us by phone at 1-416-780-2700 and/or email at [email protected].
Similar Jobs
Artificial Intelligence
Design and own end-to-end data quality systems for managed AI data studies: define rubrics, sampling plans, automated checks, launch gates, drift detection, dashboards, and calibration. Investigate integrity issues, run root-cause analysis, build automation in Python/SQL, and partner with Product, Engineering, and Operations to embed quality controls, train reviewers, and scale repeatable quality playbooks across programs.
Top Skills:
PythonSQL
Information Technology • Software
The Data Engineer will assist clients with SAP security design, implement SAP security, develop authorization profiles, and conduct security reviews.
Top Skills:
Enterprise Threat DetectionSAPSap BtpSap FioriSap Grc
Artificial Intelligence • Information Technology • Professional Services • Software • Analytics • Generative AI • Big Data Analytics
Lead architecture, build, and scale a Databricks lakehouse: design batch/streaming pipelines, enforce governance with Unity Catalog, optimize Spark workloads, operationalize ML (MLflow), manage cloud/IaC, mentor engineers, and partner with stakeholders on roadmap and security/compliance.
Top Skills:
AdlsSparkDatabricksDatabricks Asset BundlesDatabricks WorkflowsDbxDelta LakeDelta Live TablesFeature StoreGcsGitMlflowModel ServingPhotonPysparkPythonS3ScalaSpark SqlSQLStructured StreamingTerraformUnity Catalog
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
