Trove · 2 days ago

Senior Data Engineer

San Francisco, CA

Full-time

Onsite

Senior Level

8+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

E-CommerceFashion

Growth Opportunities

Insider Connection @Trove

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Extend and optimize the current ELT pipeline to assemble complex data sets for various business and data analytics requests. Monitor pipeline performance and troubleshoot data issues.

Design and develop data marts based on business requirements and data architecture principles. Optimize schema and queries for performance and scalability.

Perform data validation and quality assurance to ensure data accuracy and integrity.

Create and maintain documentation for data mart designs, ETL processes, and data mappings.

Evolve tools, practices, and processes to support catalog quality and freshness for the Catalog Integration team.

Stay updated on the latest data engineering technologies and best practices.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data ModelingData WarehousingSQLDbtRedshift AdministrationPerformance TuningAWSAthenaS3Data GovernanceProblem-SolvingCommunicationCollaborationSnowflakePythonRedshiftLookerECommerce

Required

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)

Familiarity with data governance practices and principles

Strong analytical skills and problem-solving aptitude with excellent communication and collaboration skills