Senior Data Engineer

Carmichael Lynch, Inc.; Minneapolis, Northern (MN, KY); Hybrid; USD 105,000 - 135,000; Full time

Job summary

Carmichael Lynch, Minneapolis, is seeking a Senior Data Engineer to design and build data solutions that connect media, site, and marketing performance data into actionable insights. You will partner with analytics, strategy, media, and client teams to architect scalable systems that support marketing decisions.

The role requires hands-on engineering with SQL, Python, BigQuery and GCP, plus experience building production data pipelines and dashboards.

Qualifications

• 6+ years of data engineering or related work in analytics
• Expert-level SQL and Python skills
• Experience with digital marketing data and analytics
• Strong data modeling and pipeline design
• Experience with BigQuery and GCP

Responsibilities

• Design data solutions that connect media, site, and marketing data into actionable insights
• Build scalable data models and pipelines across platforms
• Collaborate with analytics, media, and client teams to meet objectives
• Develop and maintain reporting and dashboards using Tableau/Looker/Power BI
• Evaluate new data sources and optimize data quality and governance

Skills

SQL

Python

BigQuery

GCP

Data pipelines

Marketing analytics

Education

Bachelor's degree or equivalent in related field

Tools

Tableau

Looker

Power BI

Job description

## Senior Data EngineerApplyremote type: Hybridlocations: Minneapolis, Minnesota, United States of Americatime type: Full timeposted on: Posted 30+ Days Agojob requisition id: 351027-MD**Agency:**Carmichael Lynch **Job Function:**Data and Analytics **Job Subfunction:**Data Science and Analytics**Job Description:**Summary of Job: As a senior analytics engineer, you’ll work across a dynamic client roster designing and building data solutions that connect media, site, and marketing performance data into actionable insights. You will partner closely with analytics, strategy, media, and client teams to architect scalable data solutions that answer business questions and support marketing decision-making. This role requires a hands-on, solution-oriented engineer who combines deep technical expertise with a strong understanding of media and digital analytics. The ideal candidate proactively identifies opportunities, solves complex data challenges, and helps shape how data is leveraged across the agency and for our clients. What You’ll Do: Design data solutions that solve client business needs Partner with analytics and media teams to understand business objectives and translate them into scalable data solutions. Design data models that integrate media, site, sales, and media conversion data to provide a complete view of marketing performance. Recommend and implement measurement approaches that support both agency and client objectives. Serve as a subject matter expert on media and marketing data architecture. Lead media data engineering initiatives Build and maintain integrations across major advertising, analytics, and marketing technology platforms. Develop scalable frameworks for campaign performance measurement, attribution, audience analysis, and optimization. Evaluate emerging platforms, APIs, and data sources to improve agency capabilities and client outcomes. Build and maintain data pipelines Automate reporting pipelines with speed, accuracy, and scalability in mind. Demonstrate best practices in data engineering and account for considerations specific to media and site data in every step of the automation process. Write and optimize SQL views, Python/R scripts, and API connectors as needed. Continually optimize data cleaning and anomaly detection processes. Help manage and advance our GCP infrastructure, particularly with BigQuery and GCP integrations. Own data quality and governance Enforce naming conventions, dataset groupings, versioning, and access standards. Maintain rigorous QA practices to ensure clean, reliable, and consistent data. Continuously seek opportunities to improve processes and infrastructure. Solve problems relentlessly Proactively catch and investigate issues, find root causes, and go beyond surface solutions. Work with analysts to anticipate needs and ensure data is easy to find and use. Demonstrate situational awareness and know when to escalate, push or pull back, or execute. Communicate effectively with less technical stakeholders to address challenges and keep them updated on progress. You Could Be a Good Fit If: You take ownership of data quality and availability like it’s mission critical. You already are, or have the drive to become, an expert in media data. You’re a problem-solver who doesn’t stop at “it’s broken.” You figure out why and how to fix it. You balance speed and accuracy, knowing both matter in a client-driven environment. You’re adaptable, resourceful, and curious. You’re able to figure things out with limited direction. Learning new things and finding creative solutions are some of your favorite parts of your job. Requirements Education: A bachelor’s degree preferred or equivalent work experience in related field such as computer science, data science, mathematics/statistics, marketing analytics, etc. Skills and Experience: 6+ years of experience in data engineering, marketing analytics, media analytics, or related disciplines. Agency experience strongly preferred. Expert-level SQL and Python skills with experience developing scalable production-grade data pipelines. Deep experience working with digital media data, including campaign delivery, audience, conversion, and attribution datasets. Proven experience designing and implementing data solutions that support media planning, optimization, measurement, and reporting. Strong understanding of digital marketing ecosystems, including platforms such as Google Ads, CM360, DV360, The Trade Desk, Meta, LinkedIn, Adobe Analytics, and Google Analytics 4. Experience integrating multiple data sources, including media, site analytics, offline conversion, and first-party customer data. Deep experience with BigQuery, GCP, or similar cloud-based data warehouse environments. Experience evaluating client business requirements and translating them into scalable technical solutions. Experience building data products, automated reporting frameworks, and measurement solutions for internal and external stakeholders. Experience with dashboarding and visualization tools such as Tableau, Looker, Power BI, or similar. Competencies (Characteristics and Work Style): Understands both the technical and business implications of data solutions. Recommends approaches rather than simply execute requirements. Builds credibility with clients and internal stakeholders through expertise and thoughtful problem solving. Demonstrates ownership, initiative, and accountability from project inception through delivery. Influences decisions and challenges assumptions when a better solution exists. The salary range for this position is listed below. Where an employee or prospective employee is paid within this range will depend on a variety of factors, including but not limited to budget, relevant experience, qualifications, and tenure in similar roles. Consideration may also be given to internal salary data for current or former employees in the same or similar positions. Salary Range: $105,000 - 135,000 annually$105,000.00 - $135,000.00 *Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom’s corporate group already require five days of in-office attendance.* Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed, and we’re focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice. Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice **For US Job Seekers:** *It is the policy of Omnicom and any of its affiliates to provide equal employment opportunities to all employees and applicants for employment without regard to race, religion, color, ethnic origin, gender, gender identity, age, marital status, veteran status, sexual orientation, disability, or any other basis prohibited by applicable federal, state, or local law. EOE/AA/M/D/V/F.*