Analyst - Business Intelligence

Ally Financial Inc.
Lansing, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior

Job location

Remote
Lansing, United States of America

Tech stack

Microsoft Excel
Amazon Web Services (AWS)
Automation of Tests
Data Governance
Data Integrity
Data Structures
Data Systems
Python
Microsoft SQL Server
Oracle Applications
Power BI
SQL Databases
Snowflake
Information Technology
Collibra
Data Analytics
Data Management
Streamlit Framework

Job description

For over 100 years we've helped dealers serve their customers by providing the best-in-class products and services they need - and by remaining true to the automotive passion we share. Take the wheel on your career and join a team that is dedicated to providing world-class support to our customers as they look to purchase and lease vehicles. We are problem solvers, we value diverse thinking, we support one another, and we challenge ourselves to think bigger in the journey to deliver customer-obsessed auto finance products and solutions.

As part of the Data Solutions Support team, the Analyst will be responsible for developing and delivering data and reporting solutions required for Consumer Auto business audits and exams. The Analyst at Ally will utilize technical and analytics skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems.

This role follows a hybrid work model, with an expectation of three days in-office and two days working remotely each week. This may change in alignment with enterprise-wide policies.

The Work Itself

  • Responsible for the design, development and support of data and reporting solutions to meet Legal, Federal and State exam needs
  • Implement robust, reliable and custom solutions, using tools such as Python, Posit and Streamlit
  • Develop and maintain self-service data and reporting solutions
  • Develop and maintain data governance procedures to ensure data integrity
  • Use Snowflake and Python for data preparation: ingesting, extracting, cleansing, aggregation and summarizing and creating insightful visuals
  • Ensure the quality and accuracy of data by creating automated testing scripts
  • Ability to navigate and understand complex data structures
  • Addressing user questions concerning data integrity
  • Interact with senior management, department leaders and other employees to develop and reach agreement on data and reporting requirements and priorities
  • Stays current with industry trends and leads development of key data/analytics innovation platforms
  • Ability to display complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner
  • Ensure stability, performance and support of production reporting and meet demand for data across Analytic teams
  • Able to run multiple projects in parallel and should be communicating on status and risks timely.

Requirements

  • 1+ years of relevant experience in Computer Science, Data Management, Data Science, Management Information System, Business Analytics or Engineering.
  • Bachelor's degree in relevant field of study or equivalent

Preferred Requirements

  • 2+ years of relevant experience
  • Bachelor's degree with a preferred field of study in Computer Science, Data Management, Data Science, Management Information System, Business Analytics or Engineering.
  • Strong organizational, analytical and interpersonal skills
  • Snowflake, Oracle, SQL Server
  • SQL, Python, Excel experience
  • Data platforms - AWS, Snowflake, Oracle
  • Reporting - Power BI (nice to have)
  • Data governance/risk management tools (nice to have) - Alation, Manta, Collibra Data Quality etc.

Benefits & conditions

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.

About the company

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?, 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.

Apply for this position