Data Engineer

Summary

Join Wpromote's Technology team as a Data Engineer to design data engineering solutions for enterprise clients across MarTech and AdTech platforms. You will plan data flow across clients' MarTech stacks for use in Polaris, build data models using BigQuery and dbt, and design them for reporting, apps, and media forecasting. This role requires expertise in data development and challenges of learning new MarTech platforms. Wpromote prioritizes a strong work-life balance and offers a remote-first culture with unlimited PTO, flexible schedules, and 100% paid parental leave. The anticipated annual salary ranges from $87,000-$105,000, and the total compensation package includes benefits and an annual performance bonus. This position may be performed remotely in most US states, with office hubs in Los Angeles, Chicago, and New York offering in-person collaboration opportunities.

Requirements

• 3-5 years of experience in reporting, BI, or data engineering
• Experience with SQL, database design, and data manipulation methodologies
• Experience working with API calls for the purposes of gathering and storing large datasets (batch or streaming)
• Experience with at least one cloud platform (BigQuery, Snowflake, Redshift, etc.)
• Experience with at least one programming language (Python, R, AppScript, JavaScript, etc.), preferably JavaScript or Python
• Familiarity with data engineering and workflow management frameworks (Airflow, dbt)
• Knowledge of database and data warehousing design and management
• Understanding of ETL process and data modeling experience using SQL
• Attention to detail with the ability to debug and troubleshoot code/queries
• A collaborative mentality with the ability to work independently
• General business and marketing data acumen including an understanding of common marketing goals, KPIs, and tactics

Responsibilities

• Gathering data source, data joining, data model, and data transformation requirements from stakeholders (clients and internal teams) and working with the visualization team to develop dashboards and validate data quality
• Managing and monitoring multiple data pipelines and ETL tasks related to multiple client data streams
• Assisting in the creation of a reliable and scalable infrastructure for data model builds, data set QA, and data set outputs
• Working with internal stakeholders to understand and then execute against data transformation, data model, and inbound/outbound data pipeline requirements

Preferred Qualifications

• Experience with digital analytics tools (Google Analytics, Adobe Analytics)
• Experience with Project Management Platforms (JIRA, Asana)
• Knowledge/experience in the digital marketing industry
• Curiosity to continuously learn more about digital marketing and marketing technology

Benefits

• Remote-first culture
• Unlimited PTO
• Extended Holiday break (Winter)
• Flexible schedules
• Work from anywhere options
• 100% paid parental leave
• 401(k) matching
• Medical, Dental, Vision, Life, Pet Insurance
• Sponsored life insurance
• Short Term Disability insurance and additional voluntary insurance
• Annual Class Pass credits and more!