Data Engineer - Business Intelligence

Who we are:

Motive empowers the people who run physical operations with tools to make their work safer, more productive, and more profitable. For the first time ever, safety, operations and finance teams can manage their drivers, vehicles, equipment, and fleet related spend in a single system. Combined with industry leading AI, the Motive platform gives you complete visibility and control, and significantly reduces manual workloads by automating and simplifying tasks. Motive serves nearly 100,000 customers – from Fortune 500 enterprises to small businesses – across a wide range of industries, including transportation and logistics, construction, energy, field service, manufacturing, agriculture, food and beverage, retail, and the public sector. Visit gomotive.com to learn more.

About the Role:

We are looking for a passionate and driven Business Intelligence (BI) Data Engineer to join our growing team. In this pivotal role, you will act as the bridge between our complex data and our business domains, including Sales, Marketing, and Operations. You will be responsible for empowering these teams with accurate, reliable, and insightful analytical datasets that drive critical business decisions. Our data landscape is constantly evolving, and we thrive on innovation. This is an exciting opportunity for a proactive individual who is eager to work with a modern data stack, leverage the power of AI to enhance their work, and continuously learn and adapt to new technologies.

What You’ll Do:

• Partner closely with business stakeholders like IT, Customer Support, Marketing, Employee Engagement to understand their challenges and translate requirements into a scalable data architecture.
• Design, develop, and own robust, efficient, and scalable data models in Snowflake using dbt and advanced SQL.
• Build and manage reliable data pipelines using tools like Airflow and Python to ensure data is fresh and trustworthy.
• Implement rigorous testing, documentation, and data governance practices to maintain a single source of truth.
• Empower teams with clean data and well-structured models, enabling them to make data-driven decisions using BI tools like Tableau and Retool.
• Actively explore and integrate AI tools (like Snowflake Cortex AI) to improve data processes, enhance analytics, and uncover deeper insights.

What We’re Looking For:

6+ years of experience in Analytics Engineering, Data Engineering, or a similar role.

• Deep expertise in SQL and developing complex data models for analytical purposes (e.g., dimensional modeling).

Hands-on experience with the modern data stack:

Data Warehousing: Snowflake, BiqQuery Redshift, Databricks (Snowflake preferred) Data Transformation: dbt Orchestration: Airflow Cloud Platform: AWS Programming/Ingestion: Python (especially for API integration), Fivetran, Airbyte

• A strong analytical mindset with a proven ability to solve ambiguous business problems with data.
• Excellent communication skills and experience working cross-functionally.
• Self-starter with the ability to self-project manage work
• A user focus with the ability to understand how a data consumer will use the data products you build
• Bonus Points (Nice-to-Haves)

Experience with large-scale data processing using Spark. Direct experience with advanced Snowflake features (e.g., Snowpark, Cortex AI). Experience building visualizations and dashboards in tools like Tableau, Retool, or Thoughtspot. Experience as a data analyst delivering insights to business users Creating a diverse and inclusive workplace is one of Motive's core values. We are an equal opportunity employer and welcome people of different backgrounds, experiences, abilities and perspectives. Please review our Candidate Privacy Notice here . UK Candidate Privacy Notice here. The applicant must be authorized to receive and access those commodities and technologies controlled under U.S. Export Administration Regulations. It is Motive's policy to require that employees be authorized to receive access to Motive products and technology. #LI-Remote