Job Description
Job Description Job Title: Data Engineer
Location-Type: Remote (EST hours preferred)
Start Date Is: ASAP
Duration: Permanent
Compensation Range: $125-140 K
Job Description:
- Create data pipelines that make data available for analytic and application use cases
- Develop self-healing, resilient processes that do not require constant care and feeding to run smoothly
- Create meaningful data quality notifications with clear actions for interested parties including other internal teams and other members of the data and analytics team
- Lead projects from a technical standpoint, creating project Technical Design Documents
- Support data analysts and analytics engineers ability to meet the needs of the organization
- Participate in code reviews, understanding coding standards, ensuring test coverage and being aware of best practices
- Build or implement tooling around data quality, governance and lineage, in the dbt framework and Snowflake but external to that as needed
- Provide next level support when data issues are discovered and communicated by the data analysts
- Work with data analysts and analytics engineers to standardize transformation logic in the dbt layer for consistency and ease of exploration by end users
- Enable analytics engineers and data analysts by providing data modeling guidance, query optimization and aggregation advice
Requirements:
- 3 years of experience in a data engineering role
- Strong Python skills (Understands tradeoffs, optimization, etc)
- Strong SQL skills (CTEs, window functions, optimization)
- Experience working in cloud environments (AWS preferred, GCS, Azure)
- An understanding of how to best structure data to enable internal and external facing analytics
- Familiarity with calling APIs to retrieve data (Authentication flows, filters, limits, pagination)
- Experience working with DevOps to deploy, scale and monitor data infrastructure
- Scheduler experience either traditional or DAG based
- Comfortable working with multi-TB cloud data warehouses (Snowflake preferred, Redshift, Big Query)
- Experience with other DBMS systems (Postgres in particular)
- Ability to travel up to approx 15%
Nice to haves:
- Experience with web analysis such as creating data structure that support product funnels, user behavior, and decision path analysis
- Understanding of Snowflake external stages, file formats and snowpipe
- Experience with orchestration tools particularly across different technologies and stacks
- Experience with dbt
- Knowledge of Ad Tech, Google Ad Manager and all of it's fun quirks (so fun)
- The ability to make your teammates laugh (it wouldn't hurt if you were fun to work with is what I'm saying)
- Familiarity with event tracking systems (NewRelic, Snowplow, etc)
- Experience with one or more major BI tools (Domo, Looker, PowerBI, etc.)