Data Engineer II

Detail Page LLC; Utah; On-site; USD 90,000 - 130,000; Full time

Job summary

DetailPage LLC is seeking a Data Engineer to design, build, and optimize scalable ETL/ELT pipelines across AWS services (Aurora, Redshift, Glue) to keep data flowing to engineering, analytics, and product teams powering AI-assisted insights behind DetailPage's platform. You will design, develop, and maintain data pipelines, support ETL/ELT processes, and collaborate with cross-functional teams.

Proficiency in Python, SQL, Pandas, PyTest, FastAPI, and IaC tools like CDK/Terraform is required.

Qualifications

• Sufficient SQL expertise for complex queries and optimization.
• 2-3 years of Data Engineering experience with AWS and Python.
• Linux scripting and container basics.
• Experience with data APIs and testing practices.

Responsibilities

• Design, develop, and maintain scalable data pipelines on AWS.
• Work with Aurora, Redshift, and Glue for large-scale data.
• Develop and optimize ETL/ELT for multi-source integration.
• Collaborate with engineering, analytics, and product teams.
• Use Python, SQL, and Pandas for data manipulation and automation.
• Implement unit tests with PyTest to ensure reliability.
• Manage API integrations with FastAPI.
• Assist with IaC using CDK and Terraform.
• Build CI/CD pipelines with Jenkins.

Skills

SQL mastery

Data Engineering

Python

Linux

Git

ETL/ELT

Unit testing

Tools

PySpark

Pandas

SQLAlchemy

Job description

Design, build, and optimize scalable ETL/ELT pipelines across AWS(Aurora, Redshift, Glue) that keep data flowing reliably to ourengineering, analytics, and product teams — powering the AI-assistedinsights behind DetailPage's patented content optimization platform.

Overview

DetailPage.com helps Amazon brands grow organic traffic throughcontent optimization and market segment share insights, using apatented (US Patent No. 12,093,340), AI-assisted process to identifyhigh-traffic keywords and rewrite product content for sustainableorganic growth. We're looking for a Data Engineer to build andoptimize scalable data pipelines, support our ETL/ELT and APIprocesses, and keep data flowing seamlessly across our organizationand to our end users — working closely with engineering, analytics,and product.

What you'll do

• Design, develop, and maintain scalable data pipelines using avariety of AWS services
• Work with relational databases such as Aurora (PostgreSQL),Redshift, and AWS Glue for large-scale data management
• Develop and optimize ETL/ELT processes for smooth data integrationfrom multiple sources
• Collaborate with cross-functional teams to ensure data accessibilityand integrity across platforms
• Use Python, SQL, and Pandas for data manipulation, analysis, andworkflow automation
• Implement unit testing (PyTest) to ensure code reliability
• Manage API integrations and development using FastAPI
• Assist with infrastructure as code (IaC) using CDK and Terraform
• Build CI/CD pipelines in Jenkins

What we're looking for

• SQL mastery – expertise in complex SQL queries and database optimization
• 2-3 years of experience in Data Engineering with AWS and Python
• Linux proficiency – comfortable with shell scripting, common CLItools, and building/testing Linux-based Docker images
• Advanced Python – strong hands‑on experience, ideally with DataEngineering tools like PySpark, Pandas, and SQLAlchemy
• Git proficiency – comfortable with version control, branching,and collaboration
• ETL/ELT experience – proven ability to build and optimizeextract, transform, and load processes
• Unit testing – familiarity with PyTest or similar tools

Nice to haves

• AWS experience with Aurora (PostgreSQL or MySQL), Redshift, Fargate,Lambda, SQS, and IAM, plus tools like Boto3 and the AWS CLI
• Airflow expertise, particularly AWS Managed Airflow, for schedulingand orchestrating data workflows
• API development experience with API Gateway and FastAPI
• Infrastructure as Code experience with CDK or Terraform
• Familiarity with caching tools like Redis
• Basic DevOps knowledge for CI/CD pipelines and dev workflow optimization
• Familiarity with DBT

Compensation

Compensation and equity details to be finalized by hiring team.