Data Engineer

Pattern; Lehi (UT); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Unlimited PTO

Paid Holidays

Onsite Fitness Center

Company Paid Life Insurance

Casual Dress Code

Competitive Pay

Health, Vision, and Dental Insurance

401(k) match

Job summary

Pattern is seeking a Data Engineer to join our growing team in Lehi, Utah. You will design, build, and maintain scalable data pipelines, optimizing data flows and supporting data-driven decision making.

A strong 3–5 year background in SQL and data warehousing is essential. Ideal candidates will have hands-on experience with Redshift, BigQuery, or Snowflake, and familiarity with modern data platforms and cloud services like Lambda and Glue.

Qualifications

• Bachelor’s degree or equivalent professional experience in data-related field.
• 3–5 years of experience working with SQL.
• Familiarity with modern data architecture-based data warehouses.
• Experience with Redshift, BigQuery, or Snowflake and understanding of data architecture design.
• Strong communication skills and ability to present data insights clearly.

Responsibilities

• Develop, deploy, and support real-time, scalable data streams into data lake/warehouse.
• Implement data auditing to ensure data quality and troubleshoot large-scale pipelines.
• Collaborate with tech teams to specify data requirements and provide access.
• Tune performance using SQL and profiling tools.
• Build data quality and ownership across assigned areas.
• Work with data infrastructure to triage issues and drive resolution.

Skills

SQL

Data warehousing

Snowflake

Redshift

BigQuery

Tableau

ThoughtSpot

Airflow

Spark

DynamoDB

Cassandra

Lambda

Glue

Elasticsearch

Time series DBs

Data governance

Education

Bachelor’s Degree in Data Science, Data Analytics, Information Management, Computer Science, Information Technology, or related field

Tools

Redshift

BigQuery

Snowflake

SQL

Tableau

ThoughtSpot

Apache Airflow

Spark

Cassandra

DynamoDB

ElasticSearch

Job description

Are you obsessed with data, partner success, taking action, and changing the game? If you have a whole lot of hustle and a touch of nerd, come work with Pattern! We want you to use your skills to push one of the fastest-growing companies headquartered in the US to the top of the list.

Pattern accelerates brands on global ecommerce marketplaces leveraging proprietary technology and AI. Utilizing more than 66 trillion data points, sophisticated machine learning and AI models, Pattern optimizes and automates all levers of ecommerce growth for global brands, including advertising, content management, logistics and fulfillment, pricing, forecasting and customer service. Hundreds of global brands depend on Pattern’s ecommerce acceleration platform every day to drive profitable revenue growth across 60+ global marketplaces—including Amazon, Walmart.com, Target.com, eBay, Tmall, TikTok Shop, JD, and Mercado Libre. To learn more, visit pattern.com or email [e-mail].

Pattern has been named one of the fastest growing tech companies headquartered in North America by Deloitte and one of best-led companies by Inc. We place employee experience at the center of our business model and have been recognized as one of Newsweek’s Global Most Loved Workplaces®.

We are seeking a scrappy and motivated Data Engineer to join our growing team. In this role, you will collaborate with cross‑functional teams to design, build, and maintain scalable data pipelines, manage and optimize data flows, and support data‑driven decision‑making processes. This position is ideal for individuals with some hands‑on experience in data engineering who are eager to grow and develop their technical expertise.

This is a full‑time role and will work a hybrid schedule in Lehi, Utah.

• Develop, deploy, and support real‑time, automated, scalable data streams from a variety of sources into the data lake or data warehouse.
• Develop and implement data auditing strategies and processes to ensure data quality; identify and resolve problems associated with large‑scale data processing workflows; implement technical solutions to maintain data pipeline processes and troubleshoot failures.
• Collaborate with technology teams and partners to specify data requirements and provide access to data.
• Tune application and query performance using profiling tools and SQL or other relevant query languages.
• Understand business, operations, and analytics requirements for data
• Build data expertise and own data quality for assigned areas of ownership.
• Work with data infrastructure to triage issues and drive to resolution.
• Bachelor’s Degree in Data Science, Data Analytics, Information Management, Computer Science, Information Technology, related field, or equivalent professional experience.
• 3-5 years of experience working with SQL.
• Familiarity with implementing modern data architecture‑based data warehouses.
• Familiarity with data warehouses such as Redshift, BigQuery, or Snowflake and understanding of data architecture design.
• Strong communication skills (both in presentation and comprehension).
• Exposure to data visualization tools like Tableau or ThoughtSpot.
• Experience working with time series databases.
• Experience with SQL, including the ability to write stored procedures, triggers, analytic/windowing functions, and tuning.
• Knowledge of Snowflake.
• Familiarity with Big Data, non‑relational databases, Machine Learning and Data Mining.
• Familiarity with cloud‑based technologies including SNS, SQS, SES, S3, Lambda, and Glue.
• Familiarity with modern data platforms like Redshift, Cassandra, DynamoDB, Apache Airflow, Spark, or ElasticSearch.
• Understanding of Data Quality and Data Governance.
• Data Fanatics: Our edge is always found in the data.
• Partner Obsessed: We are obsessed with partner success.
• Team of Doers: We have a bias for action.
• Game Changers: We encourage innovation.
• Game Changers- A game changer is someone who looks at problems with an open mind and shares new ideas with team members, regularly reassesses existing plans and attaches a realistic timeline to goals, makes profitable, productive, and innovative contributions, and actively pursues improvements to Pattern’s processes and outcomes.
• Data Fanatics- A data fanatic is someone who recognizes problems and seeks to understand them through data, draws unbiased conclusions based on data that lead to actionable solutions, and continues to track the effects of the solutions using data.
• Partner Obsessed- An individual who is partner obsessed clearly explains the status of projects to partners and relies on constructive feedback, actively listens to partner’s expectations, and delivers results that exceed them, prioritizes the needs of your partners, and takes the time to create a personable experience for those interacting with Pattern.
• Team of Doers- Someone who is a part of team of doers uplifts team members and recognizes their specific contributions, takes initiative to help in any circumstance, actively contributes to supporting improvements, and holds themselves accountable to the team as well as to partners.
• Initial phone interview with Pattern’s talent acquisition team
• Technical Interview with a member of the team
• Video interview with a hiring manager
• Professional reference checks
• Executive review
• Offer
• Be prepared to talk about professional accomplishments with specific data to quantify examples.
• Be ready to talk about how you can add value and be the best addition to the team.
• Focus on mentioning how you would be partner obsessed at Pattern.
• Be prepared to talk about any side projects related to data and analytics.

Why should I work at Pattern?

Pattern offers big opportunities to make a difference in the ecommerce industry! We are a company full of talented people that evolves quickly and often. We set big goals, work tirelessly to achieve them, and we love our Pattern community. We also believe in having fun and balancing our lives, so we offer awesome benefits that include:

• Unlimited PTO
• Paid Holidays
• Onsite Fitness Center
• Company Paid Life Insurance
• Casual Dress Code
• Competitive Pay
• Health, Vision, and Dental Insurance
• 401(k) match. Pattern matches 100% of the first 3% in eligible compensation deferred and 50% of the next 2% in eligible compensation deferred.

Pattern provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability, status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.