Skip to content

General information

Career area
Loan Administration/Operations
Work Location(s)
2911 Lake Vista Drive, Lewisville, TX, 500 Woodward Avenue, Detroit, MI
Remote?
No
Ref #
21-7449
Posted Date
Monday, May 23, 2022
Working time
Full-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

We are looking for a team member with excellent communication skills, with a background in technology, business intelligence, and strong logic and problem solving. This team member will support growing Analytics capabilities and emerging technologies for the Sales, Pricing and related areas of Data Solutions Support. Extensive business data and process knowledge will be obtained and used in support of completing and maintaining business processes, reporting, and ad-hoc analysis, as well as process improvement efforts. This position will work closely with members of other data analytics teams, in addition to model development of Sales, Pricing, Data Governance and related teams to ensure accuracy, regulatory compliance and timely delivery of analysis.

The Work Itself

    • • Responsible to play as Data Product Owner 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: 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
    • • May have responsibility for the supervision and leadership of others
    • • Trains and mentors others
    • • Project planning & tactical execution: Analytical ability to propose strategic and tactical plans

The Skills You Bring

  • • Around 5 Years of Data and Business Analysis Preferred
  • • Bachelor's degree in Computer/Information Science or similar background preferred
  • • Strong organizational, analytical and interpersonal skills
  • • Strong technical knowledge and/or skills for area of expertise AND/OR management knowledge of Data Analytics reporting and management
  • • General understanding of the requirements of the any use case of Data Warehousing environment (Star/DataVault modelling) functionality.
  • • Strong background building and maintaining data warehousing infrastructure
  • • Strong Programming skills.
  • • Complex Problem-solving skills
  • • Strong in Requirement Gathering
  • • Strong documentation skills on data lineage across SAS/Cloud based environments.
  • • Good understanding of Cloud based DW environment.
  • • Strong Microsoft Access, Excel, and Power Point skills
  • • Strong programming skills (good to have): SAS/eDAP, R or Python preferred
  • • Strong Data Warehousing skills including ETL tools experience (DataStage, Nifi, QliK etc)
  • • Proficiency in Oracle SQL or SAS SQL and strong experience with data querying
  • • Proficiency in PowerBI or other reporting/analysis tools (i.e: Cognos, Tableau)
  • • Technical expertise in ETL, data models, database design development, and data mining, data testing/analysis.
  • • Technologies:
  • a) Platforms/Tools: RDBMS: Oracle, Snowflake, SQL server, ETL (DataStage, Qlik, NiFi etc), Excel, SAS/eDAP and respective tools.
  • b) Languages: SQL(Advanced), Python (Good to have).
  • c) Cloud/On-Prem Data platforms: Hadoop, AWS/MS AZURE, Snowflake (Snow SQL), Oracle- Data Warehousing
  • d) Reporting: Power BI(Recommended), Cognos, Tableau
  • e) DW data models: Star and Data Vault modelling

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.