Trove is hiring a
Senior Data Engineer

Summary

Trove Recommerce is a leading branded resale company seeking a Senior Data Engineer to improve their data platform's reliability, resiliency, and scalability. The role involves optimizing data pipelines, designing data marts, performing data validation, creating documentation, and staying updated with the latest data engineering technologies.

Requirements

• Bachelor’s degree in Engineering, or a related field (or equivalent practical experience)
• 8+ years of experience in data engineering or a similar role
• Strong expertise in data modeling, developing and implementing data mart and data warehouse solutions
• Proven experience as a data mart developer or similar role in data warehousing projects with strong working knowledge and understanding of the data warehouse design methods, including data vault and dimensional modeling
• Solid understanding of data modeling concepts (star schema, snowflake schema) and data warehouse design principles
• Strong experience and proficiency in SQL, dbt, Redshift administration, including performance tuning, WLM and DMS
• Proven experience in managing and administrating distributed databases
• Experience in building data lakes, AWS and data-related services (e.g., Athena, S3, Glue)

Responsibilities

• Extend and optimize the current ELT pipeline to help assemble complex data sets to address a diverse set of business and data analytics requests
• Monitor the performance of data pipelines, troubleshoot and resolve data issues
• Design and develop data marts based on business requirements and data architecture principles
• Optimize data mart schema and queries for performance and scalability
• Perform data validation and quality assurance activities to ensure accuracy and integrity of data
• Create and maintain documentation for data mart designs, ETL processes, and data mappings
• Evolve tools, best practices and processes to enable the Catalog Integration team to ensure catalog quality and freshness
• Stay up-to-date with the latest data engineering technologies and best practices

Preferred Qualifications

• Experience with Snowflake and Python is preferred
• Familiarity with data governance practices and principles

Benefits

• Flexible Remote Workplace
• Open PTO -. Our flexible vacation company policy allows employees to take the time they need to rest and enjoy themselves outside work
• 401K-. Employees can set aside pre-tax dollars to invest in a qualified retirement investment plan with a company match
• Medical-. Trove covers 100% of employee monthly premium
• Equity/Share Options -. The longer the employee works, the more stocks become available to purchase
• Learning Fund-. Exempt employees have access to a pool of funds to support execution of their self-development goals and objectives
• Partner Discounts-. Enjoy eligibility for Pro Accounts and various partner discounts from Patagonia, Arcteryx and Eileen FIsher