Analytics Engineer

Salary

Salary range: $106,000 - $159,000 a year

Loop is in an unparalleled position to provide data to our merchants that no one else is able to replicate. Data will be at the core of everything we do and some of our most critical work as we grow. Our future is to create data-based products that use modern techniques for delivering not only data but invaluable insights. We’ll identify problems our merchants don’t even know they have and use our data to create solutions that thrill merchants with their ability to predict and forecast their customer’s needs.

As an Analytics Engineer at Loop, you’ll have a significant impact on our ability to solve merchant problems and fulfill merchant needs. Our cloud-based data warehouse fuels the great work our Analytics team does. Your job is to model the raw data into clean, well-defined, analytics-ready datasets, acting as the bridge between Data Engineering and Analytics and serve as the champion for scale across our data architecture.

Right away, we’ve listed what we think you’ll be spending your time on. We’re growing fast, and growth means the challenges we’ll work on together will change as we lead Loop through new and different phases.

This is an indispensable role with us, so we’ll be looking for you to have examples of when you’ve tackled these challenges throughout your career. We’ve laid out the experience we think is important to set you up for success in this role. But, we appreciate that different humans will solve problems in different ways, so we don’t expect you to fit exactly in a box of requirements.

Loop HQ is a state-of-the-art office located in Columbus, Ohio, and more than half of our team works remotely across the United States and Canada. You can choose to join us in the Columbus office or stay fully remote in this role.

Technologies we’re excited by: dbt, SQL, Snowflake, Spectacles, Git, Looker, Hex, Fivetran

What You’ll Do:

Design, develop, and extend production-quality dbt code with an eye towards performance, scale, and maintainability.
Through a DataOps lens, collect business requirements, define successful analytics outcomes, and produce scalable database designs, data models, and reusable data assets.
Support our data analysts, data scientists, ML engineers, and other team members by building, reviewing, and approving data model changes that help us continuously deliver value back to the business.
Collaborate with the Analytics and Data Engineering teams on data pipelines, ETL, data analysis and visualizations, etc.
Develop and maintain documentation that increases the understanding and utilization of our data assets.
Support the implementation of our analytics, semantic, and metrics layers.
Support the execution of medium to large-scale data projects that have significant impact for multiple stakeholders across Loop.

Your Experience:

3+ years of hands-on experience as a data analyst, data engineer, or equivalent.
1+ year of hands-on experience working with dbt.
Significant experience in data modeling and data warehouse architecture, with solid SQL experience.
Business acumen and experience with one or more functional areas such as Product, GTM, Finance, Marketing, Customer Experience.
Familiarity with software development best practices applied to data and analytics (DataOps), primarily related to version control, CI/CD, automation, and testing.
Self-motivated and self-managing, with a solution-oriented mindset.
Exceptional verbal, written and listening skills and the ability to bring consensus and communicate with a diverse audience.

‌