Business Intelligence Analyst (Analytics Engineer)

Turnitin; Chicago (IL); Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

Social impact programs

Charity donation matching

Paid volunteer days

Employee Resource Groups

Great Place To Work community

Virtual and in-person team events

Tuition reimbursement

Learning festival

Remote-first work arrangement

Mental health & coaching support

Wellness/Home office allowance

Company & national holidays

Self-care days

Job summary

Turnitin is seeking an Analytics Engineer/BI Analyst to bridge data infrastructure with business strategy. You will migrate workflows from Alteryx to dbt, build robust models in Redshift, and orchestrate pipelines with Dagster or Airflow.

Collaborate with RevOps to translate data into ROI-driven insights and explore AI/LLM applications using SageMaker. You’ll partner with Sales, Marketing, and Customer Experience to enhance ABM, customer health scoring, and KPI visibility through Tableau

Qualifications

• 5+ years of BI/analytics engineering experience.
• Strong SQL and data warehousing skills (Redshift preferred).
• Experience building production-ready data models with dbt.
• Hands-on ETL/ELT orchestration with Dagster or Airflow.
• Translate complex data into actionable insights for RevOps.
• Familiarity with Salesforce data structures and Tableau dashboards.

Responsibilities

• Migrate legacy workflows from Alteryx to dbt with quality documentation.
• Build robust data models and maintain the data warehouse.
• Orchestrate data pipelines and monitor performance in Redshift.
• Collaborate with Sales, Marketing and Customer Experience to enable data-driven decisions.
• Explore AI/LLM capabilities and integrate predictive analytics (SageMaker).
• Translate data outputs into ROI-focused insights for leadership.

Skills

Advanced SQL

Analytics engineering

Stakeholder storytelling

Data visualization

Problem solving

Curiosity

Ownership

Tools

Dagster

Airflow

Tableau

dbt

Salesforce

Amazon Redshift

Snowflake

BigQuery

Job description

• The purpose of this role is to bridge the gap between complex data infrastructure and actionable business strategy. You will provide day-to-day support to Revenue Operations (RevOps), including Sales, Marketing, and Customer Experience leaders
• We are currently in an exciting transition, migrating our data workflows from Alteryx to dbt. As a BI Analyst, you will sit at the intersection of data engineering and business analysis. You aren’t just a “dashboard builder”; you are an Analytics Engineer who builds robust data models in Redshift, orchestrates workflows via Dagster/Airflow, and works directly with stakeholders to translate technical outputs into business impact
• Crucially, you will help us move beyond standard reporting. We are looking for someone genuinely excited about the frontier of AI and LLM capabilities, helping us integrate predictive analytics and machine learning (via Amazon SageMaker) into the RevOps ecosystem
• Data Modeling & Migration: Lead the migration of legacy workflows from Alteryx to dbt, ensuring high-quality, documented, and tested data models that serve as a single source of truth
• Orchestration & Pipelines: Manage and monitor data pipelines using Dagster or Airflow to ensure reliability and performance within our Redshift warehouse
• Stakeholder Collaboration & Translation: Act as the primary liaison between technical data structures and non-technical leaders. You will translate complex “data speak” into clear insights that highlight ROI and business impact
• AI & Advanced Analytics: Actively explore and implement AI/LLM capabilities to enhance data discovery and predictive modeling. Collaborate with Product/Engineering to apply Machine Learning (SageMaker) to areas like churn prediction and lead scoring
• RevOps Strategy: Support high-impact initiatives such as Account Based Marketing (ABM) and Customer Health scoring by providing visibility into globally symbols KPIs via Tableau

Benefits

• Social impact programs
• Charity donation matching
• Paid volunteer days
• Employee Resource Groups
• Great Place To Work community
• Virtual and in-person team events
• Tuition reimbursement
• Action & Ownership recognition
• Focused development plan
• Access to LinkedIn Learning
• Annual learning festival
• Remote-first working arrangements
• Mental health & coaching support
• Wellness/Home office allowance
• Company & national holidays
• Self-care days

• SQL & Data Warehousing: Advanced SQL skills and experience with Amazon Redshift (or Snowflake/BigQuery)
• Impact-Focused: You don’t just deliver data; you deliver the “so what?”
• Orchestration Tools: Hands-on experience with Dagster or Airflow
• CRM Knowledge: Familiarity with Salesforce data structures
• AI Enthusiast: You stay up to date with the latest in LLMs and are constantly thinking about how to apply generative AI to analytics workflows
• Experience: 5+ years of professional experience in Business Intelligence, Analytics Engineering, or a related data role
• Curiosity & Ownership: You lead with questions and take pride in the “cleanliness” and architecture of your code
• The “Technical Translator”: You can explain a join or a latent variable to a Sales Director in a way that makes sense for their quota
• BI Visualization: Experience building stakeholder-facing dashboards in Tableau
• Dbt Expertise: Proven experience building and maintaining production‑grade data models using dbt