Data Engineer

If this is the job for you, send us an email at careers@perfectco.com with your resume and cover letter (PDF or docx only). Be sure to include the position that you're applying for in the subject line. If we think you're a perfect fit for our team, we'll reach out soon!

Type of Job

Full Time

Published Date

May 1, 2021

About the job

We are looking for a Data Engineer who is passionate about using data to propel businesses forward. You will join a dynamic and fast-paced environment and work with cross-functional teams to implement data flows, build and support our analytics products and help extend our data infrastructure.

Requirements

Responsibilities: 

  • Design, build, and deploy efficient reliable data pipelines.

  • Apply automated monitoring and data integrity checks.

  • Work closely with Data Architect and Report Analysts to support internal and external analytics and reporting products.

  • Assemble and transform large, complex data sets that meet functional business requirements.

  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Cloud technologies

  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, reliability and performance.

  • Work with 3rd-party data providers to implement data integrations.

  • Work with stakeholders including the Product Management, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.


The Ideal Background:

  • 3+ years of experience in data engineering, building relational and/or reporting databases and data pipelines.

  • A degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.

  • PostgreSQL and MySQL experience is preferred, SQLite is nice to have; Snowflake experience is a plus. Engineers with experience in other flavors of SQL are welcome if they are willing to climb the learning curve.

  • Strong working SQL knowledge required including query authoring and experience using stored procedures, functions, and triggers in multi-schema databases.

  • Solid AWS familiarity (EC2, S3, EFS, RDS, DynamoDB, Lambda, Redshift, Kinesis), with hands-on experience deploying and enhancing cloud infrastructure. AWS certification a plus.

  • Experience working on large scale, data-driven applications including elements like real-time streaming, batch data aggregation, data modeling, data cleaning, anomaly detection and bulk ingestion.

  • Experience building, deploying monitorable ETL processes.

  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Benefits

Perfect Company’s office is located in downtown Vancouver, WA housed in a historic building in close proximity to Esther Short Park and numerous local restaurants. You will join a small team of jolly folks who enjoy working with each other and building products clients love. We offer a generous range of benefits including:

  • Competitive Salary

  • Stock  Options

  • Medical and dental insurance coverage

  • 401k with match

  • Paid Holidays & Flexible PTO Policy

  • Casual and Friendly Work Environment

  • Opportunity to grow with a start-up company and be actively involved

About us

From the stockroom to the kitchen to the customer, Perfect Company provides technology solutions addressing operational challenges for the restaurant and hospitality industries. Our software platforms give operators new levels of control, visibility and actionability over food preparation, cooking and pickup processes, helping make restaurants and other foodservice settings more efficient, effective and profitable.

Perfect Company is an Equal Employment Opportunity (EEO)/Affirmative Action employer. All qualified applicants will receive fair and impartial consideration without regard to race, color, sex, gender identity, religion, national origin, age, sexual orientation, disability, veteran status, or any other characteristic protected by law.