Skip to content

General information

Career area
Work Location(s)
2911 Lake Vista Drive, Lewisville, TX, 500 Woodward Avenue, Detroit, MI
Ref #
Posted Date
Tuesday, April 19, 2022
Working time

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

As a part of the Strategic Risk Management Team, this individual will be responsible to build world class Data Management and curated data solution for Data Solutions Support. Also, as Data Management Analyst at Ally you will leverage analytic and technical skills to innovate, build, and maintain well-managed data solutions and capabilities to tackle business problems.

The Work Itself

  • Responsible to come up with Curated data layers that each line of business will be utilizing for analytics and also for Business Intelligence purpose.
  • Develop and maintain data pipelines and work closely with data engineering team to migrate to production Oracle, Big Data platforms: Hadoop and Cloud data bases e.g. 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 e.g. 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 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 in the field of Computer Science, MIS, IT or Engineering preferred 
  • 2+ Years of Experience working with Relational databases , warehouses and cloud data warehouse experience is preferred.   Databases - Oracle, Teradata , Hadoop , Snowflake/Redshift 
  • 2 + Years of Experience writing complex /Advanced SQL/PL SQL and Curating data layers. 
  • 1 + Years of experience in coding in Big data environment, Cloud data platforms such as Cloudera Hadoop, AWS or Microsoft Azure 
  • 1 + Years of Experience in Scripting language such as Python/R and must have knowledge to schedule data scripts to automate data pipeline creation.
  • Functional knowledge and working knowledge of various data architecture patterns and have a good understanding of data warehouse and big data technology 
  • 1 + years of Reporting and visual experience such as Power BI, Cognos and Tableau 

How We'll Have Your Back