Analyst - Business Intelligence

Ally-Financial; Lewisville (TX); Hybrid; USD 65,000 - 115,000; Full time

Benefits offered by this job

Time Off

401K with company match

Health Insurance

Tuition Reimbursement

Employee stock purchase plan

Job summary

Ally Financial is seeking a detailed Business Intelligence Analyst to join our Data Solutions Support Team in a hybrid role. You will build and maintain dashboards and reports with Power BI, write SQL against Snowflake, and use Python and Power Automate for automation and analytics.

You’ll collaborate across teams to deliver insights that drive operations and decisions. This position emphasizes data quality, scalable analytics, and close partnership with stakeholders to translate needs into

Qualifications

• 1+ years of relevant experience.
• Bachelor's degree in a relevant field.
• Preferred: Banking/financial services analytics experience.
• Experience with SQL and large cloud datasets (Snowflake).
• Proficiency in Excel and data visualization principles.
• Strong communication with technical and non-technical stakeholders.

Responsibilities

• Create data/analytical products to support Auto Operations.
• Design, develop and maintain interactive dashboards and reports using Power BI.
• Write efficient SQL queries to extract and analyze data from Snowflake.
• Use Python and Power Automate for data wrangling, automation and analytics.
• Collaborate with stakeholders to gather reporting requirements and translate into solutions.
• Perform data validation and quality assurance checks.
• Support ad-hoc reporting using Excel and other tools as needed.
• Partner with data and engineering teams to improve data infrastructure.

Skills

Power BI

SQL

Python

Data Visualization

Excel

Communication

DBT

Snowflake

Collaboration

Education

Bachelor's degree in relevant field

Tools

Snowflake

DBT

Power Automate

Power BI

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 OpportunityAt this time, Ally will not sponsor a new applicant for employment authorization for this position. We are seeking a highly motivated and detail-oriented Business Intelligence Analyst to join our Data Solutions Support Team. This hybrid position offering the flexibility to work remotely two days a week while being part of a dynamic and collaborative data team. You'll play a critical role in transforming data into meaningful insights that drive business decisions and operational efficiency. This opportunity is ideal for someone who thrives on solving complex problems, enjoys working with data at scale, and is excited about leveraging modern data tolls to deliver impactful business solutions.The Work ItselfResponsible for creating data/analytical products to provide support to Auto Operations.Design, develop and maintain interactive dashboards and reports using Power-BI to support business monitoring and decision making.Write efficient and optimized SQL queries to extract, analyze, and manipulate data from Snowflake and other data sources.Use Python, Power Automate for data wrangling, automation and advanced analytics.Collaborate with stakeholders to gather reporting requirements, understand business needs and translate them into technical solutions.Perform data validation and quality assurance checks to maintain the accuracy and reliability of reports.Support ad-hoc reporting and data requests using Excel, and other tools as needed.Partner with other data and engineering teams to troubleshoot issues and enhance data infrastructure. Stays current with industry trends and leads development of key data/analytics innovation platforms.The Skills You BringMinimum Qualifications1+ years of relevant experienceBachelor's degree in relevant field of study or equivalentPreferred QualificationsBanking, financial services, and/or analytics experience1+ years of analytical experience required1+ years in Consumer Lending industry is preferred.Advanced knowledge of Ally Code AssistProficiency with Power-BI and a strong understanding of data visualization principles.Hands-on experience with SQL and working with large datasets in cloud-based environments such as Snowflake.Familiar with Python for scripting, automation, or analysis.Experience building and maintain data transformation workflows using DBT preferred.Excellent communication skills to interact effectively with technical and non-technical stakeholders.Proficiency in Excel for data manipulation and reporting.Ability to manage multiple tasks and priorities in a fast-paced environment.#LI-Hybrid#DFSHow 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.