Data Engineer (Remote, US & Canada)

About Dolly

Dolly is the leading on-demand local moving and delivery service, built with a vision to reimagine the way local moving and delivery should work. We offer guaranteed pricing, on-demand availability, 30-minute delivery windows, GPS tracking, and real-time communication. Whether you’re moving or just need help to deliver a few items, Dolly provides a combination of convenience, reliability, and value that’s never existed in the moving and delivery space.

Working directly with consumers and as the trusted delivery partner for some of the world’s largest retail brands (The Container Store, Best Buy, Crate & Barrel, Costco, and many more), we’ve handled millions of items across the 45 markets that we currently serve, all while earning unsurpassed customer satisfaction.

The heart of our service is our network of Dolly “Helpers”—thousands of truck owners who work on their own schedules and carefully load, transport, and unload each and every item. We are very proud to be one of the few gig-economy companies that offer gig-workers a living wage (Helpers earn $40+/hour).

We are tackling a really fun problem at the cutting edge of the logistics industry. We are ambitious and humble, we are growing fast, and, above all, we are passionate about building a customer-obsessed household brand that has a real and positive impact on people’s lives. Join us!

About the Role

The Marketplace team is responsible for all levers that power and drive Dolly’s business with the overarching objective of matching supply and demand at the right price. Living at the intersection between Dolly’s core software products/engineering, and business functions, at the heart of the Marketplace team is Dolly’s data. As a Data Engineer you will own two way integration processes between source systems of record and the organization’s data lake / data access layer, including tool based integrations and any custom integrations needed. As a part of the core data team you’ll work closely with analytics engineers to help improve general query performance, manage access patterns and permissions, as well as contribute to in-lake and downstream data operations, initial refinements, and process orchestration.

This role reports to the Senior Director of Marketplace and Analytics.

As a Data Engineer at Dolly, you will:

• Set up, deploy and maintain efficient extract and load operations from a wide variety of data sources using ELT tooling, and Reverse ETL tooling
• Develop scalable and efficient custom EL and reverse EL processes when needed
• Set up and maintain / respond to monitoring of extraction and load process pipelines (and reverse ETL pipelines) 
• Design and deploy data storage and table structures responsive to frequent access patterns ensuring query optimization and speed of access for visualization tooling
• Provide administrative support for security in the data lake including data masking, encryption, and access control
• Configure and maintain process orchestration in-lake for interdependent transformations
• Support Analytics Engineering in development, deployment and maintenance of data quality processes
• Provide support to Analytics Engineering in developing performant, scalable code for Dolly’s in-lake/warehouse transformation layer

This position requires:

• Expertise in SQL (5 years),
• Experience with Spark (Scala or Python), Spark SQL (4 years)
• Experience in ELT/ETL tools (Fivetran, Stitch, Arirbyte, etc) (3 years) 
• Experience developing efficient custom extraction and load processes against external REST APIs (4 years)
• Experience AWS cloud computing environments (4 years)
• Experience with git / VCS (4 years)
• Exposure to dimensional modeling and SCD2 use cases (2 years)
• Exposure to design and implementation of data quality assurance and monitoring processes (2 years)
• Commitment to data process development with a relentless focus on transparency, quality, efficiency and resilience

Bonus points for any of the following:

• Experience in analytics engineering
• Experience with Databricks
• Experience with analytical APIs
• Experience with development and production deployment processes for predictive models and associated learning processes.
• Experience actively supporting ongoing business intelligence processes and dashboarding/visualization
• Startup experience
• Marketplace experience

What else you should know about Dolly:

We believe that becoming an increasingly diverse, equitable, and inclusive workplace makes us a more successful, relevant, competitive, and resilient organization. As such, Dolly is an equal opportunity employer that prohibits discrimination and harassment of any kind. We are committed to providing equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, family or parental status, or Veteran status.

We are headquartered in Seattle but we are a remote-first workplace and this is a remote-friendly position provided you can work North American business hours.

Finally, Dolly is a wholly-owned, independent subsidiary of Updater, the leading moving concierge platform. Together with Updater, we are forever changing the moving and delivery landscape.