Analyst - Business Analytics, F&I Insurance

Ally-Financial; Detroit (MI); Hybrid; USD 65,000 - 115,000; Full time

Job summary

Ally Financial is hiring a data and analytics professional for the Insurance data and analytics team in Detroit. You will identify trends in complex data sets, collaborate with IT and stakeholders, and create scalable data collection and reporting solutions to drive informed business decisions.

You will develop data connections, extract data using SQL/Snowflake/Python, and build Power BI dashboards while maintaining governance and mentoring new team members.

Qualifications

• 3+ years of data and business analysis experience.
• Bachelor's degree in Mathematics, Economics, Statistics, Information Science or similar background.
• Proficiency with Oracle SQL, Snowflake, Power BI.
• Working knowledge of Python and data governance concepts.
• Strong communication and collaboration skills.
• Familiarity with Jira, Confluence, MS Teams, and ServiceNow.

Responsibilities

• Identify, analyze, and interpret trends or patterns in complex data sets.
• Work closely with management to prioritize business and information needs.
• Locate and define new process improvement opportunities.
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Develop and implement data collection systems and strategies that optimize efficiency and data quality.
• Provide mentoring to new members of the team.
• Work with internal team and IT to support testing and implementing data solutions.
• Interface with multiple IT teams, business groups, and data owners to ensure the data management standard is upheld across the organization.
• Support ad-hoc reporting, analysis, and presentations.
• Develop data connections and extractions using SQL, Snowflake, Python.
• Develop dashboards/analytics using Power BI.
• Maintain high standards of documentation and adherence to data governance.

Skills

Data analysis

Business analysis

Statistical techniques

Communication

Cross-functional collaboration

Project management

Mentoring

Education

Bachelor's degree in Mathematics, Economics, Statistics, Information Science or similar background

Tools

Oracle SQL

Snowflake

Power BI

Python

Jira

Confluence

MS Teams

ServiceNow

Microsoft Access

CoPilot

Excel

PowerPoint

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 OpportunityReporting to the Manager of Insurance data and analytics team, this team member is responsible for data and process analysis projects to support the goals and objectives of the Ally Insurance team. They drive the work to define and recommend measurements, strategies, and reporting using data to support valuable business decisions. Work closely with Insurance leadership, Business Partners, IT, and other stakeholders on opportunity discovery and solution delivery for a variety of projects. The role will continuously optimize and automate data solution's.The Work ItselfIdentify, analyze, and interpret trends or patterns in complex data sets.Work closely with management to prioritize business and information needs.Locate and define new process improvement opportunities.Interpret data, analyze results using statistical techniques and provide ongoing reports.Develop and implement data collection systems and strategies that optimize efficiency and data quality.Provide mentoring to new members of the team.Work with internal team and IT to support testing and implementing data solutionInterface with multiple IT teams, business groups, and data owners to ensure the data management standard is upheld across the organization.Support ad-hoc reporting, analysis, and presentations.Develop data connections and extractions using SQL, Snowflake, Python.Develop dashboards/analytics using Power BI.Maintain high standards of documentation and adherence to data governance.The Qualifications We’re Looking For3+ Years of Data and Business Analysis preferred.Bachelor's degree in Mathematics, Economics, Statistics, Information Science or similar background.Ability to work across cultures and functions.Strong Microsoft Access, CoPilot, Excel, and Power Point skills.Strong organizational, analytical and interpersonal skills.Proficiency in Oracle SQL, POWER BI and Snowflake.Working knowledge of python/snowflake.Ability to manage projects, prioritize and deliver results.Ability to prioritize workload and balance multiple initiatives and effortWorking experience with project management tools like Jira, Confluence, MS Teams, and ServiceNow.Effective and professional oral and written communication skills.Ability to simplify complex problems and develop creative solutions.Minimum Qualifications1+ years of experienceHigh school Diploma or GED 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$65,000.00 - $115,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.