Business Intelligence Engineer

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

Qualifications (including, but not limited to):

• 4+ years of experience in BI, analytics engineering, or data engineering
• Strong SQL skills with experience writing complex queries and optimizing performance
• Hands-on experience with dbt (dbt Cloud preferred)
• Experience with a cloud data warehouse (Redshift preferred)
• Experience building dashboards in Power BI or similar tools
• Familiarity with pipeline orchestration tools (Airflow preferred)
• Understanding of dimensional modelling and data warehouse design patterns
• Experience with Airbyte or similar data ingestion tools
• Comfort with version control (Git) and collaborative development workflows

Preferred Qualifications:

• Experience working with e-commerce or marketplace data

OPTIVATIONS offers a full range of benefits, including:

• Annual performance bonus (discretionary, paid based on personal and firm performance)
• 401(k) program with company match up to 4% of compensation 
• Health, life, disability, vision, and dental insurance coverage
• Seven paid holidays annually 
• Unlimited paid time off as defined in the company’s “Responsible Adult Policy” (subject to certain notice requirements and guidelines)
• Flexible remote-work and work-from-home policies for eligible positions