Remote Senior Analytics Engineer

Summary

Join Focal Systems as a Senior Analytics Engineer to help implement our analytics roadmap, utilizing expert SQL knowledge to create efficient queries and dashboards. As lead developer of the transformation layer on top of the data warehouse using DBT technologies, you will drive simpler data models and better BI tool performance.

Requirements

• 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
• 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

Responsibilities

• Lead developer in data transformation (DBT), semantic layer, and data presentation (BI layer modeling)
• Write efficient SQL queries that help answer critical business reporting questions
• Identify data, metrics and analysis needs; including improvements in data models that power dashboards and data products
• Implement best practices in data warehouse storage (partitions, clustering, query optimizations)
• Operational ownership of analytics 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 process improvements

Benefits

• Competitive Salary & Attractive Stock
• Health Insurance
• Paid Time Off