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 syste