Senior Oracle Developer

Overview

This is a Hybrid role requiring 3-4 days per week in office in Troy, MI.

Epsilon’s Automotive is a business unit of Epsilon and Publicis. It brings together data, decisioning and channel activation into an end‑to‑end automotive lifecycle marketing platform tailored specifically for dealers and auto manufacturers. Epsilon’s Automotive currently works with seven of the top ten global auto manufacturers helping clients align the customer, vehicle and dealer across channels and at worldwide scale.

The Data Programmer serves as a technical liaison between client business requirements and marketing campaign execution. This role is responsible for translating campaign specifications into effective data processes and solutions.

The Data Programmer will be able to translate marketing campaign requirements against technical best practices and will determine the solution that provides the best combination of functionality, performance, and ease of maintenance.

The candidate must have the ability to self‑direct, set goals, and meet aggressive deadlines. This is a key factor in the overall success of the automotive team organization.

• Translate client marketing requirements into technical data specifications and executable processes
• Design and implement data streams that incorporate data hygiene, merge/purge, and transformations
• Write and modify SQL queries, stored procedures, and scripts to support campaign data extraction, transformation, and loading
• Support implementation of business intelligence and marketing automation solutions
• Adhere to production standards in all work products and participating in the refinement of standards to improve quality and productivity
• Document all work and facilitate support of ongoing operational responsibilities
• Participate in code review and acceptance process in order to improve methodology and delivery
• Develop quality control (QC) reports to validate data accuracy, identify issues, and ensure campaign deliverables meet client specifications
• Collaborate with account teams and project managers to clarify requirements and communicate technical constraints or data availability

Skills

• The candidate must have the ability to design and implement solutions that are reliable, scalable, and perform at a high-level to meet the service levels associated with mission‑critical PL/SQL‑based solutions.
• Proven analytical and problem‑solving abilities. Ability to quickly discern the most relevant facts and recommend the quickest, most practical and safest approach to resolving an issue with a program or database.
• Able to decompose and solve problems at the appropriate level within the system, keeping in mind the higher‑level structures and their requirements and dependencies with adjoining subsystems.
• Strong logical/analytical skills with a keen ability to anticipate and avoid problems.
• Ability to work within tight deadlines and effectively prioritize and complete tasks in a high‑pressure environment.
• Attention to detail and the ability to manage several tasks at once.
• Excellent understanding of coding methods and procedures.
• Recognizes good opportunities for code reuse and ensures that the code is designed and implemented accordingly.
• Strong listening skills; ability to capture requirements expressed in design meetings.
• Flexible and adaptable in regard to learning and understanding new technologies.
• Highly self‑motivated and directed.

Technical Requirements

• 5+ years development experience
• Experience with extract, transformation, and load (ETL)
• Knowledge of relational database concepts, SQL, and data modeling techniques
• Experience developing marketing applications desirable
• Oracle PL/SQL experience
• Ability to leverage AI tools (Amazon Q, MS Copilot) to enhance productivity in code development, debugging, and documentation
• Data hygiene and merge/purge applications is a plus

Preferred Qualifications

• Experience in Marketing industry a plus
• Demonstrated experience working on teams in a matrix organization structure
• Familiarity with Oracle Database or Databricks

The Power of One starts with our people! To do powerful things, we offer…