Sign up for our
weekly
newsletter
of fresh jobs
Ally is hiring a Senior Data Analyst, Marketing with 5 - 10 years of experience. Based in United States - Detroit, MI and with Hybrid ways of working.Job description and responsibilities:As part of the Data Solutions Support team, this Senior Analyst will be responsible to leverage Snowflake and other data platform to build best-in-class Data Management and Analytical pipelines for Ally's Auto Lending Team. The Senior Analyst at Ally will utilize analytic and technical skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems. Extensive business data and process knowledge will be obtained and used, as well as looking at competitor data and industry trends. The Senior Data Analyst will be responsible to learn our product data in 4 operational systems to obtain an overall picture of Auto Lending business. The Senior Data - Business Analyst will need to have a clear understanding of the business use around downstream data. Participation in Data Governance activities, as well as other corporate data initiatives is also required.The Work Itself• Responsible to come up with Curated data layers that each line of business will be utilizing for analytics and for Business Intelligence• purpose and help build a centralized data warehouse using Ally's Enterprise Data & Analytics standards.• Develop and maintain data pipelines and work closely with data engineering team to migrate to production for e.g. using SQL, Python & Snowflake .• Possess Data Warehousing principals and architecture patterns to help build reporting data marts in Onprem and Cloud databases e.g. Oracle, Snowflake• Experience and working knowledge in extracting data from traditional data warehouse, big data ecosystems and cloud data warehouses toproduce 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 data analysis, data quality monitoring & analytics support.• Advanced working knowledge of SQL, Databases, Python and with the ability to write complex SQL statements to build data tables and produce reports. Working knowledge of SAS is a plus• Proficient in working using Agile methodology for large projects & other tool such as GIT, Visual Studio, Code, Jupyter Notebooks, DBT, Python , RStudio• 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 and qualifications:The Skills You Bring• 5+ Bachelor's degree preferred, Masters is a plus ( field of study: Computer Science, Data Management, Data Science, Management Information System, , Business Analytics)• Good understanding of Auto Lending Processes and Data• DBMS - Snowflake, Oracle, SQL server.• Programming Languages - SQL(Advanced), Python (Preferred), SAS (Nice to have)• Data platforms - Snowflake (Advanced), DBT (Data Build Tool)• Reporting - Power BI(Advanced)• Other Skills - Proficiency with GIT