Sr. Data Engineer

Tandem Theory; Dallas (TX); Vor Ort; USD 130.000 - 190.000; Vollzeit

Benefits dieser Stelle

85% employer paid medical

Vision and dental insurance

Company paid STD/LTD

401(k) retirement plan

Zusammenfassung

Tandem Theory in Dallas, TX seeks a Senior Data Engineer to lead data pipelines and client-integrated solutions. You’ll own data platforms for several clients, translate business goals into data strategies, and set expectations with stakeholders.

This hands-on role combines engineering leadership without direct reports, with strong SQL, Python, Airflow, and cloud data warehousing skills. You’ll work directly with clients, review code, and design scalable data solutions that drive measurable

Qualifikationen

• 4–5+ years hands-on data engineering experience.
• Advanced SQL with performance tuning and procedures.
• ETL/ELT development in SQL and Python, with Airflow.
• Experience with AWS and Google Cloud (GCP).
• Proactive client interaction and requirement handling.

Aufgaben

• Lead client work and own data pipelines for multiple clients.
• Translate business goals into data solutions and set scope with clients.
• Collaborate with analysts, engineers and managers across the agency.
• Design, build and maintain data pipelines and integrations.
• Move and model data across platforms using established ETL/ELT patterns.

Kenntnisse

ETL/ELT development

SQL

Python

Airflow

Cloud data warehouses

Client communication

Ausbildung

Bachelor's degree in CS or Information Systems

Tools

PostgreSQL

SQL Server

Snowflake

Google BigQuery

dbt

AWS

GCP

Jobbeschreibung

Our Senior Data Engineer is a hands-on, client-facing technical lead. You’ll own data pipelines and integrations for several clients at once. You’ll step into established client work, get up to speed quickly, and keep delivery moving while improving what’s already there.You’ll be the trusted technical voice with clients. That means translating their business goals into data solutions, setting clear expectations on scope and effort, and bringing a point of view on how their data should work for them.This is an individual contributor role reporting to the SVP of Tech and Data. You’ll lead through expertise and influence rather than direct reports, keeping engineering work on agreed architectural paths.We’re looking for a modern-day ETL/ELT developer who works comfortably in today’s analytical environment and understands the marketing landscape, where disparate data is everywhere. You build with AI-assisted coding tools every day and help the team use them well. We do whatever it takes to solve problems, while embracing change each day.What you will doLead client workOwn data engineering for multiple clients and projects at once, from requirements through delivery and ongoing supportWork directly with clients to understand their business goals, and give them a clear, specific point of viewNegotiate scope and level of effort with clients and internal teams so everyone agrees on what gets delivered and whenCollaborate closely with analysts, engineers and managers across the agencyLook past day-to-day tasks to the business results the work needs to deliverBuild and own data platformsDesign, build and maintain data pipelines and integrations with complex source data and API servicesTake ownership of established client pipelines: reverse engineer existing SQL and pipeline code to understand its business logic, and document it as you goMove and model data across platforms using established ETL/ELT patterns, orchestrated with Apache AirflowRecommend and design database solutions, and handle performance tuning, troubleshooting and capacity estimationKeep engineering work on agreed architectural paths and follow our data warehouse development standardsMaintain documentation for data movement and transformation processes, including process flows and data mappingManage priorities, access and qualitySet priorities for your projects and tasks, and push back when needed to protect the right priorities and workflowSet the criteria for who is added to or removed from client data services and systemsCreate and manage audit reporting and quality checks so data is delivered accurately and consistentlySolve problemsIdentify challenges and limitations in the tools we use, and propose fixesSpot roadblocks early that could affect deadlinesBreak complex work into clear tasks and coordinate them with the teamWork with teammates and external partners to troubleshoot quickly and keep delivery on trackStay aheadUse AI coding assistants as a core part of your development work, and contribute to the team’s AI best practicesIdentify relevant new technology and share what you learn with the teamWhat you should haveBachelor’s degree or equivalent combination of education and experience preferred, in computer science or information systems4–5+ years of hands-on data engineering experienceExperience with RDBMS and cloud data warehouses such as PostgreSQL, SQL Server, Snowflake and Google BigQueryETL/ELT development in SQL and Python, with orchestration in Apache Airflow; familiarity with dbt is helpfulExperience with AWS and GCP, with strong hands-on experience in at least oneAdvanced SQL, including stored procedures, indexing and database IO performance tuningSolid understanding of data warehouse design principles and relational and non-relational data modelsRegular use of AI-assisted coding tools in your development work, with sound judgment about reviewing and testing what they produceExperience working directly with clients or business stakeholders on requirements, scope and timelinesProven ability to own several projects at once through deliveryAbility to proactively identify, troubleshoot and resolve complex data integrity issuesThe ability to leverage cut and paste proficientlyStrong analytical skills, with the ability to explain technical details to non-technical audiencesExcellent verbal and written communication skillsAbility to work with minimal supervision in an agile environment and pivot quickly as analytical needs changeA big plus if you have any of the followingAgency and marketing data experienceAPI developmentDBA duties and responsibilitiesExperience taking over and documenting systems someone else builtHere is a little bit about usTandem Theory is an agency with a winning culture. We believe that when the agency wins, Theorists win too. Winning happens through collaboration, personal growth, industry recognition, and operational excellence that makes our work stronger and more efficient. Most importantly, a winning culture thrives on feedback - helping each other improve so we can all achieve more together.We’ve built our culture around three core behaviors: Teamwork, Transparency, and Trust. They’re not just words on a poster. We apply them every day to guide our internal and client relationships, and our clients tell us they feel the difference.Headquartered in Dallas, Texas, Tandem partners with several leading brands. These brands value working with an agency led by a proven team that provides simple but impactful solutions, transparent pricing, and performance-based compensation.Other than waking up and being excited to get to work each day, here are some additional benefitsThe salary for this exempt-level position will be based on experience and qualifications within an established pay range. Benefits include 85% employer paid medical, eligibility to participate in vision and dental insurance as well company paid STD, LTD coverage plus a flat amount company paid toward Basic Life and AD&D, as well as a generous 401(k) retirement contribution plan eligible after 90-days of employment.Working ConditionsWe operate as a work, not live, from anywhere model and utilize the office space as a co-working space as needed. That said, whether in the office or at a remote location, we try to operate in the traditional office norm model. You will be working with a computer, telephone, copier, or other office equipment as necessary for long stretches of time. There may be some occasional long, irregular hours. You are expected to communicate effectively (verbal and written), and maintain professionalism under stress. Occasionally you will need to bend, pull, push and/or reach to access job-related materials. You will also be expected to work with frequent interruptions such as Slack messages, emails, phone calls, drive-by visits to your desk, whether that is from a co-worker at the office or your dog barking while working remotely. All our calls are held on video, as it is important to see facial expressions and reactions to work in a collaborative environment.EligibilityAll new employees must provide documented proof of their identity and employment authorization and pass a background screening process. No work Visa sponsorships available at this time. We are currently not accepting applicants that reside in the State of California.Here is where we are located in case you are curious:Tandem Theory, LLC15400 Knoll Trail #503Dallas, TX 75248#LI-JOB