General information

Ref # 17464

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

The Sr. Analyst - Auto Services and Reporting will be responsible for driving improvement in business capabilities and results through the development of best in class data management and reporting solutions.

The Work Itself

• Create Microsoft Power BI Dashboards using SQL code to perform complex data extraction from multiple, large data sources
• Create Jira/Confluence Dashboards to extract system development stories, capabilities, etc. from Atlassian Jira system
• Leverage Microsoft Excel macros and other tools to automate daily and monthly data processes
• Create SQL code using Snowflake and Sigma to create reports
• Ability to use IBM Cognos Reporting for operational reports
• Write SQL code to perform complex data aggregation, cleaning, and quality checking
• Create and maintain data documentation (mapping, rulebooks, etc.)
• Conceptualize organized data structures and marts to simplify data sourcing
• Consult with internal stakeholders to document reporting requirements
• Partner with internal IT teams to optimize data architecture and data utilization
• Participate in data quality rule creation and testing activities
• Proactively engage in projects to provide data thought leadership
• Perform special projects/assignments as needed

The Skills You Bring

• Bachelor’s degree in IT or data discipline (MIS, Computer Sci, etc.) required
• Master’s degree in IT or data discipline (MIS, Computer Sci, etc.) preferred
• 3+ years performing complex data extraction from multiple, large data sources required
• 3+ years programming in SQL using Snowflake, Oracle SQL Developer and Power BI required
• Experience collaborating with partners to understand data requirements
• Experience creating data quality rules and testing activities preferred
• Knowledge of and experience with reporting packages (Power BI, Sigma, Cognos, etc.)
• Knowledge of Atlassian Jira and Confluence
• Advanced knowledge of MS Excel and Power Query including pivot tables and vlookup functions
• Intermediate knowledge of automation through VBA preferred
• Knowledge of Python is a plus
• Experience in Auto Finance industry (consumer loans, commercial, etc.) preferred
• Ability to achieve balance between the right technical and business solution
• Thorough approach and attention to detail

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.

Base Pay Range:

Emerging: 85000

Experienced: 117500

Expert: 150000

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