Loop
Columbus, OH
51-200 employees
We believe that brands have a profound power to build connectivity through e-commerce. We're working to change commerce for the better!
Analytics Engineer
Analytics Engineer
This job is no longer open
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.
What we value:
- Provide value back to the business.
- Progress over perfection.
- Collaboration.Growth mindset.
- Diverse and inclusive thinking.
- Accountability and high-quality work.
- Make new mistakes.
Nice to have:
- Familiarity with dimensional modeling/data warehousing concepts.
- Python experience.
- Experience building and maintaining semantic layers and self-service content in Looker for non-technical end-users.
- Experience with project management. SaaS, e-commerce, and startups.
$106,000 - $159,000 a year
- We know that making decisions about your career and compensation is a huge deal. Because of that, we’re incredibly thoughtful about our compensation strategy. We want you to feel safe and excited, but also comfortable with the compensation package of a startup. We’ve outlined some important information for you here, but please know there’s a lot more to compensation than we can cover in this job posting.
- The posted salary range is the base salary for this opportunity. The salary range is subject to change, and may be adjusted in the future.
- The actual annual salary paid for this position will be based on several factors, including, but not limited to: your prior experience and skills related to the position, geographic location, company needs, current market demands, and your total compensation goals.
- Great humans deserve great benefits. At Loop, you’ll be eligible for benefits such as: medical, dental, and vision insurance, flexible PTO, company holidays, sick & safe leave, parental leave, 401k, monthly wellness benefit, home workstation benefit, phone/internet benefit, and equity.
In a perfect world, Loop wouldn't exist. If we had our way, we'd live in a world where we're mindful about how we consume, we love every product we own, and we share values with the brands who create them. In reality, commerce isn't perfect and often breaks. Loop creates second chances.
We're starting by revolutionizing the post-purchase experience. We've taken one of the most fragile commerce interactions - returns - and turned it into something consumers actually love, and that deepens our connection to brands and products.
We take connection seriously on the inside, too. We're building a work experience that allows you to Be A Human First and prioritizes empathy and wellbeing. We view Loop as a special place in your career to shape the future of an industry and become a better person while doing it. You can grow faster here in a shorter amount of time - we'll give you space and trust you to fill it.
Learn more about us here: https://loopreturns.com/careers.
You can review our privacy notice here.
This job is no longer open