Analytics Data Engineer

Drizly Boston , MA 02298

Posted 4 months ago

Who we are

Drizly is the world's largest alcohol marketplace and the best way to shop beer, wine and spirits. Our customers trust us to be part of their lives their celebrations, parties, dinners and quiet nights at home.

We are there when it matters - committed to life's moments and the people who create them. We partner with the best retail stores in over 100 cities across North America to serve up the best buying experience. Drizly offers a huge selection and competitive pricing with a side of personalized content.

That is what we do. Who we are is a different story.

We are more than just another tech company. There is an intellectual curiosity that occurs at Drizly.

We have a desire to question, to understand, to figure it out. Bottom line, we solve it. We value not just the truth but the process to get to the truth, to deliberate, decide and then act.

Most importantly, we care. We care about our customer. We care about our company.

We care about our team. There will be long days and incredible challenges.

We are blazing a trail in an industry that hasn't changed in nearly a century, and that doesn't scare us (well, not all the time) -and even when it does, it doesn't stop us, it energizes us.

Do you see yourself here? Read on.

Who you are

You get excited by the evolving landscape of data tools, platforms and technologies, and you have a track record of setting up processing pipelines and storage/compute infrastructure to support analytics organizations. You have both the technical ability to accomplish any ETL task, and the larger vision of how a data architecture, codebase, and best practices should grow with the company.

You love working with teams like Data Science and Business Intelligence to see how well you can transform raw data into highly actionable business insights. You have interest and experience productionalizing data science/ML models.

You thrive in a fast-paced, constantly improving, start-up environment that focuses on real-world, customer centric problems with iterative technical solutions. You have the desire to both drive your own roadmap, as well as enable others to self-serve. Your toolkit includes SQL and non-SQL for transformation, python for ETL and scripting, Kafka and/or Kinesis for streaming jobs, and the ability to troubleshoot distributed systems, optimize queries, and tune tables.

We'd be really impressed if you've had experience in eCommerce environments with massive amounts of clickstream and eventstream data, AWS (Redshift, S3, Cloudwatch, Fargate, et. al.), database management and permissioning, and vendor selection (testing new softwares, leading the discussion on cost/benefit).

What the role is

The Analytics Data Engineer will support and enable Drizly's Analytics team (Data Science + Business Intelligence) through a period of rapid data growth (50% YoY). From building a clickstream processing framework to help support 10m events per day, moving production tables to the analytics data lake, or integrating new data pipelines, Drizly's Analytics Data Engineer will be essential to create a scalable, well-managed foundation for the company.

The Analytics Data Engineer is a critical member of the Analytics organization that works closely with Data Science and Business Intelligence, as well as product focused engineering teams. In short, the Analytics Data Engineer will help define, measure, and monitor the building blocks for Drizly's data capabilities.

In this role you will:

  • Architect and build the Drizly Analytics team's database, storage, and computational solutions through our next phase of growth

  • Maintain and add data pipelines that unlock business insights and new streams of revenue for various parts of the business

  • Productionalize and monitor deployed models built by the data science team

  • Support and mentor the Data Science and Business Intelligence teams: mentoring individuals to improve their data engineering skills, implementing best practices in terms of coding standards, version control, query optimization and table tuning

  • Serve as a subject matter expert on industry-wide data data tools, platforms and technologies, recommend and implement those solutions matching the future needs of Drizly's analytics organization

The Other Stuff

  • Competitive salary

  • One-on-one professional coaching with external expert

  • Health, Dental and Vision Insurance

  • Flexible vacation policy

  • Commuter benefits 401(K) Plan

  • Added perks

You do you.

Drizly is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Analytics Data Engineer

Wayfair LLC

Posted 5 months ago

