"Alerted.org

General information

**Ref #** 19588

**Remote?** No

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

At Ally, you get a startup feel, but experience the benefits of a company that’s worked out the kinks and is fulfilling its purpose. We’re always evolving and see that as a good thing. From owning our work to seeing its impact in the real world, our team is relentless in finding new ways technology can help make experiences better and help people. We are problem solvers, we value diverse thinking, we support one another, and we challenge ourselves to think bigger in the journey to deliver customer-obsessed tech solutions. To read more about what our tech team does, be sure to visit our tech blog at ally.tech

We are seeking a skilled Data Engineer with expertise in Snowflake, AWS Lambda, AWS Glue, and API integration to join our team. The ideal candidate will have strong analytical skills, deep technical knowledge of SQL, and the ability to design and build efficient data models and data mart objects with complex logic. This role requires the ability to identify data patterns, optimize data workflows, secure data processing and implement scalable technology solutions.

At this time, Ally will not sponsor a new applicant for employment authorization for this position.

The Work Itself

* Design, develop, and maintain scalable Snowflake data warehouse solutions

* Design, develop, and optimize scalable data pipelines using AWS Glue, Lambda, and Snowflake

* Build and maintain data marts, ensuring efficient data structures that support business intelligence and analytics needs

* Develop complex SQL queries for data transformation, aggregation, and reporting

* Implement API integrations to ingest and process data from various external and internal sources

* Assist in data modeling and ensure optimal storage, retrieval, and performance of large datasets

* Analyze data patterns and trends to propose and implement technology-driven solutions for data quality, integrity, and performance improvements

* Collaborate with business stakeholders to understand data requirements and translate them into technical solutions

* Ensure best practices in data governance, security, and compliance within cloud-based data platforms

* Participating in backlog grooming and refining user stories related to deliverables

* Participate in Daily Standups -Provide updates on Engineering tasks, highlight progress, blockers and next steps

* Assist in grooming technical stories for backlog as required

* Participate in technical solutioning and Architecture design sessions

* Plan and coordinate deployments, review runbooks, and test evidence

* Create standard sustain documentation and schedule knowledge transfer (KT) meetings

The Skills You Bring

Required:

* Bachelor’s degree in computer science, Information Technology, or a related field

* 5+ years of experience in Technology with strong SQL skills, including writing efficient and complex queries

* 3+ years of experience in Data Engineering

* Strong expertise in Snowflake or other related cloud-based data warehousing solution, including schema design, query optimization, and performance tuning

* Experience with API development and integration for data ingestion

* Experience in data modeling techniques (Data Vault 2.0, Star Schema, Snowflake Schema)

* Ability to work with structured and semi-structured data formats (JSON, XML, Parquet)

* Strong problem-solving and analytical skills to detect data patterns and propose innovative solutions

* Familiarity with CI/CD pipelines, Git

Preferred:

* Knowledge of Python for data processing is a plus

* Experience in the banking or financial services industry

* Experience with orchestration tools like Apache Airflow or AWS Step Functions

* Snowflake SnowPro Certification (or equivalent)

* Experience in real-time data replication with Qlik

* Knowledge of data cataloging, data quality rules and lineage tools like Alation, Collibra, or Manta

\#LI-hybrid

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 [email protected]. Ally will not discriminate against any qualified individual who is capable of performing the essential functions of the job with or without reasonable accommodation.

_Base Pay Range:_

An individual's position in the range is determined by the scope and responsibilities of the role, work experience, education, certification(s), training, and additional qualifications. We review internal pay, the competitive market, and business environment prior to extending an offer.

**Emerging:** 110000

**Experienced:** 145000

**Expert:** 180000

Incentive Compensation: This position is eligible to participate in our annual incentive plan