SQL Server Data Programmer at Epsilon

| West Suburbs
Sorry, this job was removed at 12:15 p.m. (CST) on Thursday, June 3, 2021
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Company Description

Epsilon is the leader in outcome-based marketing. We enable marketing that’s built on proof, not promises. Through Epsilon PeopleCloud, the marketing platform for personalizing consumer journeys with performance transparency, Epsilon helps marketers anticipate, activate and prove measurable business outcomes. Powered by CORE ID®, the most accurate and stable identity management platform representing 200+ million people, Epsilon’s award-winning data and technology is rooted in privacy by design and underpinned by powerful AI. With more than 50 years of experience in personalization and performance working with the world’s top brands, agencies and publishers, Epsilon is a trusted partner leading CRM, digital media, loyalty and email programs. Positioned at the core of Publicis Groupe, Epsilon is a global company with over 8,000 employees in over 40 offices around the world. For more information, visit epsilon.com. Follow us on Twitter at @EpsilonMktg.

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
  • 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.
  • Strong logical/analytical skills with a keen ability to anticipate and avoid problems.
  • Ability to work within tight deadlines and effectively prioritize and execute tasks in a high-pressure environment.
  • Attention to detail and the ability to manage several tasks at once.
  • 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, applications data access methods, Transact-SQL, and stored procedures
  • Knowledge of relational database concepts, SQL, and data modeling techniques
  • Experience developing marketing applications 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

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.

Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PerlLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • MapRLanguages
    • D3JSLibraries
    • jQueryLibraries
    • ReactLibraries
    • Juptyer NotebookLibraries
    • AngularJSFrameworks
    • Backbone.jsFrameworks
    • CakePHPFrameworks
    • Ember.jsFrameworks
    • HadoopFrameworks
    • LaravelFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • TensorFlowFrameworks
    • HbaseFrameworks
    • Kafka Frameworks
    • StormFrameworks
    • CassandraDatabases
    • HBaseDatabases
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • GreenplumDatabases
    • NoSQLDatabases

Location

101 N Wacker Drive, Chicago, IL 60606

An Insider's view of Epsilon

What's something quirky about your company?

We have a company band, made up of anywhere from 30 to 40 employees at a given time. The band has a large following and performs at charity events around Chicago. They also perform a full set at Epsilon’s holiday party each year at the House of Blues. My jaw hit the floor when I saw my peers up on stage rocking out.

Paul

Associate Automation & Infrastructure Engineer

How do you collaborate with other teams in the company?

We collaborate through storytelling. It’s not ‘how’ we build it, but rather ‘why’ we build it. We need to tell stakeholders a story about a consumer pain point, solving it in a differentiated manner and the larger vision. Then, collaboration occurs as we incorporate feedback and have a motivated team building towards a shared vision.

Matt

VP, Product Management:

How would you describe the company’s work-life balance?

Conversant has a very good work-life balance, including unlimited PTO. As a young adult, traveling around the world is one my top priorities and working with a company that aligns with that is a huge plus. I have had the flexibility to visit 7 countries. That flexibility is one of many things that has kept me at Conversant for five years.

Alba

Team Lead, Engineering

What are Epsilon Perks + Benefits

Epsilon Benefits Overview

At Epsilon, we offer benefits and perks that enable our associates to thrive and foster a culture of innovation.

Culture
Volunteer in local community
Epsilon participates in local community activities such as the Greater Chicago Food Depository, Off the Street Club, Chicago Cares Serve-A-Thon, Habitat for Humanity and Ronald McDonald House.
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Epsilon has a Social Committee that organizes social, charitable and sports activities.
Daily sync
Open door policy
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Epsilon team fitness initiatives include intramural softball, volleyball and soccer.
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Child Care Benefits
Epsilon provides back-up care benefits.
Remote Work Program
Family Medical Leave
Adoption Assistance
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Epsilon hosts an annual summer boat party on Lake Michigan and a holiday party at the House of Blues, where our employee-run band performs the live entertainment all night.
Game Room
Happy Hours
Happy hours are hosted at team's discretion.
Parking
Recreational Clubs
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Epsilon offers employees professional development opportunities like on-site training courses and the ability to attend job-related conferences and seminars.
Tuition Reimbursement
Lunch and learns
Epsilon hosts lunch and learn meetings on occasion.
Promote from within
Mentorship program
Our mentorship program includes 1-to-1 program and career mentoring.
Time allotted for learning
Epsilon encourages employees to complete 48 hours of professional development training per year.
Online course subscriptions available
More Jobs at Epsilon92 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Marketing
Operations
Product
Project Mgmt
Sales
Content
Data + Analytics
new
Chicago
HR + Recruiting
new
Chicago
Operations
new
Chicago
Developer
new
West Suburbs
Sales
new
Chicago
Design + UX
new
West Suburbs
Marketing
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Sales
new
Chicago
Marketing
new
Chicago
Marketing
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Sales
new
West Suburbs
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Design + UX
new
Chicago
Sales
new
West Suburbs
Developer
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Developer
new
West Suburbs
Data + Analytics
new
West Suburbs
Sales
new
Chicago
Sales
new
West Suburbs
Sales
new
Chicago
Sales
new
Remote
Developer
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Content
new
West Suburbs
Sales
new
Remote
Sales
new
West Suburbs
Design + UX
new
Chicago
Product
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
HR + Recruiting
new
West Suburbs
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Epsilon's full profileSee more Epsilon jobs