Data Analyst

General information

Career area

Insurance

Work Location(s)

500 Woodward Avenue, Detroit, MI

Remote?

No

Ref #

14864

Posted Date

Monday, March 6, 2023

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

Primary responsibility of this role is to support the Ally Insurance Field Sales Organization and channel strategies through field-related reporting, operational efficiencies, and data management. Core job functions include all development, maintenance, and enhancements of the production reporting environment used to evaluate dealer incentives and sales performance. Outputs include enterprise-wide dashboards, self-service reporting tools as well as the reporting infrastructure used for control validations, ad hoc reporting and analysis.

The ideal candidate must possess a high technical capability and strong leadership behaviors. Must be passionate about delivering accurate results, possess an inherit curiosity and willingness to quickly learn, adapt and explore new leading-edge technologies, must be an innovative, strategic and creative problem solver, and must have demonstrable experience with the automation of reports (i.e. dashboards with drill-in capability)j, query logic (i.e. SQL), and some familiarity with various coding syntaxes (i.e. DAX, Proc SQL).

The Work Itself

• · Service the sales organization to support corporate objectives
• · Develop and maintain reporting infrastructure to gauge performance and perform analytics
• · Maintains monthly, quarterly, and yearly routine reporting deliverables
• · Works closely with business leaders and team members and provides insight for the development and integration of new technologies, tools, and processes
• · Communicates with matrix partners and stakeholders to communicate findings and raise high risk issues to management
• · Executes with management oversight on special projects and completes ad hoc reporting requests
• · Provides technical and analytical support to the team members
• Ensures data validity, accuracy of results while adhering to compliance policies and procedures

The Skills You Bring

• · Bachelor's degree in business related field, concentration in Information Technology or Analytical Science preferred
• · 2 years of analytics, system and/or report development experience preferred
• · Experience with relational database concepts and query syntaxes like P-SQL or T-SQL (Oracle, Python or SSMS)
• · Experience with AWS or Azure Snowflake platform a plus
• · Experience with business intelligence reporting tools like SAS, Power BI highly preferred
• · Experience with MS Power Query and Visual Basic highly preferred
• · Must be proficient in Microsoft Office Suite - including Excel, Access, PowerPoint, Word, Visio, etc. and standard Enterprise systems
• · Ability to provide advice/direction in primary areas of expertise
• · Strong communication and interpersonal skills
• · Proven ability to perform in-depth analysis and clearly report findings
• · Knowledge of dealer insurance products preferred
• Ability to figure out solutions to problems with little supervision

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.

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

55,000

Experienced

65,000

Expert

80,000

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