Lead SQL Database Developer at Epsilon (Chicago, IL)

| Chicago
Sorry, this job was removed at 3:06 a.m. (CST) on Saturday, January 22, 2022
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.
Company Description
Job Description
SUMMARY:
This position is responsible for the database architecture, development, implementation and maintenance of SQL Server based applications and components for the automotive marketing platform. The right candidate will have strong experience in database architecture and a proven track record in SQL programming and database development including analysis, design, development, implementation, testing, maintenance, and quality assurance.
DUTIES & RESPONSIBILITIES:
  • Responsible for the architecture, design, development and maintenance of SQL Server based applications and components for a large-scale enterprise application.
  • Collaborate with developers, project managers, business analysts and business users in conceptualizing, estimating and developing new software applications and enhancements.
  • Assist in the definition, development, and documentation of the software's objectives, business requirements, deliverables, and specifications in collaboration with internal users and departments.
  • Develop technical documentation to define the system components, development environment and implementation planning/strategies
  • Prepare and dispense user stories, provide guidance, and review the work of other team members.
  • Collaborate with the QA team to define test cases, metrics, and resolve questions about test results.
  • Recommend business process flow improvements and clearly communicate problem/resolution process to project management.
  • Develop and implement solutions in accordance with policies and procedures.
  • Facilitate the design and implementation process for new products/projects, informing senior executives of alternatives.
  • Analyze user requests and assist with design activities.
  • Provide in-depth and strong technical specialty and knowledge to the team.
  • Work closely with the QA team to identify and implement appropriate manual and automated functional tests
  • Advise and mentor team members in specialized technical areas as well as fulfill administrative duties as defined by the support process
  • Work with cross-functional teams during crisis to address and resolve complex incidents and problems in addition to assessment, analysis, and resolution of cross-functional issues.
  • Recognizes and identifies potential areas where existing policies and procedures associated with support requires improvement and helps in the process improvement activity
  • Develop Metrics to Assess & Improve quality and effectiveness of the development team

SKILLS & EXPERIENCE:
  • Bachelor's degree in computer science or equivalent engineering
  • 8+ years enterprise level relational database experience with SQL Server in large scale enterprise application environment.
  • At least 3 years of hands-on SQL Server performance tuning, indexing and optimization.
  • Deep hands on experience in SQL Server database architecture, design and development, including ER Diagrams, data warehousing and schema design.
  • Expertise, strong specialization or substantial project work in SQL, API / Stored Procedure design, Relational Database design, Linux and Windows Shell scripting.
  • Proficient understanding of distributed computing and scalability principles.
  • Expertise in data structures, algorithms, and techniques to tune software for maximum performance.
  • Experienced with ETL tools including Informatica, Pentaho PDI along with some exposure to Change Data Capture tools such as HVR or Oracle Golden Gate.
  • Data integration using SQL Server Integration Services or equivalent.
  • Experience with data security, PII rules and legislation including GDRP and CCPA.
  • Experience with Oracle, PostgreSQL or MySQL experience highly desirable
  • Experience with database scaling including logical and physical partitioning, database sharing and high availability.
  • Experience in using design patterns, distributed paradigms, modeling techniques such as UML
  • Experience leading development teams and providing technical direction and leadership.
  • Experience with Agile/Scrum
  • Outstanding communication skills and the ability to work well within agile scrum environment and within tight deadlines.
  • The ideal candidate will be deadline focused, detail oriented, well organized and self-motivated with the ability to juggle multiple projects simultaneously and manage time efficiently.

Qualifications
Additional Information
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.
Thanks to the work of every employee, Epsilon products and services have been recognized as industry-leading by the Forrester Wave™. We process more than 500 billion consumer actions each day and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. And our CORE ID® is the industry's most accurate, stable and scalable identity solution that helps brands recognize and reach 200M+ U.S. consumers in a privacy-safe way.
Positioned at the core of Publicis Groupe, Epsilon is a global company with more than 8,000 employees around the world. For more information, visit epsilon.com
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-AE1
REF134155F
Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Technology we use

  • Engineering
  • Product
    • C#Languages
    • C++Languages
    • CSSLanguages
    • dotnetLanguages
    • JavaLanguages
    • JavascriptLanguages
    • PerlLanguages
    • PHPLanguages
    • PythonLanguages
    • RLanguages
    • RubyLanguages
    • SassLanguages
    • ScalaLanguages
    • SqlLanguages
    • TypeScriptLanguages
    • MapRLanguages
    • D3JSLibraries
    • jQueryLibraries
    • PandasLibraries
    • ReactLibraries
    • Juptyer NotebookLibraries
    • AngularFrameworks
    • Angular.JSFrameworks
    • Backbone.jsFrameworks
    • CakePHPFrameworks
    • CypressFrameworks
    • DjangoFrameworks
    • DockerFrameworks
    • Ember.jsFrameworks
    • ExpressFrameworks
    • GraphQLFrameworks
    • HadoopFrameworks
    • KafkaFrameworks
    • KubernetesFrameworks
    • LaravelFrameworks
    • Next.jsFrameworks
    • Node.jsFrameworks
    • OAuthFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • TensorFlowFrameworks
    • TerraformFrameworks
    • Vue.jsFrameworks
    • HbaseFrameworks
    • Kafka Frameworks
    • StormFrameworks
    • CassandraDatabases
    • HBaseDatabases
    • HiveDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • NoSQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • GreenplumDatabases
    • NoSQLDatabases
    • AWS (Amazon Web Services)Services
    • GitHubServices
    • GitLabServices
    • Google CloudServices
    • Microsoft AzureServices
    • TableauAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement

Location

35 W Wacker Dr, Chicago, IL 60601

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

Senior 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:

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.
Flexible Work Schedule
What matters is what you achieve, not how many hours you clock. So take time off to enjoy your family and friends when you need it.
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 Epsilon

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about EpsilonFind similar jobs like this