Senior Analyst- Advanced Business Analytics

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

oResponsible 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

oRetrieve data from multiple sourcesto extract, cleanse, aggregate and summarize data using Python, SQL, Snowflake SQL, and SAS to create semantic layers, and to build BI analytical solutions

oPartner with the business to provide consultancy and translate the business needs to design and develop tools, techniques, metrics, and dashboards for insights and data visualization.

oDevelop analytical tools and data products for several internal stakeholders, using python and Power BI among other technologies.

oDevelop and maintain self-service reporting solutions and / or automated solutions

oEnsure the quality and accuracy of data by creating automated testing scripts

oParticipate in the design and implementation of logical and physical data models

oTrain and support on Business Intelligence AI capabilities

oEnsure stability, performance and support of production reporting and meet demand for data across Analytic teams

oAddress user questions concerning data integrity

oMonitoring performance and communicating functional and technical issues proactively

oInteract with senior management, department leaders and other employees to develop and reach agreement on reporting requirements and priorities

oAdvanced working knowledge of Python, SQL, SAS, Snowflake, Power BI, and Database.

oWorking knowledge of Big data concepts and data retrieval from Hadoop ecosystem.

oSupport Snowflake cloud data platform initiative to bring business teams on board with data, reporting, processes, tools integration, access, and analyst community migration

oImplement 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 5+ years of Reporting and visualization experience such as Power BI, Cognos, MicroStrategy, Tableau, and Excel etc.

3+ Years of Experience working with Relational databases, warehouses and cloud data warehouse experience is preferred. Databases - Oracle, Teradata, Hadoop, Snowflake / Redshift 5+ 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 Functional knowledge and working knowledge of various data architecture patterns and have a good understanding of data warehouse and big data technology 1 - 2 years of experience in the auto financial services industry, with knowledge of (or exposure to) portfolio, forecast, servicing operations in consumer finance preferred 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 Ability to deal with ambiguity and competing objectives in a fast-paced environment Ability to display complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner Excellent communication (verbal and written) and interpersonal skills and an ability to effectively communicate with both business and technical teams Quick learner and critical thinker with demonstrated ability to initiate, develop and execute small to medium scale projects Work well within a team of analysts and collaborate with individuals with technical and non-technical backgrounds Ability to work effectively in fast paced environment with tight deadlines

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.

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 : 11 paid holidays, 20 paid time off days, and 8 hours of volunteer time off, yearly (paid time off is prorated based on start date)
• 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.
30+ days ago