Senior Analytics Engineer, Level Home

• Advanced SQL skills to get the data you need from a data warehouse (we use BigQuery)
• Data modeling and schema design skills (we use dbt)
• Experience developing cloud hosted data ingestion web services (we’re in AWS and GCP) including code running as lambdas or in containers (e.g. Kubernetes, Docker)
• Ability to match observability concepts (e.g. traces, logs, metrics) to observability needs (e.g. first tier support vs. QA reproducibility)
• Familiar with ETL/ELT tools (we use Airflow and Stitch)
• Experience in modern advanced analytical tools and programming languages such as Python
• Software engineering fundamentals and ability to write production-ready code
• Experience with version control systems (i.e. Git, Github) and workflows
• Experience working with data visualization tools such as Tableau, Data Studio, Looker, Mode, Metabase, Superset etc. (we use SigmaComputing)
• Comfortable with ambiguity: You love tackling nebulous problems through discovery, experimentation and iteration
• Curious about People: You dive into nebulous problems and ask progressively better questions as you get more info about the problem being solved
• Curious about Process: You're curious about the minimal information artifacts which need to be captured from a business process or user interaction in order to run an experiment
• Pragmatic about Maintainability: You take pride in the experience you provide to those who read your queries or extend your abstractions; an instinctive understanding of the tradeoff between time and succinctness shows in your work

Desirable

• As a Senior Analytics Engineer you support decision making across the organization. This support spans the organization from the product and engineering teams to operations and finance. More specifically, you work closely with subject matter experts to document, curate, and build tools to enable them to make decisions informed by data
• The Data Team at Ambient is small, so this role will be uniquely cross functional. Decision support will sometimes span all the way from automating data acquisition to analysis. But that’s not all - a big part of this role is providing leadership in the process of discovery, design, and building tools you and the rest of the Data Team will leverage to provide all of the above
• In short - if you’re comfortable with ambiguity and looking for a small team setting with high visibility, lots of ownership, and tangible impact, we’d love to hear from you
• Create new data models, views, and data flows from a variety of sources to support use cases ranging from product experimentation and device troubleshooting
• Collaborate with engineers across our stack to improve our telemetry collection capabilities and better inform downstream alerting metrics and troubleshooting tools
• Build data quality tests for our IOT device telemetry and ERP system including testing for data recency, cardinality, etc
• Support business users through workshops, query and dashboard performance monitoring, creating upstream processing steps as needed. (Ex. aggregates, event sequencing/grouping, time series spines, etc)
• Build analytics on our analytics stack, everything from access auditing/monitoring to building qualitative insights on trends in inbound data requests