Data Engineer, Warehouse
Seattle, WA
Applications have closed
We process billions of records a day to support business intelligence, data science and machine learning, traffic quality and analytics and do so relying primarily on Python, SQL and Snowflake. However, we are looking to expand into stream processing using the Kafka Streams API, the streams DSL and ksqlDB. Our primary goals are scalability, reliability, usability and performance.
You will be working in a fast paced environment as part of the team of data engineers, designing and implementing solutions that provide business-critical insights. You will be responsible for design of data warehouse schemas as well as end-to-end design and implementation of fault tolerant and scalable data processing pipelines using a variety of technologies for orchestrating data movement, primarily Snowflake, DBT and Airflow.
The Role You Will Have:
- Design and implement data warehouse schemas to store large data sets that can be easily and efficiently queried and joined together for reporting and analytical purposes.
- Design and develop ETL/ELT pipelines to efficiently move and aggregate data, while optimizing for maximum code and data reuse.
- Collaborate with other team members on improvements to existing systems
- Investigate data anomalies and provide quick resolutions.
- Provide technical support to business users and analysts.
What You Will Bring:
- 3+ years of working experience with large scale data warehouse systemsVery strong knowledge of SQL and data manipulation best practices
- Experience in building efficient and fault tolerant ELT/ETL data pipelines
- Very strong knowledge of working with large scale datasets
- Ability to investigate data discrepancies and find the root cause
- Ability to write test cases for data validation
- Ability to write clear documentation
- Very strong knowledge of data modeling and data warehouse design
- Experience with Snowflake is preferable
- Knowledge of DBT, Jinja scripting and Airflow is a big plus
- Ability to translate business requirements into functional specifications
- Ability to quickly adapt to changes in requirements and to effectively work on geographically diverse cross-functional teams
- Excellent written and verbal communication skills
What We Have to Offer:
- Competitive PTO
- 11 Company Holidays
- Untracked sick time
- 100% covered Medical, Dental, Vision for employees
- 401k w/match
- Paid professional development
- Leadership & growth opportunities
- Virtual company and team building events
- #BI-Remote
- #LI-Remote
- #LI-AW1
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow APIs Business Intelligence Data pipelines Data warehouse ELT Engineering ETL Kafka Kinesis Machine Learning Pipelines Python Snowflake SQL
Perks/benefits: 401(k) matching Career development Health care Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open AI Engineer jobs
- Open MLOps Engineer jobs
- Open Data Science Manager jobs
- Open Data Manager jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Principal Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Senior Data Architect jobs
- Open Product Data Analyst jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Manager, Data Engineering jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open ETL Developer jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Privacy-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Snowflake-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open LLMs-related jobs
- Open Data warehouse-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs