General information

Ref # 17541

Remote? No

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

We are looking for a dynamic Sr. Business Intelligence analyst with excellent communication skills and a background in technology, business intelligence, and strong logic and problem solving. This Senior Analyst will utilize analytical and technical skills to innovate, build, and maintain well-managed data/BI solutions and capabilities to tackle business problems. This analyst would be leveraging Python, SQL, Snowflake, and Power BI to build world class reporting and analytical solutions for Ally's Auto portfolio, strategy and loss forecast Asset Management team.

The Work Itself

• Responsible for the design, development, and support of business intelligence solutions to meet reporting and analytic needs from Ally's Auto portfolio, strategy and loss forecast Asset Management
• Retrieve data from multiple sources to extract, cleanse, aggregate and summarize data using Python, SQL, Snowflake SQL, and SAS to create semantic layers, and to build BI analytical solutions.
• Develop analytical tools and data products for several internal stakeholders, using python and Power BI among other technologies.
• Develop and maintain self-service reporting solutions and/or automated solutions.
• Ensure the quality and accuracy of data by creating automated testing scripts.
• Participate in the design and implementation of logical and physical data models.
• Train and support on Business Intelligence AI capabilities
• Ensure stability, performance and support of production reporting and meet demand for data across Analytic teams.
• Address user questions concerning data integrity.
• Monitoring performance and communicating functional and technical issues proactively
• Interact with senior management, department leaders and other employees to develop and reach agreement on reporting requirements and priorities.
• Advanced working knowledge of Python, SQL, SAS, Snowflake, Power BI, and Database.
• Support Snowflake cloud data platform initiative to bring business teams on board with data, reporting, processes, tools integration, access, and analyst community migration.
• Implement robust, reliable, and custom reporting and visualizations using BI tools (Power BI, ThoughtSpot, Excel etc.)

The Skills You Bring

• Bachelor’s Degree in the field of Business, Finance, Computer Science, MIS, IT or Engineering preferred.
• 3+ years of Reporting and visualization experience in Power BI
• 3+ Years of Experience working with Relational databases, warehouses and cloud data warehouse experience is preferred. Databases - Oracle, Teradata, Hadoop, Snowflake/Redshift
• 3+ Years of Experience writing complex /Advanced SQL/PL SQL and Curating data layers.
• 3+ Years of experience in coding in big data environment, Cloud data platforms such as Cloudera Hadoop, AWS, or Microsoft Azure
• 3 + Years of Experience in Scripting language such as Python/R and must have knowledge to schedule data scripts to automate data.
• pipeline creation.
• Ability to understand, analyze and articulate complex requirements through visualization (Power BI preferred)
• Strong proficiency in DAX and M language.
• Working knowledge of Microsoft CoPilot features
• Working knowledge of visualization libraries in Python (e.g. bokeh, flask, Django, etc.)
• Analytical drive to break down complex problems, and a strong will to deliver results.

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.

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.

Base Pay Range:

Emerging: 70000

Experienced: 95000

Expert: 120000

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