Data Engineer

## Company Description

Pattern is the premier partner for global ecommerce acceleration and is headquartered in Utah's Silicon Slopes tech hub—with offices in Asia, Australia, Europe, the Middle East, and North America. Valued at $2 billion, Pattern has been named one of the fastest growing tech companies in North America by Deloitte and one of best-led companies in America by Inc. More than 100 global brands—like Nestle, Sylvania, Kong, Panasonic, Sorel, and Pandora—rely on Pattern's global ecommerce acceleration platform to scale their business around the world. We place employee experience at the center of our business model and have been recognized as one of America's Most Loved Workplaces®.

## Job Description

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.

## Essential Duties And Responsibilities

- 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

## Required Qualifications

- Bachelor’s Degree in Data Science, Data Analytics, Information Management, Computer Science, Information Technology, related field, or equivalent professional experience
- 2+ 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

## Preferred Qualifications

- 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, BigQuery, or Snowflake
- Familiarity with modern data platforms like Redshift, BigQuery, or Snowflake

## What is the hiring process?

- 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

## How can I stand out as an applicant?

- 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)

## 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. 

Pattern is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.