Manager - Data Engineering

Ally-Financial; Detroit (MI); Hybrid; USD 110,000 - 180,000; Full time

Benefits offered by this job

Time Off & Holidays

401K plan

Health insurance

Tuition reimbursement

Relocation assistance

Job summary

Ally Financial is seeking a Manager - Data Analytics to lead a team of developers and analysts responsible for delivering and maintaining applications supporting Ally’s operations. You will oversee SDLC tasks, design data interfaces, and ensure data quality across systems.

The role demands strong SQL, Python, and cloud data experience on AWS, with hands-on work in data warehousing, data modeling (Data Vault), and governance.

Qualifications

• 7+ years of data management and analytics experience.
• Experience with cloud data platforms on AWS.
• Ability to lead, mentor and manage contributors.
• Strong requirements gathering and design abilities.
• Experience with data governance and metadata practices.
• Insurance data domain knowledge is preferred.

Responsibilities

• Lead and mentor data technologies developers.
• Coordinate SDLC tasks to design and deliver data solutions.
• Analyze interfaces, files, databases and reports.
• Engage with clients and manage vendors for incidents.
• Design system interfaces and data models.

Skills

Data management

Data analysis

SQL

Mentoring

Python

Communication

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

dbt

Qlik Replicate

InfoSphere DataStage

CP4D

AWS

Job description

Ally and Your CareerAlly Financial only succeeds when its people do - and that’s more than some cliché people put on job postings. We love 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 OpportunityAre you passionate about data, architecture, software development and analytics possess first-hand experience with cloud data platforms, cloud technologies, data warehousing, data integration, and API development? Do you believe in modern software development methods, teamwork, creativity and collaboration within a diverse development environment to produce the next generation of data - analytics platforms and services? If so, then we are interested in talking to you! Ally is seeking a Manager - Data Analytics to be a leader within Ally's data technologies development and management space. The ideal candidate will have personal experience implementing cloud data warehouse, data lakes, data analytics, and master data management solutions, including data ingestion, data homogenization - data preparation, data quality checking and management, structured and unstructured data processing, relational and no SQL data processing and applications, API development, advanced analytics, and business intelligence. Experience with modern self-service data capabilities, data management and governance, data modeling, and data architecture is also a plus. Responsible for managing a team of data technologies developers focused on delivering and maintain several applications that support Ally's operations. Candidates having strong analytical skills, hands on development experience, strong SQL skills, ability to multi-task, and strong verbal and written communication skills will be best suited for the team.At this time, Ally will not sponsor a new applicant for employment authorization for this position.The Work ItselfManaging developers and analysts to coordinate and SDLC tasks to design and deliver solutions for system integration, reporting and support functions.Technical analysis of interfaces, files, databases and reports.Requirements gathering and analysis.Creation of technical specifications.Technical design along with definition for technology changes relative to the systems (and integration of those systems) within the Ally Insurance data ecosystem.High-level and low-level design of system interfaces.Troubleshooting and support of system interfaces.Moderate client engagement.Vendor management for incident resolution and for system enhancement work.System/application configuration.The Qualifications We’re Looking For8+ years of data management and data analysis experience preferred.Bachelor's degree in Computer Science, Information Systems, or other relevant field of study preferred.Experience related to data warehousing design and development.Strong knowledge and experience with one or more SDLC methodologies and/or principles such as Agile, SCRUM, Kanban or other.Ability to lead, mentor and manage individual contributors.Strong requirements gathering and design abilities.Strong analytical skills.Strong verbal and written communication skills.Ability to multi-task.Extensive hands-on experience designing and delivering cloud-based data solutions on AWS, including services such as S3, AWS CLI, Lambda, and DynamoDB.Strong experience with modern data engineering and integration tools such as dbt, Qlik Replicate, InfoSphere DataStage, and CP4D.Deep expertise in data modeling, including Data Vault, and in designing scalable, auditable, and resilient data structures that support enterprise analytics, reporting, and AI use cases.Proven experience architecting and optimizing large-scale data ingestion, transformation, cleansing, standardization, and deduplication processes across complex data environments.Strong programming and automation skills in Python and other scripting languages used to support enterprise data engineering solutions.Demonstrated experience leading the design and implementation of enterprise data pipelines using Git, DevOps practices, and modern software engineering approaches.Strong background in large-scale data integration, API development, and data migration across distributed systems and platforms.Deep understanding of data governance, data management, metadata, lineage, and data security, with the ability to embed these practices into engineering solutions.Proven ability to lead end-to-end solution delivery, working independently while providing technical direction across multiple initiatives and technologies.Insurance Business data domain knowledge is preferred.Minimum Qualifications7+ years of relevant experienceBachelor's Degree in relevant field(s) of study or equivalentHow We'll Have Your BackAlly'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.pdfWho 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.In accordance with the Americans with Disabilities Act, if after review of the position expectations, you believe that you may need a medical accommodation to fulfill the duties of this role, please email [e-mail] with details of your accommodation request.Base Pay Range$110,000.00 - $180,000.00An 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.