FreshRemote.Work

Senior Analytics Engineer

Remote in US or Canada

Senior Analytics Engineer

Type: FTE/Perm

Location: Fully Remote

Salary: $110k - 140k + stock options

 

What we are looking for

The Senior Analytics Engineer will be responsible for helping implement our analytics roadmap. They will play a critical role in developing the data modeling and transform layer in DBT on top of the Focal Systems data warehouse. We generate millions of data points every minute that we utilize to help our clients optimize their store operations. This is an opportunity to create a best in class data analytics solution. Reporting to the Head of Analytics you will work closely with other Business Analysts to create efficient dashboards and query results.

 

What you will do

  • Lead developer in data transformation (DBT), semantic layer (DBT, Cube),  and data presentation (BI layer modeling)
  • Identify data, metrics and analysis needs; Initiate, develop and maintain data pipelines and data models that power dashboards and data products with outstanding craftsmanship
  • Write efficient SQL queries that help answer critical business reporting questions
  • Implement best practices in data warehouse storage (partitions, clustering, query optimizations)
  • Operational ownership of data pipelines and data integrity monitoring
  • Work to drive new data initiatives, automation of reports, and establish best practices 
  • Maximize efficiency and productivity through automation and best practices

 

What you need to be successful

  • BS and MS degree, preferably in Engineering, Math, CS or related with 5+ years work experience
  • 3+ years experience in Google BigQuery, or Snowflake
  • 2+ years experience in transform layer in DBT with 2+ years of experience
  • Working knowledge of building a semantic layer in DBT, Cube, etc
  • Expert knowledge of SQL; good knowledge of Python
  • Dashboard and analysis building in BI tools
  • Proven ability to manage complex data analysis
  • Excellent communication, presentation and demonstration skills
  • Recent startup experience preferred; uphold our values & mission; team player

 

 

Why Focal Systems

Strong values and mission: We are a tightly-knit team with an ambitious mission and a strong set of core values, which define our approach to business and have successfully guided us since inception.

Exceptional Team: We are a team of hard-working, fun-loving professionals from some of the most eminent universities, research labs, and tech companies of our time. We pride ourselves on recruiting exceptional individuals to help us redefine the state-of-the-art.

Outstanding Partners: We work with 10+ of the largest retailers in the world and have a world-class roster of investors, advisors and partners to support & advise us in our endeavors.

 

What we offer

We care deeply about the health, happiness, and wellbeing of all of our employees. We offer:

  • Competitive Salary & Attractive Stock
  • Health Insurance
  • Catered lunches
  • Paid Time Off 
  • Quarterly Team Retreats
  • Education grants

 

Note: Our pay bands are driven by market benchmarks in the target geography for hiring. Our posted ranges typically include multiple job levels. A candidate's level is determined by their performance throughout our talent acquisition process including technical screens, behavior interviews, presentations, work samples, and references. We will communicate transparently with the candidate at final stages regarding how we have leveled them, and what salary range that places them into. Placement within range is equally determined by education, general experience in your profession, specific experience in our domain, and your performance in the talent acquisition process. It is rare to receive an offer at the top of the range for a role.

Apply

Job Profile

Regions

North America

Countries

Canada

Restrictions

Fully remote

Benefits/Perks

Catered lunches Competitive salary Education grants Fully remote Health insurance Paid Time Off Quarterly retreats Stock options

Tasks
  • Create dashboards
  • Develop data modeling
  • Implement analytics roadmap
  • Maintain data pipelines
  • Write SQL queries
Skills

Analytics Automation BI Tools Data analysis Data integrity Data Modeling Data Pipelines Data Transformation Data Warehouse Dbt Python SQL

Experience

5 years

Education

B.S. MS

Timezones

America/Edmonton America/Moncton America/Regina America/St_Johns America/Toronto America/Vancouver UTC-3 UTC-4 UTC-5 UTC-6 UTC-7 UTC-8