Ally
General information
Ref #
20316
Remote?
No
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
The Opportunity
At Ally, you get a startup feel, but experience the benefits of a company that has worked out the kinks and is fulfilling its purpose. We are always evolving and see that as a good thing. From owning our work to seeing its impact in the real world, our team is relentless in finding new ways technology can help make experiences better and help people. We are problem solvers, we value diverse thinking, we support one another, and we challenge ourselves to think bigger in the journey to deliver customer-obsessed tech solutions. To read more about what our tech team does, be sure to visit our tech blog at Ally.Tech.
We are looking for a highly skilled and enthusiastic SQL and Power BI lead to support our Cybersecurity Technology & Risk Automation initiatives. This role is ideal for a lead with 5-7 years of experience in data engineering, visualization, and analytics, who is eager to grow their skills while contributing to a critical area of IPRM Risk Management. You will collaborate with senior developers, cybersecurity analysts, and risk managers to design, build, and maintain risk data warehouse and testing analytics solutions.
At this time, Ally will not sponsor a new applicant for employment authorization for this position.
The Work Itself
The Work Itself
Assist in designing and developing complex data models and ETL pipelines in Postgres/Snowflake and Power BI to support cybersecurity reporting and Technology Risk Management needs.
Write, test, and optimize SQL and DAX queries for data extraction, transformation, and visualization.
Support the creation and maintenance of automated testing routines using SQL and reporting using Power BI.
Collaborate with cybersecurity and risk teams to gather and clarify data requirements, ensuring alignment with business objectives.
Troubleshoot and resolve issues in data workflows and Power BI reports, ensuring data accuracy and performance.
Maintain comprehensive documentation for data solutions and processes.
Stay updated on emerging technologies and best practices in Postgres, Snowflake, Power BI, and data engineering.
The Skills You Bring
The Skills You Bring
Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent work experience.
At least 5 years of hands-on experience with SQL, Python, relational databases, and data visualization tools like Power BI or Tableau.
Good understanding of Databases (Snowflake, Postgres etc), including database design and query optimization, and Power BI features like DAX and Power Query.
Demonstrable experience in integrating Power BI with SQL data sources and other data platforms.
Strong analytical and problem-solving skills with a keen attention to detail.
Excellent communication and teamwork skills, with a demonstrated ability to mentor and guide junior team members.
Preferred Skills:
Exposure to cybersecurity concepts, risk management, or related metrics is a plus.
Knowledge of cloud platforms like Snowflake, AWS, or Azure, particularly in relation to data services.
Experience with Python or similar programming languages for data automation.
Familiarity with advanced Power BI features such as Row-Level Security and Power BI Embedded.
#LI-Hybrid
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.
Base Pay Range:
An individual's position in the range is determined by the scope and responsibilities of the role, work experience, education, certification(s), training, and additional qualifications. We review internal pay, the competitive market, and business environment prior to extending an offer.
Emerging:
110000
Experienced:
145000
Expert:
180000
Incentive Compensation: This position is eligible to participate in our annual incentive plan
Ref #
20316
Remote?
No
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
The Opportunity
At Ally, you get a startup feel, but experience the benefits of a company that has worked out the kinks and is fulfilling its purpose. We are always evolving and see that as a good thing. From owning our work to seeing its impact in the real world, our team is relentless in finding new ways technology can help make experiences better and help people. We are problem solvers, we value diverse thinking, we support one another, and we challenge ourselves to think bigger in the journey to deliver customer-obsessed tech solutions. To read more about what our tech team does, be sure to visit our tech blog at Ally.Tech.
We are looking for a highly skilled and enthusiastic SQL and Power BI lead to support our Cybersecurity Technology & Risk Automation initiatives. This role is ideal for a lead with 5-7 years of experience in data engineering, visualization, and analytics, who is eager to grow their skills while contributing to a critical area of IPRM Risk Management. You will collaborate with senior developers, cybersecurity analysts, and risk managers to design, build, and maintain risk data warehouse and testing analytics solutions.
At this time, Ally will not sponsor a new applicant for employment authorization for this position.
The Work Itself
The Work Itself
Assist in designing and developing complex data models and ETL pipelines in Postgres/Snowflake and Power BI to support cybersecurity reporting and Technology Risk Management needs.
Write, test, and optimize SQL and DAX queries for data extraction, transformation, and visualization.
Support the creation and maintenance of automated testing routines using SQL and reporting using Power BI.
Collaborate with cybersecurity and risk teams to gather and clarify data requirements, ensuring alignment with business objectives.
Troubleshoot and resolve issues in data workflows and Power BI reports, ensuring data accuracy and performance.
Maintain comprehensive documentation for data solutions and processes.
Stay updated on emerging technologies and best practices in Postgres, Snowflake, Power BI, and data engineering.
The Skills You Bring
The Skills You Bring
Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field, or equivalent work experience.
At least 5 years of hands-on experience with SQL, Python, relational databases, and data visualization tools like Power BI or Tableau.
Good understanding of Databases (Snowflake, Postgres etc), including database design and query optimization, and Power BI features like DAX and Power Query.
Demonstrable experience in integrating Power BI with SQL data sources and other data platforms.
Strong analytical and problem-solving skills with a keen attention to detail.
Excellent communication and teamwork skills, with a demonstrated ability to mentor and guide junior team members.
Preferred Skills:
Exposure to cybersecurity concepts, risk management, or related metrics is a plus.
Knowledge of cloud platforms like Snowflake, AWS, or Azure, particularly in relation to data services.
Experience with Python or similar programming languages for data automation.
Familiarity with advanced Power BI features such as Row-Level Security and Power BI Embedded.
#LI-Hybrid
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.
Base Pay Range:
An individual's position in the range is determined by the scope and responsibilities of the role, work experience, education, certification(s), training, and additional qualifications. We review internal pay, the competitive market, and business environment prior to extending an offer.
Emerging:
110000
Experienced:
145000
Expert:
180000
Incentive Compensation: This position is eligible to participate in our annual incentive plan