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.
ApplyJob Profile
Fully remote
Benefits/PerksCatered 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
Analytics Automation BI Tools Data analysis Data integrity Data Modeling Data Pipelines Data Transformation Data Warehouse Dbt Python SQL
Experience5 years
Education TimezonesAmerica/Edmonton America/Moncton America/Regina America/St_Johns America/Toronto America/Vancouver UTC-3 UTC-4 UTC-5 UTC-6 UTC-7 UTC-8