General information
Career area
Consumer Analytics
Country
United States
Work Location(s)
2911 Lake Vista Drive, TX, 500 Woodward Avenue, MI, 5851 Legacy Circle, TX
Remote?
No
Ref #
17984
Posted Date
Tuesday, August 6, 2024
Working time
Full time
Ally and Your Career
Ally Financial only succeeds when its people do - and that's more than some clichpeople 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?
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 Opportunity
As part of the Data Solutions Support team, this Analyst will be responsible to leverage Snowflake, AWSto build best-in-class Data Management and Analytical pipelines for Ally's Auto Asset Management team. The Analyst at Ally will utilize analytic and technical skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems.
The Work Itself
• * Responsible to play as Data Analyst role to help build a centralized data warehouse using Ally's Enterprise Data & Analytics standards.
• Responsible to come up with Curated data layers that each line of business will be utilizing for analytics and for Business Intelligence purpose.
• Develop and maintain data pipelines and work closely with data engineering team to migrate to production Oracle, Big Data platforms:Cloud databases eg: Snowflake/Red Shift based on business need.
• Possess Data Warehousing principals and architecture patterns to help build reporting data marts in Oracle, Big Data platforms: Hadoop and Cloud data bases eg: Snowflake/Red Shift
• Experience and working knowledge in extracting data from traditional data warehouse, big data ecosystems and cloud data warehouses to produce critical data for business analyst executives and operational leaderships.
• Partner with the business to consult and translate the business needs to design and develop tools, techniques, metrics, and dashboards for insights/data visualization.
• Able to work in Agile team and help formulate technical stories for the data engineering team and help prioritize them based on business-critical data needs.
• Advanced working knowledge of SQL, Databases and working knowledge of SAS/Python/DBT with the ability to write complex SQL statements to build data tables and produce reports
• 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.
The Skills You Bring
• * Bachelor's degree preferred, Masters is a plus (field of study: Computer Science, Data Management, Data Science, Management Information System, Business Analytics)
• At least 3 years of experience data analysis and data management
• At least 3 years of programming experience in ANSI SQL, SAS, working knowledge of Python, and data warehouse platforms along with experience in Snowflake.
• RDBMS - Oracle, Snowflake, SQL server.
• Programming Languages - SQL(Advanced), Python (Preferred), DBT (Preferred), SAS (Nice to have)
• Data platforms - AWS, Snowflake (Advanced), Oracle
• Data governance/risk management - Alation, Manta, Collibra Data Quality, Observability etc.,
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
Location: Lewisville, TX
Posted: Oct. 27, 2024, 9:36 p.m.
Apply Now Company Website