Senior Analytics Engineer

About The Company:

Ambient combines a decade of operational experience with design and engineering prowess to improve apartment living and management in the most impactful, cost-effective way possible.

The name "Ambient" embodies our vision to create a category-defining platform that seamlessly integrates smart technology into the built environment and transforms the way people live, visit, and work in multifamily communities. Our focus is on increasing the value of multifamily properties by making them more efficient to operate and more comfortable to live in.

About The Role:

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.

Responsibilities:

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

Required Qualifications:

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

Preferred Qualifications:

• Knowledge of Computer science fundamentals: data structures, algorithms, performance complexity, and implications of computer architecture on software performance (e.g., I/O and memory tuning)
• Familiarity with Data Science workflow and life cycle
• Solid programming skills with Python data stack libraries and tools such as pandas, Jupyter Notebooks, Matplotlib, etc 

Traits required for success in this role:

• 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

#ambient

Ambient Property Technologies Inc. is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, disability or genetic information, sex, sexual orientation, gender identity, or national origin.

A note to recruitment agencies: Please don’t reach out to Ambient employees or leaders about our roles -- we’ve got recruiting covered. We don’t accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes. Thank you for your understanding.