We're Hiring:

SAS Data Warehouse Engineer

FreshBooks is looking for a senior and very experienced SAS Data Warehouse Engineer to lead us in architecting and managing the FreshBooks data warehouse.

Data is a big part of our business and your proven leadership skills in building, architecting, growing and maintaining our data warehouse will ramp us up and keep us out in front. You will move quickly, make smart decisions and manage all the fine details. This is a senior role where experience architecting the assembly of flexible data marts and OLAP cubes from operational source databases and APIs is a must.

Your key responsibilities include:

  • Leading us in architecting and managing the FreshBooks data warehouse.
  • Directing Development and Operations as they expand and enrich the data in the warehouse.
  • Rapidly building data marts and OLAP cubes from our numerous source systems and work smartly with the Business Analysts and Stakeholders to develop and refine reports that will drive the organization.
  • Dealing with deprecated data and other data quality issues before they become a problem to your internal customers.
  • Setting up automated QA processes that alert Business Analysts that assumptions about underlying data have changed before they base business decisions off of them.
  • Initiating a metadata and ETL processes backup strategy.

We need you to have:

  • Proven experience working with SAS data warehousing and reporting products.
  • Minimum 3 years of experience leading the creation and maintenance of data warehouses.
  • Very serious SQL chops.
  • Excellent communication skills.
  • Fanatical attention to detail.

We hope you have:

  • Scripting language experience, as part of the role involves moving manual Ruby & Python reports to the SAS data warehouse.
  • Familiarity in a *NIX environment.
  • JSON/XML parsing skills.
  • Experience working with a message bus (i.e. streaming data).

How to apply

Pull your resume or your LinkedIn Profile together and contact us at careers@freshbooks.com.

No telecommuting positions are available at this time.
All of our roles require candidates to
work out of our lovely Toronto office.
Fresh Benefits
We like to take care of our team here at FreshBooks. Here's a small list of some of the benefits available to our employees.
  • 100% employer paid health benefits
  • Competitive salaries
  • Morning subway shuttle service
  • Free breakfast essentials (cereal, milk, yogurt, pancakes, coffee etc.)
  • free snacks, pop fridge, beer fridge
  • $200 yearly healthy living credit
  • Employee Assistance Program (EAP)
  • Dog friendly, kid friendly, bike friendly
  • Onsite games (ping pong, foosball, arcade machine)
  • Onsite showers and towel service
  • Casual office with no dress code
  • Choice of tools and computer
  • Free parking