Oh Snap!
This job is no longer active - but you can still view the details below.

Sr. Data Warehouse Developer

| North Suburbs

Discover. A more rewarding way to work.

At Discover Financial Services, you’ll find yourself in the company of some of the industry’s smartest and most reliable professionals. And at a company that rewards dedication, values innovation and supports growth.

Thrive in an environment that promotes teamwork and shared success. Build on a foundation of mutual respect. Join the company that understands rewarding careers like no other, with this exceptional opportunity:

Job Description:

As a Sr. Datawarehouse Developer, you will provide technical (design & development) leadership to the Enterprise Data Warehouse Team in development of Extract/Transform/Load (ETL) applications that will interface with all key Discover applications.

Position requires excellent communication skills for understanding business vision and the ability to translate the vision into technical artifacts. Strong technical analysis and design background is also a must-have to ensure that technical deliverables are providing flexible, architecturally sound infrastructure with the ability to reuse in future Data Stores, analytical and operational in AWS.

****PLEASE NOTE THAT WE ARE UNABLE TO OFFER VISA SPONSORSHIP FOR THIS ROLE NOW OR IN THE FUTURE****

Job Responsibilities:

  • Develop data driven solutions utilizing current and next generation technologies to meet evolving business needs.
  • Ability to quickly identify an opportunity and recommend possible technical solutions.
  • Develop application systems that comply with the standard system development methodology and concepts for design, programming, backup, and recovery to deliver solutions that have superior performance and integrity.
  • Contribute to determining programming approach, tools, and techniques that best meet the business requirements.
  • Understand and follow the PDP process to develop, deploy and deliver the solutions.
  • Be pro-active and diligent in identifying and communicating design and development issues.
  • Provide business analysis and develop ETL code and scripting to meet all technical specifications and business requirements according to the established designs.
  • Offer system support as part of a support rotation with other team members.
  • Utilize multiple development languages/tools such as Python, SPARK, Hive to build prototypes and evaluate results for effectiveness and feasibility.
  • Operationalize open source data-analytic tools for enterprise use.
  • Develop real-time data ingestion and stream-analytic solutions leveraging technologies such as Kafka, Apache Spark, Python and AWS based solutions.
  • Custom Data pipeline development (Cloud and locally hosted)
  • Work heavily within the Cloud ecosystem and migrate data from Teradata to AWS based platform.
  • Provide support for deployed data applications and analytical models by being a trusted advisor to Data Scientists and other data consumers by identifying data problems and guiding issue resolution with partner Data Engineers and source data providers.
  • Provide subject matter expertise in the analysis, preparation of specifications and plans for the development of data processes.
  • Ensure proper data governance policies are followed by implementing or validating Data Lineage, Quality checks, classification, etc.

Skills:

Skills Required:

  • 4+ years of systems development and analysis experience in designing, developing, implementing & maintaining applications
  • Knowledge of Data Warehouse technology (Unix/Teradata/Ab Initio preferred)
  • Strong analytical skills and experience with writing and performance tuning complex SQL queries
  • Strong written and verbal communication skills
  • Ability to think independently and work with various teams on projects
  • Ability to handle multiple initiatives concurrently
  • Experience working in a collaborative team environment
  • Bachelor Degree or higher level of education or equivalent experience

Skills Desired:

  • Hands on experience with Amazon Web Services (AWS) based solutions such as RDS, Lambda, Dynamodb, Snowflake and S3 or other cloud technologies
  • Experience with any of the following: R, SAS, Hive, Spark, Python or H2O
  • Experience in migrating ETL processes (not just data) from relational warehouse Databases to AWS based solutions.

#LI-KE

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • Neo4jLanguages
    • RLanguages
    • AngularJSFrameworks
    • HadoopFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • Amazon Web ServicesFrameworks
    • AnsibleFrameworks
    • AWS PortfolioFrameworks
    • BlockchainFrameworks
    • ChefFrameworks
    • CloudFoundryFrameworks
    • DockerFrameworks
    • Google Cloud PlatformFrameworks
    • KubernetesFrameworks
    • Lambda ArchitectureFrameworks
    • OpenAPIFrameworks
    • OpenShiftFrameworks
    • CassandraDatabases
    • HiveDatabases
    • MongoDBDatabases
    • OracleDatabases
    • TeradataDatabases
    • ServerlessDatabases
    • TerraformDatabases
    • Google AnalyticsAnalytics
    • SparkAnalytics
    • H20Analytics
    • Machine Learning Analytics
    • Natural Language Processing Analytics
    • Programmable BotsAnalytics
    • AgileManagement
    • SafeManagement
    • LeanManagement
    • Continuous Delivery Management
    • DevSecOpsManagement
    • Reactive ProgrammingManagement
    • Site Reliability EngineeringManagement
    • SalesforceCRM

