Ally Financial

Sr. Data Engineer

Job description

General information

Career area
Technology
Work Location(s)
601 S. Tryon Street, Charlotte, NC
Ref #
21-6192
Posted Date
Monday, May 24, 2021
Working time
Full-time

Ally and Your Career

Ally Financial only succeeds when its people do - and that’s more than some cliché people put on job postings. We live this stuff! We see our people as, well, people - with interests, families, friends, dreams, and causes that are all important to them. Our focus is on the health and safety of our teammates as well as work-life balance and diversity and inclusion. From generous benefits to a variety of employee resource groups, we strive to build paths that encourage employees to stretch themselves professionally. We want to help you grow, develop, and learn new things. You’re constantly evolving, so shouldn’t your opportunities be, too?

The Opportunity

Responsible for delivering relevant technical solutions based on best practices primarily using various database technologies. Successful candidate should be self-driven, able to work with minimum supervision and have extensive experience in data modeling, Data Warehousing, PL/SQL, ETL processing, Reporting and a background in finance. Candidate will be expected to work as an individual contributor as well as provide oversight and direction to other technical resources as required.

The Work Itself

  • The Sr. Database Administrator will be a part of team that supports database and PL/SQL development.
  • Design, implement, code, test and maintain database technologies.
  • Prepare and review system documentation composed by development teams.
  • Perform modifications to and maintenance of operational programs and procedures.
  • Develops effective and efficient PL/SQL packages, procedures, triggers and functions according to design specifications.
  • Applies best practice for tuning for overall system performance.
  • Supports software development and test teams throughout the software development lifecycle.
  • Includes incremental script execution and defect resolution.
  • Provides support for software releases.
  • Researches interfaces to identify and code required updates to support integration.

The Skills You Bring

•Bachelor's degree in computer science, information systems or relevant field of study.
  • 3+ years of experience required.
  • Extensive experience with database development tools, ETL and integration technologies.
  • Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic.
  • Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures.
  • Ability to setup, maintain and enhance partition table spaces.
  • Ability to provide guidance, oversight, and peer review to more junior database developers.
  • Experience with managing and resolving problems on a live production system.
  • Solid understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc.
  • Experience with software development lifecycle and software development common practices (code reviews, unit testing etc.).
  • Strong written and oral communication skills are essential.
  • Solid work ethic, self-driven with the ability to work with minimal supervision.

How We'll Have Your Back

Ally's compensation program offers market-competitive base pay and pay-for-performance incentives (bonuses) based on achieving personal and company goals. But Ally’s total compensation – or total rewards – extends beyond your paycheck and is designed to support and enrich your personal and professional life, including:
  • Time Away: competitive holiday and flexible paid-time-off, including time off for volunteering and voting.
  • Planning for the Future: plan for the near and long term with an industry-leading 401K retirement savings plan with matching and company contributions, student loan and 529 educational assistance programs, tuition reimbursement, and other financial well-being programs.
  • Supporting your Health & Well-being: flexible health and insurance options including dental and vision, pre-tax Health Savings Account with employer contributions and a total well-being program that helps you and your family stay on track physically, socially, emotionally, and financially.
  • Building a Family: adoption, surrogacy, and fertility support as well as parental and caregiver leave, back-up child and adult/elder day care program and childcare discounts.
  • Work-Life Integration: other benefits including LifeMatters® Employee Assistance Program, subsidized and discounted Weight Watchers® program and other employee discount programs.

Who We Are:

Ally Financial is a customer-centric, leading digital financial services company with passionate customer service and innovative financial solutions. We are relentlessly focused on Doing it Right and being a trusted financial-services provider to our consumer, commercial, and corporate customers. For more information, visit www.ally.com.

Ally is an equal opportunity employer committed to diversity and inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity or expression, pregnancy status, marital status, military or veteran status, genetic disposition or any other reason protected by law.

We are committed to working with and providing reasonable accommodation to applicants with physical or mental disabilities. For accommodation requests, email us at work@ally.com. Ally will not discriminate against any qualified individual who is capable of performing the essential functions of the job with or without reasonable accommodation.

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.