Principal Data Engineer

Ally; Charlotte (NC); Hybrid; USD 110,000 - 180,000; Full time

Job summary

A leading financial services company is seeking a Principal Data Engineer to design and maintain data solutions using Snowflake and AWS technologies. The ideal candidate will possess strong analytical skills and experience in data modeling, SQL, and API integration. Join a team focused on innovative solutions that enhance customer experiences and support business intelligence needs.

Benefits

20 paid time off days

401K retirement savings plan with matching

Flexible health and insurance options

Paid parental and caregiver leave

Qualifications

• 5+ years of experience in Technology with strong SQL skills.
• 3+ years of experience in Data Engineering.
• Experience with API development and integration for data ingestion.

Responsibilities

• Design, develop, and maintain scalable Snowflake data warehouse solutions.
• Build and maintain data marts for business intelligence needs.
• Collaborate with stakeholders to understand data requirements.

Skills

SQL

Data Modeling

Problem Solving

Education

Bachelor’s degree in computer science

Tools

Snowflake

AWS Glue

AWS Lambda

Job description

Join to apply for the Principal Data Engineer role at Ally

Continue with Google Continue with Google

Join to apply for the Principal Data Engineer role at Ally

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?

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?

Work Schedule: Ally designates roles as (1) fully on-site, (2) hybrid, or (3) fully remote. Hybrid roles are generally expected to be in the office a certain number of days per week as indicated by your manager. Your hiring manager will discuss this role's specific work requirements with you during the hiring process. All work requirements are subject to change at any time based on leader discretion and/or business need.

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
  
  

Skills

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
  
  

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. Our Total Rewards program includes industry-leading compensation and benefits plus additional incentives that are designed to meet your needs and those of your family so you can get the most out of your career and your life, including:

• Time Away: Program starts at 20 paid time off days in addition to 11 paid holidays and 8 hours of volunteer time off yearly (time off days are prorated based on start date and program varies based on full or part-time status and management level).
• 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 pay downs and 529 educational save up assistance programs, tuition reimbursement, employee stock purchase plan, and financial learning center and financial coach access.
• Supporting your Health & Well-being: flexible health and insurance options including medical, dental and vision, employee, spouse and child life insurance, short- and long-term disability, pre-tax Health Savings Account with employer contributions, Healthcare FSA, critical illness, accident & hospital indemnity insurance, 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 assistance as well as paid parental and caregiver leave, Dependent Day Care FSA back-up child and adult/elder care days and childcare discounts.
• Work-Life Integration: other benefits including Mentally Fit Employee Assistance Program, subsidized and discounted Weight Watchers program and other employee discount programs.
• Other compensations: depending on the role for which you are considered, you may be eligible for travel allowances, relocation assistance, a signing bonus and/or equity.
• To view more detailed information about Ally’s Total Rewards, please visit this link: https://www.ally.com/content/dam/pdf/corporate/ally-total-rewards-snapshot.pdf
  
  

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 [e-mail]. 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: $110000 - $180000 USD

An individual's position in the range is determined by the specific role, 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.

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Ally by 2x

Get notified about new Data Engineer jobs in Charlotte, NC.

Charlotte, NC
$115,000.00
-
$125,000.00
3 weeks ago

Charlotte, NC $105,100 - $192,700 1 week ago

Charlotte, NC $111,000 - $152,000 2 weeks ago

Snowflake Data Engineer with AWS- w2 only

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.