About Mod Op
Mod Op is a full-service advertising agency able to offer clients a full suite of solutions. Mod Op can offer you access to low-cost, high-quality health care options and a team of enthusiastic, collaborative and motivated coworkers who see career development and personal development as intertwined.
At Mod Op, we’re more than just an agency—we’re a team of forward-thinking professionals who are passionate about driving client success. We believe in fostering meaningful relationships, collaborating across disciplines, and delivering impactful solutions that help businesses grow. If you are a strategic thinker with a passion for building lasting client partnerships, we’d love to hear from you. Join us and be part of a company that values innovation, creativity, and excellence in everything we do.
About the role
The Mid-Level Data Engineer builds and runs data pipelines and analytics on Google Cloud Platform. This person works mainly on telecommunications data, such as wireline and wireless customer and marketing data, and turns it into reliable datasets for marketing and analytics teams. The role works day to day with senior engineers and the marketing domain leads.
What you'll do
- Build and maintain batch and scheduled data pipelines on GCP, moving data into BigQuery.
- Write and optimize SQL for transformations, reporting datasets, and validation checks.
- Write Python for data ingestion, automation, and data quality checks.
- Support data migrations, including validating migrated data against the source system.
- Work with telecommunications data, such as customer, product, and campaign records, and document how it is defined and used.
- Connect pipeline outputs to marketing platforms, such as Salesforce, Adobe, and AJO.
- Troubleshoot failed jobs and data issues, and keep runbooks up to date.
- Contribute to team training and capstone projects on marketing domain knowledge.
Tech stack
- Google Cloud Platform, including BigQuery
- SQL for analytics and transformations
- Python for pipelines, automation, and data quality checks
- Telecommunications data concepts, such as wireline and wireless products and customer lifecycle
- Salesforce, Adobe, and AJO, at the data-integration level
Qualifications
Required
- 3 to 5 years of data engineering or analytics experience
- Working knowledge of GCP, especially BigQuery
- Strong SQL skills, including joins, window functions, and performance tuning
- Working Python skills for data pipelines and scripting
- Experience with telecommunications or similar subscriber data
Nice to have
- Experience with data migrations, such as Teradata to BigQuery
- Familiarity with Salesforce, Adobe, AJO, or other CRM and CDP platforms
- Interest in marketing analytics and campaign measurement
- Experience with Google Analytics or web-based marketing data
Skills Required
- 3 to 5 years of data engineering or analytics experience
- Working knowledge of Google Cloud Platform, especially BigQuery
- Strong SQL skills, including joins, window functions, and performance tuning
- Working Python skills for data pipelines and scripting
- Experience with telecommunications or similar subscriber data
- Experience with data migrations, such as Teradata to BigQuery
- Familiarity with Salesforce, Adobe, Adobe Journey Optimizer, or other CRM and CDP platforms
- Interest in marketing analytics and campaign measurement
- Experience with Google Analytics or web-based marketing data
What We Do
Mod Op is a full-service agency providing brand strategy, advertising, creative development and design, digital marketing, public relations, research, SEO, social media marketing, video production and web development to clients in both the B2C and B2B markets. With offices in New York, Dallas, Los Angeles, Miami, Minneapolis, Kansas City, Portland and Panama City, Panama, Mod Op pairs data and innovation with expertise to best serve clients.
