Senior Analyst- Data Management

General information

Career area

Consumer Analytics

Country

United States

Work Location(s)

500 Woodward Avenue, MI

Remote?

No

Ref #

17147

Posted Date

Friday, March 1, 2024

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

As part of the Data Solutions Support team, this Senior Analyst will be responsible to leverage Snowflake and other data platform to build best-in-class Data Management and Analytical pipelines for Ally's Auto Lending Team. The Senior Analyst at Ally will utilize analytic and technical skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems. Extensive business data and process knowledge will be obtained and used, as well as looking at competitor data and industry trends. The Senior Data Analyst will be responsible to learn our product data in 4 operational systems to obtain an overall picture of Auto Lending business. The Senior Data

• Business Analyst will need to have a clear understanding of the business use around downstream data. Participation in Data Governance activities, as well as other corporate data initiatives is also required.

The Work Itself

• Responsible to come up with Curated data layers that each line of business will be utilizing for analytics and for Business Intelligence

• purpose and help build a centralized data warehouse using Ally's Enterprise Data & Analytics standards.

• Develop and maintain data pipelines and work closely with data engineering team to migrate to production for e.g. using SQL, Python & Snowflake .

• Possess Data Warehousing principals and architecture patterns to help build reporting data marts in Onprem and Cloud databases e.g. Oracle, Snowflake

• Experience and working knowledge in extracting data from traditional data warehouse, big data ecosystems and cloud data warehouses toproduce critical data for business analyst executives and operational leaderships.

• Partner with the business to consult and translate the business needs to design and develop tools, techniques, metrics, and dashboards for data analysis, data quality monitoring & analytics support.

• Advanced working knowledge of SQL, Databases, Python and with the ability to write complex SQL statements to build data tables and produce reports. Working knowledge of SAS is a plus

• Proficient in working using Agile methodology for large projects & other tool such as GIT, Visual Studio, Code, Jupyter Notebooks, DBT, Python , RStudio

• Stays current with industry trends and leads development of key data/analytics innovation platforms

• Ability to display complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner

• Ensure stability, performance and support of production reporting and meet demand for data across Analytic teams

• Able to run multiple projects in parallel and should be communicating on status and risks timely.

The Skills You Bring

• 5+ Bachelor's degree preferred, Masters is a plus ( field of study: Computer Science, Data Management, Data Science, Management Information System, , Business Analytics)
• Good understanding of Auto Lending Processes and Data from Applicaiton to Origination & Servicing
• RDBMS

• Snowflake, Oracle, SQL server.

• Programming Languages

• SQL(Advanced), Python (Preferred), SAS (Nice to have)

• Data platforms

• Snowflake (Advanced), DBT (Data Build Tool)

• Reporting

• Power BI(Advanced)

• Other Skills

• Proficiency with GIT

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: 11 paid holidays, 20 paid time off days, and 8 hours of volunteer time off, yearly (paid time off is prorated based on start date)

• 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 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.

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

70000

Experienced

95000

Expert

120000

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