Assoc Analyst - Business Intelligence

Ally Bank; United States; On-site; USD 60,000 - 85,000; Full time

Benefits offered by this job

Travel allowances

Relocation assistance

Signing bonus

Equity

Job summary

Ally Financial is seeking an Associate Analyst - Business Intelligence to develop, enhance, and maintain BI solutions enabling data-driven decisions. You will use SQL and Power BI to analyze data, build reports, validate data, and translate insights for stakeholders.

The role partners with business and data teams to understand needs, investigate questions, and deliver reliable data products. Strong analytical and communication skills are essential.

Qualifications

• Experience with SQL, data warehousing, Power BI, and MS Excel.
• Experience gathering business requirements, using BI tools to extract data, formulate metrics and build reports.
• Analytical drive to break down complex problems and deliver results.
• Excellent communication and interpersonal skills with both business and technical teams.
• Quick learner with ability to initiate and execute small to medium projects.

Responsibilities

• Develop and maintain Power BI reports, dashboards, and BI solutions.
• Write and troubleshoot SQL queries to analyze, transform, and validate data.
• Partner with stakeholders to translate business needs into data and reporting solutions.
• Perform data validation, quality checks, and root-cause analysis to ensure reporting accuracy.
• Analyze data and communicate actionable insights to technical and non-technical stakeholders.
• Collaborate with cross-functional teams on reporting and analytics initiatives.
• Support production reporting by monitoring refreshes, answering data questions, and investigating defects.

Skills

SQL

Power BI

Excel

Data analysis

Communication

Education

High school Diploma or GED

Tools

Snowflake

DBT

Python

Job description

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 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:

The Opportunity

The Associate Analyst - Business Intelligence supports the development, enhancement, and maintenance of business intelligence solutions that enable data-driven decision-making. This role uses tools such as SQL and Power BI to analyze and transform data, develop reports and dashboards, perform data validation and quality checks, and translate complex information into clear, actionable insights.

The analyst will partner closely with business stakeholders and cross-functional data teams to understand business needs, investigate data questions and discrepancies, and support the delivery of reliable and scalable data products. The ideal candidate is analytical, curious, detail-oriented, and a strong problem solver who can communicate effectively with both technical and non-technical audiences.

The Work Itself

Job Responsibilities

• Develop and maintain Power BI reports, dashboards, and BI solutions.
• Write and troubleshoot SQL queries to analyze, transform, and validate data.
• Partner with business stakeholders to translate business needs into data and reporting solutions.
• Perform data validation, quality checks, and root-cause analysis to ensure reporting accuracy.
• Analyze data and communicate actionable insights and recommendations to technical and non-technical stakeholders.
• Collaborate with cross-functional business and data teams on reporting and analytics initiatives.
• Support production reporting by monitoring report refreshes and availability, responding to business data questions, and investigating defects.

The Qualifications We’re Looking For

Required:

• Experience with SQL, data warehousing, Power BI, and MS Excel
• Experience gathering business requirements, using industry standard business intelligence tools to extract data, formulate metrics and build reports
• Analytical drive to break down complex problems, and a strong will to deliver results
• Excellent communication (verbal and written) and interpersonal skills and an ability to effectively communicate with both business and technical teams
• Quick learner and has demonstrated ability to initiate, develop and execute small to medium scale projects

Preferred:

• Banking, financial services, and/or analytics experience
• 1+ years of analytical experience required
• Proficiency 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.

Minimum Qualifications

• 0+ years of experience
• High school Diploma or GED equivalent

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

In accordance with the Americans with Disabilities Act, if afterreview 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 accommodationrequest.

Base Pay Range

$60,000.00 - $85,000.00

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