Skip to content

General information

Career area
Technology
Work Location(s)
500 Woodward Avenue, Detroit, MI
Remote?
No
Ref #
12877
Posted Date
Thursday, June 2, 2022
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

The Principal – Data Engineer will be a part of the Enterprise Data & Analytics team.

The incumbent will be a part of the engineering team that develops data pipelines & objects in the warehouse application. The warehouse contains the data, historical & transactional, for several up-stream applications. Currently changes are being done to accommodate some new lines of business as well as transformation of upstream applications from legacy to modern.

The Work Itself

The incumbent must have extensive experience in any warehousing platform. The individual must possess strong skills with SQL, PL/SQL, expertise in ETL tools, like DataStage. The individual must also have a strong knowledge of AWS services. Exposure to Snowflake or other Cloud based Warehousing applications is a plus. Knowledge / exposure to reporting & analytical tools is desirable.

The incumbent will work closely with a variety of groups throughout the organization, which will require the ability to communicate with associates with backgrounds ranging from business & data analysts, application developers, DBAs, business & reports users spreading across a wide range of operating units. The incumbent must also exhibit strong interpersonal and communication skills and have experience interacting with internal technical and business partners as well as external partners. Experience with on-shore and off-shore contractors is a plus.

This position is for a passionate experienced individual with great technical skills with the following responsibilities

  • Engage in application design discussions as it pertains to the upscaling the application
  • Break down the design into build / change components\
  • Leads code review sessions to validate adherence with development standards and benchmark application performance by regression & capacity testing ahead of Production deployment
  • Leads the activities to transition new development into Production Operations
  • Leverages DevOps techniques and Experience with DevOps tools like GitLab, Jira and Jenkins
  • Leads discussions resulting from Production issues found in objects that this team is responsible for

The Skills You Bring

  • 5+ years overall IT experience
  • 5+ years of experience in any Warehousing application, either on-prem or cloud based
  • Excellent PL/SQL procedure and SQL skills
  • Expertise in ETL / ELT tools DataStage and other tools like dbtCloud
  • Strong AWS services knowledge
  • Unix shell scripting, AWK scripting for automating several DBA tasks
  • Rich experience in DevOps techniques and tools like GitLab, Jira and Jenkins to build automation
  • Owns the authoring and coordination to deliver documentation needed for the Production Operations team
  • Ability to work in a large, complex business and technical environment with competing priorities
  • Provide input to planning activities to estimate effort to complete sprint planning and execution tasks/activities
  • Must be detail oriented and have the ability to multi-task
  • Fast starter, effectively delivers with limited supervision
  • Must have excellent communication skills written as well as verbal; must be able to articulate the value proposition of solution/services to senior teams from client/prospect
  • Ability to communicate effectively with both the business and technical teams
  • AWS Certified preferred
  • Finance or Automotive Industry experience preferred
  • Experience in Agile / SCRUM (with sprints) methodologies preferred

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.

     

    Where permitted by applicable law, must have received or be willing to receive the COVID-19 vaccine by date of hire to be considered, if not currently employed by Ally.

     

    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.