SQL Data Programmer II

SQL Data Programmer II

Job Description

About Epsilon's Automotive

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.

Role Overview:

The Data Programmer's primary job function is to analyze, design, develop, QA, and support software applications in support of agencies client's business requirements. The data programmer is expected to be able to design and implement marketing solutions and collaborate with other marketing Developers in solving technology problems. This position will be called upon to review/write detailed technical specifications. The right candidate must possess excellent oral/written communication skills.

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.

Duties/Responsibilities:

• Interact with the Project Manager and develop technical specifications that meet business requirements
• Design and implement data streams that incorporate data hygiene, merge/purge, and transformations
• Translate client requirements and implement SQL Code that interfaces with proprietary data orchestration tools for client data processing
• Demonstrate a grasp of database architecture, modeling, ETL, SQL, and database access tools.
• 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
• Provide requirements to the technology delivery group to improve product integration, internally developed infrastructure components, and application templates based on project experience
• Participate in code review and acceptance process in order to improve methodology and delivery

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 SQL Server -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.
• Attention to detail and strong logical/analytical skills with a keen ability to anticipate and avoid problems.
• Ability to effectively manage, prioritize, and execute several tasks at once within project deadlines.
• Clear understanding of Systems Development Life Cycle (SDLC) methodology and respective experience with its application in design and development phases
• Excellent understanding of coding methods and best practices.
• 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 data programming experience.
• Must possess knowledge of MS SQL2016 or higher, applications data access methods, Transact-SQL, and stored procedures
• Knowledge of relational database concepts, SQL, and data modeling techniques
• Experience with data security and transfers is desirable
• Data hygiene and merge/purge applications is a plus

Preferred Qualifications

• Experience in Marketing industry a plus
• Familiar with Oracle Database a plus
• Demonstrated experience working on teams in a matrix organization structure
• Familiarity with workflow management systems a plus

Additional Information

About Epsilon

Epsilon is a global advertising and marketing technology company positioned at the center of Publicis Groupe. Epsilon accelerates clients' ability to harness the power of their first-party data to activate campaigns across channels and devices, with an unparalleled ability to prove outcomes. The company's industry-leading technology connects advertisers with consumers to drive performance while respecting and protecting consumer privacy. Epsilon's people-based identity graph allows brands, agencies and publishers to reach real people, not cookies or devices, across the open web. For more information, visit epsilon.com.

When you're one of us, you get to run with the best. For decades, we've been helping marketers from the world's top brands personalize experiences for millions of people with our cutting-edge technology, solutions and services. Epsilon's best-in-class identity gives brands a clear, privacy-safe view of their customers, which they can use across our suite of digital media, messaging and loyalty solutions. We process 400+ billion consumer actions each day and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. Thanks to the work of every employee, Epsilon has been consistently recognized as industry-leading by Forrester, Adweek and the MRC. Positioned at the core of Publicis Groupe, Epsilon is a global company with more than 8,000 employees around the world. Check out a few of these resources to learn more about what makes Epsilon so EPIC:

• Our Culture: https://www.epsilon.com/us/about-us/our-culture-epsilon
• Life at Epsilon: https://www.epsilon.com/us/about-us/epic-blog
• DE&I: https://www.epsilon.com/us/about-us/diversity-equity-inclusion
• CSR: https://www.epsilon.com/us/about-us/corporate-social-responsibility

Great People Deserve Great Benefits

We know that we have some of the brightest and most talented associates in the world, and we believe in rewarding them accordingly. If you work here, expect competitive pay, comprehensive health coverage, and endless opportunities to advance your career.

Epsilon is an Equal Opportunity Employer. Epsilon's policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. Epsilon also prohibits harassment of applicants and employees based on any of these protected categories. Epsilon will provide accommodations to applicants needing accommodations to complete the application process.

#LI-WK1

REF219814Y