JPS Tech Solutions · 6 hours ago
ETL Developer II
Chicago, IL
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expJPS Tech Solutions is seeking a Senior ETL Developer to join their Digital Marketing Operations team. This role focuses on designing, building, and optimizing scalable data pipelines and audience delivery solutions for multi-channel marketing campaigns.
Information TechnologyIT InfrastructureSoftware Engineering
No H1B
Responsibilities
Lead the design and development of data extensions and complex SQL queries to create, manage, and optimize audience segments within Salesforce Marketing Cloud (SFMC)
Architect and maintain end-to-end ETL/data workflows, including automated triggers, scheduled jobs, and ad-hoc processes to support marketing campaigns
Design, build, and monitor scalable data pipelines to ensure accurate, timely, and secure delivery of audience data across marketing channels
Optimize and modernize existing data processes to improve performance, reliability, and scalability
Develop and maintain API-based data feeds and integrations supporting campaign activation and analytics
Collaborate with marketing, analytics, and engineering teams to translate campaign requirements into efficient data solutions
Implement data quality checks, validation rules, and monitoring to ensure integrity of marketing datasets
Support production releases, troubleshooting, and continuous improvement of campaign data operations
Mentor junior developers and contribute to best practices for data engineering within marketing operations
Qualification
Required
10+ years of experience in ETL development, data engineering, marketing operations, or campaign data management
Strong experience with Amazon Redshift, including writing and optimizing complex SQL for data segmentation, transformation, and extraction
Hands-on experience with Databricks, with advanced proficiency in PySpark for building and orchestrating data pipelines
Extensive experience working with Salesforce Marketing Cloud (SFMC), including data extensions, automation studio, and campaign audience delivery
Solid understanding of marketing data models, customer segmentation, and multi-channel campaign workflows
Experience building and maintaining high-volume, production-grade data pipelines
Strong communication skills with the ability to work across technical and business teams
Company
JPS Tech Solutions
JPS Tech Solutions offers software engineering, cloud, mobile development, and IT infrastructure solutions.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase