Company Overview:

OPTIVATIONS is a PE-backed, full-service marketplace management firm and one of the largest multi-brand sellers on the Amazon marketplace. Trusted by some of Amazon’s most successful brands, the company supports marketplace strategy creation and execution. We are a fact-based, highly analytical firm with a consultative approach to problem-solving, project management, communication, and performance management. Not only does the company provide comprehensive operations leadership, it also offers clients critical thinking and analysis at a level that sets them apart from other competitors within the space.

Position Overview:

The Data Engineer joins a tech team that includes a BI Developer, DevOps Engineer, Full Stack Engineer, and Tech Lead. This role is for a highly autonomous individual. They will own projects end-to-end and are trusted to deliver without close oversight.

The position encompasses the full data lifecycle: data ingestion through Airbyte, pipeline orchestration in Airflow, model building in dbt Cloud, optimization of the Redshift warehouse, and insight delivery via Power BI. The successful candidate takes pride in their craft and holds themselves to a high standard.

Responsibilities (including, but not limited to):

• Build and maintain data pipelines using Airbyte and Airflow
• Ensure data quality through validation, transformation, and monitoring
• Proactively identify and resolve data integrity issues before they impact downstream users
• Develop and maintain dbt models, macros, and tests in dbt Cloud
• Design efficient, well-documented Redshift views and tables for analyst consumption
• Establish and enforce data modelling best practices across the warehouse
• Create and maintain Power BI dashboards and reports
• Partner with analysts and stakeholders to translate business questions into actionable insights
• Optimize report performance and ensure data accuracy
• Take full ownership of projects from requirements through delivery
• Work closely with analysts who pull data via Power Query/Excel
• Mentor and support the broader team on data best practices
• Contribute to architectural decisions and long-term data strategy