Data Engineer

Walker Advertising

United States

Remote

USD 85,000 - 90,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

3 Weeks Paid Time Off
12 Weeks of Paid Parental Leave
Comprehensive Insurance Coverage (Med/
401(k) Retirement Savings Plan
Wellness Initiatives/Employee Assist.
Rewards and Recognition Programs
Career Development Opportunities

Job summary

Walker Advertising seeks a Data Engineer to maintain and evolve data pipelines across codeless Domo and code-based dbt environments. You’ll transform raw data into analytics-ready datasets and support reporting accuracy.

You will collaborate with analysts and stakeholders to translate requirements into robust data solutions, ensure data governance, and optimize warehouse costs. This role emphasizes data quality and scalable architecture.

Qualifications

  • Bachelor's degree in CS/IS/Engineering or related field
  • 1–2 years of data engineering or analytics engineering experience
  • Advanced SQL skills with complex joins and performance tuning
  • Knowledge of data warehousing concepts and ETL/ELT patterns
  • Strong troubleshooting skills and attention to data accuracy
  • Clear written and verbal communication with technical and non-technical partners

Responsibilities

  • Build, maintain, and monitor data pipelines and ETL/ELT workflows in Domo and dbt environments
  • Develop and maintain data transformations and models in dbt
  • Ingest data from internal systems, third-party platforms, marketing APIs, and flat files
  • Design and maintain analytics-ready data models for dashboards and self-service analytics
  • Implement data quality checks, validation, and alerting; troubleshoot pipeline failures
  • Optimize query performance, refresh schedules, and warehouse costs
  • Collaborate with analysts and stakeholders to gather requirements and translate them into solutions
  • Maintain data source documentation, lineage, definitions, and processes

Skills

Advanced SQL
Python
Data modeling
ETL/ELT
Data governance
Communication
Git
CI/CD
REST APIs
dbt

Education

Bachelor's degree in CS/IS/Engineering or related field

Tools

dbt Core/Cloud
Snowflake
BigQuery
Looker/Tableau/Power BI
Domo

Job description

About Walker Advertising

For over 40 years, Walker Advertising has helped connect people seeking legal assistance with the right attorneys, partnering with law firms across the country to expand their reach and impact. Founded on Mary Ann Walker Aguirre’s efforts to overcome language barriers and improve access to justice, Walker has grown into a national network of more than 600 law firms, connecting millions of consumers with legal representation. Through trusted brands, innovative marketing, and a commitment to serving diverse communities in both English and Spanish, Walker Advertising helps law firms grow while advancing a larger purpose: creating positive change and expanding access to justice for all.

Role Summary

We are seeking a Data Engineer to maintain and engineer data across both our codeless (Domo) and code-based (dbt) environments. You will build and support reliable data pipelines, transform raw data into trusted, analytics-ready datasets, and partner with analysts and business stakeholders to keep reporting accurate and timely. dbt experience is a plus.

Key Responsibilities
  • Build, maintain, and monitor data pipelines and ETL/ELT workflows in Domo, including Magic ETL dataflows, connectors, and DataSets.
  • Develop and maintain data transformations and models in dbt, following version control, testing, and documentation best practices.
  • Ingest data from internal systems, third-party platforms, advertising and marketing APIs, and flat files into the data warehouse.
  • Design and maintain data models and analytics-ready datasets that support reporting, dashboards, and self-service analytics.
  • Implement data quality checks, validation, and alerting; troubleshoot and resolve pipeline failures and data discrepancies.
  • Optimize query performance, refresh schedules, and warehouse costs across Domo and dbt environments.
  • Partner with analysts, marketing, and business stakeholders to gather requirements and translate them into technical solutions.
  • Maintain documentation for data sources, lineage, definitions, and processes.
  • Apply data governance, security, and access control standards to protect sensitive data.
  • Contribute to the migration of codeless workflows to code-based solutions where it improves scalability and maintainability.
Required Qualifications
  • Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.
  • 1-2 years of experience in data engineering, analytics engineering, or a similar role.
  • Advanced SQL skills, including complex joins, window functions, CTEs, and performance tuning.
  • Working knowledge of data warehousing concepts, dimensional modeling, and ETL/ELT patterns.
  • Strong troubleshooting skills and attention to detail, with commitment to data accuracy.
  • Clear written and verbal communication skills, and the ability to work with technical and non-technical partners.
Preferred Qualifications
  • Experience developing, testing, and deploying dbt models (dbt Core or dbt Cloud).
  • Experience with a cloud data warehouse such as Snowflake, BigQuery, Redshift, or Azure Synapse.
  • Proficiency in Python for scripting, automation, and API integrations.
  • Experience with Git and CI/CD workflows for data projects.
  • Familiarity with orchestration tools such as Airflow, Dagster, or Prefect.
  • Experience with marketing, advertising, or CRM data sources (for example Google Ads, Meta, Google Analytics, or Salesforce).
  • Experience with BI tools such as Domo, Tableau, Power BI, or Looker.
  • Knowledge of data governance, data cataloging, and data observability practices.
Technical Skills and Tools
  • Languages: SQL (required), Python (preferred).
  • Platforms: BI analysis tools, dbt (preferred), cloud data warehouse.
  • Practices: Version control (Git), data testing, documentation, and code review.
  • Integrations: REST APIs, flat files, and third-party marketing and advertising connectors.
Benefits/Perks
  • 3 Weeks Paid Time Off
  • 12 Weeks of Paid Parental Leave
  • Comprehensive Insurance Coverage (Medical, Dental, Vision, etc.)
  • 401(k) Retirement Savings Plan
  • Wellness Initiatives/Employee Assistance Program
  • Rewards and Recognition Programs
  • Career Development Opportunities
Pay Range

$85,000 - $90,000 base salary + 10% annual bonus

AI Disclaimer & Accommodations

We may use AI-enabled tools to assist with certain parts of our hiring process, including application review and candidate evaluation. These tools support our team and are used with human oversight. All final hiring decisions are made by humans. If you require reasonable accommodations during the application process or have questions about our hiring process, please contact OWSC@walkeradvertising.com.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Engineer
Lead Data Engineer

Walker Sands • Boston (MA)

Hybrid
USD 155,000 - 175,000
Hybrid work model
Health insurance
401(k) match
+4
Lead Data Engineer
Lead Data Engineer

walkersands • United States

Hybrid
USD 155,000 - 175,000
Bonus Potential
Hybrid Work
Flexible PTO
+2
Data Analyst
Data Analyst

ADWEEK • New York (NY)

On-site
USD 69,000 - 117,000
Data Engineer, AI & Analytics
Data Engineer, AI & Analytics

powerdigitalmarketing • United States

Remote
USD 110,000 - 180,000
Associate Director, Data Visualization
Associate Director, Data Visualization

Omnicom Media • New York (NY)

On-site
USD 150,000 - 190,000
Medical insurance
Dental insurance
401(k)
+6
Senior Data Engineer
Senior Data Engineer

Throttle Up Technologies, LLC • United States

Remote
USD 100,000 - 160,000
Dental insurance
Health insurance
Life insurance
+2
Senior Staff Data Engineer (Ad Tech Team - AWS experience required)
Senior Staff Data Engineer (Ad Tech Team - AWS experience required)

Warner Bros. Discovery, Inc. • Silver Spring (MD)

On-site
USD 161,070 - 299,130
Health insurance
Wellness program
Life and disability insurance
+3
Data Engineer III - Remote (6001)
Data Engineer III - Remote (6001)

itD • United States

Remote
USD 80,000 - 120,000
Comprehensive medical benefits
401(k) plan
Paid holidays
Senior Data Engineer, Marketing Analytics
Senior Data Engineer, Marketing Analytics

Dun & Bradstreet • Jacksonville (FL)

On-site
USD 100,000 - 130,000
Generous paid time off
Education assistance
401k with company matching
+1
Manager, Data Management & Visualization
Manager, Data Management & Visualization

mediabrands • New York (NY)

On-site
USD 120,000 - 160,000
Medical insurance
Dental coverage
401(k) plan
+6