• BI Analyst II - CVL

    Job Locations US-TX-Irving
    Requisition ID
    Employee Type
    Full Time-Regular
    Commercial Lending / Wholesale Lending
  • Overview

    The BI Analyst II – CVL is responsible for providing BI solutions that effectively monitor Commercial Vehicle Lending business activity and facilitate strategic decision making.



    • Develop and maintain accurate and effective data solutions such as list reports, crosstabs, charts, interactive dashboards and ETL processes using Cognos Analytics, SAS Enterprise Guide, SAS Visual Analytics and Informatica for users both within the department and across the company
    • Lead collaborative sessions with various business groups to gather and document BI project requirements
    • Work with various ITS and business functions such as Systems Integration, Data Warehouse and BI Administration to ensure that source system data is available for assigned projects
    • Properly document BI processes as they are moved into production
    • Continually seek opportunities to refine, improve, and automate data gathering and reporting
    • Complete ad-hoc reporting requests as needed
    • Maintain a thorough understanding of CVL products and source system processes and the associated impacts on data sources
    • Establish and maintain positive working relationships with internal CVL team members and various external departments
    • Act as a resource for less experienced CVL BI team members, providing guidance on more complex tasks
    • Seek training and mentoring from peers for cross-functional growth, learning, and career development



    • Strong understanding of relational database technology and design
    • Strong understanding of data visualization concepts
    • Strong understanding of ETL concepts
    • Advanced knowledge of Cognos Report Studio/Cognos Analytics, SAS Enterprise Guide, SAS Visual Analytics, Informatica, and Oracle SQL queries
    • Advanced knowledge of MS Excel, MS Power Point, and MS Word
    • Understanding of Consumer or Commercial Vehicle Lending with emphasis on auto finance loan and lease product offerings to borrowers a plus
    • Understanding of Fiserv LOS and LeaseMaster a plus


    • Advanced problem-solving and critical thinking skills that allow for the use of unconventional solutions when necessary
    • Advanced analytical and technical skills with demonstrated high attention to detail
    • Ability to effectively analyze and gather requirements from all levels of management
    • Extremely proactive and naturally inquisitive, with a strong bias for action
    • Ability to use appropriate and reasonable analysis, judgment, logic and communications methods when solving problems, making decisions, and communicating results
    • Ability to design and implement data solutions with minimal supervision
    • Ability to successfully prioritize and manage multiple assignments simultaneously
    • Interpersonal skills necessary to develop and maintain productive relationships
    • Ability to effectively communicate with team members of various technical and business backgrounds
    • Ability to listen to and communicate effectively with others, both verbally and in writing
    • Must demonstrate uncompromised integrity, while successfully managing work demands, day-to-day pressures and meeting established deadlines


    • Bachelor’s Degree in Business or computer related field preferred


    • 3-5 years of experience in a reporting, BI, or ETL role preferred

    Work Conditions

    • High energy and fast paced office environment subject to stressful conditions and required deadlines
    • Work schedule may include some nights or weekends as needed


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.