RAPP
Senior Data Engineer
Chicago - RAPP · Senior
Sponsorship not specified$110k-$120kDetected 61 days ago
PythonGitDynamoDBRedshiftAWSCloud PlatformsDockerKubernetesCI/CDDevOpsMachine LearningAirflowdbtData EngineeringAI OrchestrationLeadershipCommunicationCollaborationProblem SolvingTime Management
About the role
- The ideal candidate is highly skilled in Python, Apache Airflow, AWS Lambda, DynamoDB, and dbt, and has experience designing reliable data workflows that enable advanced analytics, reporting, and machine learning use cases.
- The ideal candidate will have strong attention to detail, a passion for information management, and the ability to work collaboratively with creative teams to enhance the efficiency and scalability of our asset workflows.
- Ensure high availability, scalability, and performance of data systems.
Responsibilities
- Design, build, and maintain robust ETL/ELT pipelines using Python and Airflow.
- Develop serverless workflows leveraging AWS Lambda for scalable event-driven data processing.
- Implement and optimize dbt models for analytics and transformations.
- Design schemas and manage data in DynamoDB and other cloud-native storage solutions.
- Build workflow orchestration strategies using Airflow for scheduling and monitoring pipelines.
- Implement data validation, testing, and monitoring frameworks.
- Employee may perform other related duties as negotiated to meet the ongoing needs of the organization.
Requirements
- 5-8+ years of experience in data engineering, software engineering, or a related role.
- Solid experience with DynamoDB (schema design, performance tuning, scaling).
Nice to have
- Exceptional attention to detail and organizational skills.
- Strong written and verbal communication skills, with the ability to explain complex metadata systems to non-technical users.
- Ability to work collaboratively and cross-functionally with creative, marketing, and IT teams.
- Proactive problem-solver who can identify issues and suggest improvements.
- As such, we have the option to work from home two days per week, if we'd like.
- This range is specific to Chicago and multiple factors are considered in making compensation decisions including, but not limited to: skill set, experience and training, certifications
Skills
- Strong expertise in Python for data engineering and automation.
- Hands-on experience with Apache Airflow for orchestration.
- Proficiency with AWS Lambda and serverless design patterns.
- Strong knowledge of dbt for transformation and analytics modeling.
- Experience with cloud environments (AWS preferred).
- Familiarity with CI/CD workflows, Git, and DevOps practices.
- Strong problem-solving and communication skills.
- Experience with other AWS services (S3, Glue, Redshift, Kinesis).
- Familiarity with data warehouse and data lake architectures.
- Exposure to real-time streaming and event-driven data pipelines.
- Knowledge of containerization (Docker, Kubernetes).
Compensation
- A reasonable estimate of the salary for this role, at the time of posting, is $110,000 - $120,000.
Benefits
- For more information regarding Omnicom benefits, please visit www.omnicombenefits.com.
- RAPP provides a competitive salary and comprehensive benefits plan.
Company info
- We are RAPP - world leaders in activating growth with precision and empathy at scale.
- As a global, next-generation precision marketing agency we leverage data, creativity, technology, and empathy to foster client growth. We champion individuality in the marketing solutions we create, and in our workplace. We fight for solutions that adapt to the individual's needs, beliefs, behaviors, and aspirations.
- We foster an inclusive workplace that emphasizes personal well-being.
- As a global, next-generation precision marketing agency we leverage data, creativity, technology, and empathy to foster client growth.
- We champion individuality in the marketing solutions we create, and in our workplace.
- We fight for solutions that adapt to the individual's needs, beliefs, behaviors, and aspirations.
- At RAPP, our fearless superconnectors help to create value from personal brand experiences by focusing on three key areas: connected data, connected content and connected decisioning.
- Our data analysts identify who that person is, our strategists understand what they want, and our award-winning technologists and creatives know how to deliver it - ensuring we're able to activate authentic customer connections for our clients.
- Part of Omnicom's Precision Marketing Group, RAPP is comprised of 2,000+ creatives, technologists, strategists, and data and marketing scientists across 15+ global markets.
- We are looking for a Senior Data Engineer with deep expertise in building scalable, cloud-native data pipelines and platforms.
- RAPP's current hybrid model is designed to enable in-person connections and collaboration that is core to our culture, while also supporting flexibility for all employees.
This listing is sourced directly from RAPP's careers page and normalized into a canonical job model.