hero

Opportunities at Craft portfolio companies

176
companies
2,010
Jobs

Sr Analytics Data Engineer - Python, AWS, SQL

Terminal.com

Terminal.com

Software Engineering, Data Science
Romania
Posted on Tuesday, July 2, 2024
About Mixbook

Mixbook is an award-winning design platform giving consumers unrivaled creative freedom to design and share one-of-a-kind stories, transforming the lives of more than 6M people. Today, we are the #1 rated photo book service in the US with 26K 5-star reviews and a profitable, growing business. Customers love Mixbook for our powerful and intuitive editor, superb quality, designer themes, and our fanatical customer service.

Founded by two Inc 30 Under 30 entrepreneurs from UC Berkeley California, Mixbook has been featured on the Today Show, Good Morning America, TechCrunch, The Verge, Washington Post, New York Times, and many other global media outlets.

About The Role

Mixbook is an award-winning design platform giving consumers unrivaled creative freedom to design and share one-of-a-kind stories, transforming the lives of more than 6M people. Today, we are the #1 rated photo book service in the US with 26K 5-star reviews and a profitable, growing business. Customers love Mixbook for our powerful and intuitive editor, superb quality, designer themes, and our fanatical customer service. Founded by two Inc 30 Under 30 entrepreneurs from UC Berkeley California, Mixbook has been featured on the Today Show, Good Morning America, TechCrunch, The Verge, Washington Post, New York Times, and many other global media outlets. The Platform and Data team within the Engineering organization serves as the backbone for data across Mixbook, delivering the foundation upon which our insights, prediction models, and AI investments thrive. We are committed to developing a modern data infrastructure, focusing on leveraging best-in-class tools and architectures. This role will focus on establishing data marts through curation and transformation to power our analytics and machine learning processes. In addition to overseeing the data transformations, the role will play a key role in selecting and implementing data transformation and observability platforms (i.e., dbt, coalesce). As our Senior Analytics Data Engineer, you will help marry our business initiatives that thrive on data with data assets. A successful candidate will have that rare mix of technical expertise and business prowess; combining a solid grasp of ETL and transformation techniques and tools with an eagerness to work with business leaders from across our company. You will be responsible for designing, implementing, and maintaining scalable infrastructure to transform our data from a raw stream of events into analytic data marts for business and analytics teams to access. If you're passionate about data and engineering and want to be part of an exciting, fast-paced environment, we want to hear from you.

What You’ll Do

Select and implement transformation and governance platform tools, identifying new technologies and features that will improve our data platforms. Design data mart models with business users in mind. Develop data product specifications that enable business, analytics, and engineering teams. Assess data integration needs and set the specifications for integrations in our Redshift Data Warehouse. Collaborate with engineering and analytics on the design, testing, and implementation of efficient data systems. Establish observability best practices. Verify data integrity and discrepancies. Partner with business, analytics, and engineering teams to direct instrumentation needs and integrate into established data pipelines. Understand how data is produced and work with the Engineering team to adjust as needed. Develop transformation code and deploy to production following agile best practices. Support engineering efforts to optimize database performance and uptime.

What You’ll Bring

Experience with Analytics Data Engineering: data modeling, data mart design, data transformations, data governance, data lineage, and data observability. Bachelor’s Degree in Computer Science or another related college degree. A solid grasp of Analytics Data engineering principles, practices, frameworks, and methodologies. 4+ years of experience as an Analytics Engineer, Data Engineer, Data Infrastructure Engineer or Software Engineer Expert SQL, Python, and database programming skills. Ruby, and/or other coding languages are a plus. Proven experience with AWS or similar cloud databases, as well as data management frameworks and tools (i.e., dbt, coalesce, Monte Carlo). Analytical mindset and excellent communication skills. Able to partner with stakeholders across various levels of expertise. Experience working with Looker PDTs and LookML is a plus.