What are the responsibilities and job description for the Sr BI Engineer - Informatica position at GM Financial?
NOTE: We are unable to offer sponsorship for this position
Why GM Financial?
GM Financial is the wholly owned captive finance subsidiary of General Motors and is headquartered in Fort Worth, U.S. We are a global provider of auto finance solutions, with operations in North America, South America and the Asia Pacific region. Through our long-standing relationships with auto dealers, we offer attractive retail financing and lease programs to meet the needs of each customer. We also offer commercial lending products to dealers to help them finance and grow their businesses.
At GM Financial, our team members define and shape our culture — an environment that welcomes new ideas, fosters integrity and creates a sense of community and belonging. Here we do more than work — we thrive.
Our Purpose: We pioneer the innovations that move and connect people to what matters
Responsibilities
About the role:
As a Sr Business Intelligence Engineer, you will be working in one of the world's largest data warehouse environments in the automotive finance industry supporting originations functions. You will help build, manage, and maintain one of the largest cross-functional databases at GM Financial as well as work on Business Intelligence reporting and dashboarding solutions that are used by thousands of users in North America. The Sr BI Engineer has deep expertise in the design, creation, management, and business use of large datasets. You will have excellent communication skills to be able to work with business owners to develop and define key business questions and to build data sets that answer those questions. The Sr BI Engineer should have expertise in designing, implementing, and operating stable, scalable, low-cost solutions to flow data from various systems and sources into targets such as the data warehouse, other data repositories/solutions, and into end-user facing applications. You should be able to work with business customers in a fast-paced environment understanding the business requirements and implementing reporting solutions. Above all, you should bring your passion for working with huge data sets and bringing datasets together to answer business questions and drive change.
JOB DUTIES
- Engage with leadership in the originations organization and diversified functional groups to understand the needs and recommend business intelligence and reporting solutions
- Own the design, implementation, and maintenance of ongoing metrics, reports, analyses, and dashboards, to drive key business decisions
- Partner with technology teams to define, extract, transform, and load data from many data sources using SQL and other tools
- Automate and simplify self-service or reporting pipelines, including improving ETL workflows, automatic alarming and performance tuning
- Conduct deep dive analyses of business problems and data issues and formulate conclusions and recommendations for leadership and technical teams
- Participate in strategic and tactical planning discussions and provide data insights Challenge business teams to think differently about how they digest and use the data insights to make informed decisions
- Make recommendations for new metrics, techniques, and strategies to improve business KPI's
- Work with data and software development teams to enable the appropriate capture and storage of key data points
Qualifications
What makes you a dream candidate?
- Relevant experience in one or more of the following areas: Data engineering, database engineering, business intelligence or business analytics
- Hands-on experience in writing complex, highly-optimized queries across large data sets
- Experience in scripting languages like Python, Unix, Java, etc
- Demonstrated strength in data modeling, ETL development, and data warehousing
- Experience with data integration tools such as Informatica or Azure Data Factory, etc
- Experience in working and delivering end-to-end projects independently
- Experience with Microsoft Power BI data modeling
- Demonstrated ability to effectively interact with internal and external customers
- Ability to manage assigned tasks and responsibilities with little to no supervision in a fast-paced environment
- Advanced analytical skills
- Detail oriented with a keen focus on accuracy and effective reporting
- Good oral and written communication skills
- Understanding of auto finance industry loan operations
Experience and Education
- 5 years of relevant experience in one or more of the following areas: data engineering, database engineering, business intelligence or business analytics required
- 5 years of hands on experience in writing complex, highly optimized queries across large data sets required
- 2 years of experience in scripting languages like Python, Unix, Java, etc required
- 7 years of experience with ETL tools such as Informatica or others; experience designing multi-dimensional reports preferred
- 5 years of report development experience preferred
- 3 years of experience with Microsoft Power BI data modeling preferred
What We Offer: Generous benefits package available on day one to include: 401K matching, bonding leave for new parents (12 weeks, 100% paid), tuition assistance, training, GM employee auto discount, community service pay and nine company holidays.
Our Culture: Our team members define and shape our culture — an environment that welcomes innovative ideas, fosters integrity, and creates a sense of community and belonging. Here we do more than work — we thrive.
Compensation: Competitive pay and bonus eligibility
Work Life Balance: Flexible hybrid work environment, minimum of 2-days a week in office in Fort Worth, Texas