If this is the job for you, send us an email at 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
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.
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.
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:
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
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.