Location

Our headquarters is located in the northwest suburbs of Chicago and we also have a downtown Chicago office which is known as the“The 606”.

An Insider's view of Discover Financial Services

What’s the vibe like in the office?

The cool thing about working at Discover is the wonderful collaborative environment we have and all the smart, talented and fun people we work with every day to continuously work on innovations.

Hiba

AWS Cloud Engineer

What does your typical day look like?

I enjoy working at Discover because I get to work with and collaborate with talented people who are passionate about what they do, and together we get to help others. We work constructively and cross-functionally to provide the best and newest products for our users and provide exceptional support for our customers!

Mandy

Project Manager, Advanced Analytics Platform

How does the company support your career growth?

There are two reasons I enjoy working at Discover. First, I enjoy the challenging and meaningful work. Second, my career path at Discover is mine to shape. My managers have supported me when I wanted to learn more and move within the company.

George

Senior Manager, Software Engineering

What is your vision for the company?

My vision of the company is that we create rewarding experiences in lives of our customers every day through analytics.

Kumar

SVP, CDO Advanced Analytics Platforms

What’s the vibe like in the office?

I love working at Discover because of how the company invests in its people and innovation. The environment is encouraging and the smart people around you makes it an amazing experience every day!

Brent

Director, Digital Analytics

What are Discover Financial Services Perks + Benefits

Discover Financial Services Benefits Overview

Start enjoying great benefits Day 1 — We support you with the same dedication we bring to all of our customers.Our comprehensive benefits package features first-class insurance, financial planning support and excellent perks designed to help you reach your goals and live a rich, healthy life.

Check out more of our amazing employee benefits at mydiscoverbenefits.com

Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
You can open a separate Health Care FSA (HCFSA) and contribute up to $2,650 tax-free from your paycheck to reimburse yourself for eligible out-of-pocket expenses.
Disability Insurance
Employees receive Short-Term Disability Insurance at no cost.
Dental Benefits
Discover offers two dental plan options — Standard and Premier — both are administered by MetLife.
Vision Benefits
Discover offers two vision plan options — Standard and Premier through VSP.
Health Insurance Benefits
Discover offers a variety of medical plans for you and eligible family members, so that you can choose the benefit plan that suits your needs.
Life Insurance
As a Discover employee, you receive Basic Life Insurance of one times your HWEE (up to $500,000) at no cost to you.
Pet Insurance
Purchase medical coverage at a discounted rate for your beloved family pet. The more pets you insure, the greater the discount.
Wellness Programs
Help balance your work and personal life with a wide variety of free and discounted resource and referral services including family and relationship counseling and financial guidance.
Onsite Gym
Discover has fitness centers and Weight Watchers® programs at all five major locations.
Retirement & Stock Options Benefits
401(K)
You may elect to contribute 1% to 30% of your eligible base salary, commissions and bonus on a pre-tax basis, up to IRS limits every year.
401(K) Matching
Discover matches up to 6% of the pre-tax contributions you make to the 401(k) Plan.
Employee Stock Purchase Plan
The ESPP provides eligible employees with an opportunity to purchase shares of Discover common stock through payroll deductions at a 5% discount.
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Discover helps eligible employees and their families with the costs of adoption by reimbursing certain expenses.
Vacation & Time Off Benefits
Generous PTO
Discover has a Paid Time Off of 4 to 5 Weeks of paid time per year.
Paid Volunteer Time
Paid Holidays
Discover provides 7 paid holidays.
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
When you enroll in the Commuter Benefits Program at WageWorks, you’ll save on taxes on mass-transit passes, parking and other eligible expenses.
Company Outings
Game Room
Parking
Recreational Clubs
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Discover provides tuition reimbursement and a full-ride bachelor's degree program for select online degree programs.
Diversity Program
More Jobs at Discover Financial Services77 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Marketing
Operations
Project Mgmt
Data + Analytics
new
North Suburbs
Operations
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Project Mgmt
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Project Mgmt
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Operations
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
Chicago
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Operations
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
Chicago
Operations
new
North Suburbs
Operations
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Developer
new
North Suburbs
Developer
new
North Suburbs
Project Mgmt
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
Chicago