VIEW JOBS 6/21/2019 12:00:00 AM 2019-09-19T00:00 A Financial Analytics Data Engineer for the Finance team is puzzler at heart paired with the technical know-how to effectively execute on multi-tiered requests. They combine a deep technical fluency with strong communication skills to productionize the data transformations and reporting needs that provide the foundation of Wayfair's multi-billion dollar financial filings. They are hands on writing and owning robust, scalable code that provide the best in class approach to generating the foundation of figures for the company's income statements, deployed across and consulting a range of terabyte scale data warehouses. Starting with strong business instincts and gaining robust system knowledge, adding in close collaboration with stakeholders, and bringing to the table an expertise in efficient data movement, storage, and SQL fundamentals a Financial Analytics Data Engineer can translate the raw data generated from diverse sources into cleaned, curated data sets that provide maximum value to the business, thereby providing deeper insights and analysis on top of the financial reports and figures. What You'll Do * Interact with and uphold a systemic lock for financial data across the entire company * Provide support for and execute data integrity requirements and corrections in line with S-OX requirements and GAAP regulations * Build reporting products that provide the core financial reports for Wayfair * Interact with a wide-array of challenges related to post-order fulfillment operations * Enjoy a wide latitude to recommend and implement creative solutions for new initiative integrations and process improvement * Execute deep dives and diligent testing on data sets to understand their content and build trusted, accurate data products * Optimize performance of queries and data transformation processes by leveraging an understanding of data structures and algorithms * Investigate and identify the root causes of data inaccuracy * End to end ownership of data pipelines, including: business requirements elicitation, data model best practices, implementing changes in SQL, gaining DBA support, coordinating with full-stack engineering teams, and backfill/conversion of existing data * Partner with business-oriented analysts in the design and implementation of best in class key metrics, analyses, and dynamic insights * Report on data health and data quality metrics as they are processed by custom ETL and full-stack frameworks to ensure data sets are accurate and trusted * Evangelize and implement best practices for robust, sustainable development including source control and optimization techniques What You Have * 5+ years of professional work experience in a technology, start-up, data warehousing, or other analytical role * Bachelors in computer science, engineering, economics, MIS, or other quantitative discipline with strong academic record * Intermediate to advanced SQL experience including writing complex queries, user-defined functions and stored procedures, as well as tuning query performance * Familiarity with core principles of database design and efficiency, such as star schemas or normalization, and an understanding of the resulting trade offs * Experience developing complex ETL workflows and data marts, including normalization, de-duplication, and data loading * Extracted actionable insight from complicated data sets with unstructured data, text, or data duplication * Ability to architect, schedule, and monitor large-scale data pipelines and transformations * Comfortable extracting business insights from high volume heterogeneous data on distributed systems or large SQL databases What You Are * Collaborative, approachable, and understanding; a team player who can work with individuals of varying technical aptitude * Attentive to detail and excited to be responsible for mission-critical reporting * Able to identify and succinctly summarize roadblocks, constraints, and trade-offs, propose potential solutions, and drive toward resolution * Experienced with modern development practices such as agile and source control systems * Excited about working with data and design scalable, robust solutions What we'd love to see (but isn't required) * A familiarity with the full suite of Microsoft server tools - SSRS, SSIS, SSAS * Familiarity with BI reporting tools such as OLAP cubes, Tableau, or other standard BI platforms * Experience working with version control, peer code review, and agile sprint-based work streams * Previous work with a distributed database systems like Vertica About Wayfair Inc. Wayfair believes everyone should live in a home they love. Through technology and innovation, Wayfair makes it possible for shoppers to quickly and easily find exactly what they want from a selection of more than 10 million items across home furnishings, décor, home improvement, housewares and more. Committed to delighting its customers every step of the way, Wayfair is reinventing the way people shop for their homes - from product discovery to final delivery. The Wayfair family of sites includes: * Wayfair, an online destination for all things home * Joss & Main, where beautiful furniture and finds meet irresistible savings * AllModern, unbelievable prices on everything modern * Birch Lane, a collection of classic furnishings and timeless home décor * Perigold, unparalleled access to the finest home décor and furnishings Wayfair generated $5.7 billion in net revenue for the twelve months ended June 30, 2018. Headquartered in Boston, Massachusetts with operations throughout North America and Europe, the company employs more than 9,700 people. Wayfair LLC Boston MA

Analytics Data Engineer