Consumer Lending Data Modeler

At VyStar, we offer competitive pay, an excellent benefit package that includes a 401(k) Plan, an extensive paid technical and on-the-job training program, and tuition reimbursement--available to all full and part time employees. Part time positions start at a minimum of 30 hours per week.

We encourage you to become a part of VyStar Credit Union's family of employees.

Consumer Lending Data Modeler

ACCOUNTABILITY STATEMENT

The Consumer Lending Data Modeler will help modernize the Consumer Lending architecture and infrastructure to include developing and maintaining data workflows, ETL processes, SQL queries and data visualization. The candidate should be proficient with database design, data visualization and scripting concepts. The candidate will also be a key driver in turning the Lending vision to a reality with regards to the technical aspects of the member experience within the lending flow. This individual will be a key player on all projects related to Consumer Lending, and will be able to understand complex technical and developmental solutions in order to ensure business requirements are adequately addressed and met as expected by 3rd party vendors. Communication will be key, as this role will be responsible for the translation of said complex technical solutions in order to provide updates and lead general requirement gathering conversations with the business.

ESSENTIAL JOB FUNCTIONS

• Responsible for working closely with Data Governance, Enterprise Architecture & Data Privacy partners to establish capabilities supporting various initiatives.
• Setting, installing, testing, and maintaining application software and system management.
• Evaluate the existing systems or processes and provide the technical direction to IT support staff.
• Design and build the automation for reports and dashboards using both internal and external data sources
• Help design and build the approach for proper back-up/restore operations.
• Lead Consumer Lending through the impending migration to Microsoft Azure.
• Assist with competitive 3rd party technological or data product evaluations.
• Work with 3rd party vendors to assist with integration management within our Lending Origination System, to ensure that, from a build perspective, we are working efficiently and within parameters.
• Collaborate with others to resolve technical issues and outages.
• Provides support for technical issues on Data Governance tools and ensuring system availability.
• Leverage data analysis techniques to identify trends, predictive indicators, and potential risks to assist lending leadership with decision making.
• Develop and automate reports and processes with Python, Visual Basic and Power Shell.
• Act as a key stakeholder and subject matter expert in data-related projects.
• Work closely with the DBA team and other business partners to build and deploy views, stored procedures, and ETL pipelines for the Consumer Lending and other peer departments.
• Partner with IT Business Intelligence as a data steward to build, maintain and improve application databases and warehouses for the Consumer Lending department.
• Develop and analyze reporting around quarterly bureau pulls on membership base, including evaluating custom features, to identify and recommend opportunities for penetration within certain markets and product-lines.
• Develop and enhance REST APIs to provide business lines with a means to access their data efficiently and securely on the network.
• Leverage front-end Javascript-based (e.g. plotly.js, echarts.js) charting libraries to build custom web-based BI dashboards.
• Work with internal business partners to build dedicated application servers to host Consumer Lending data services.
• Data Wrangling (fetching, cleaning, enriching, transforming and integrating) to include scraping from external sources to automate and develop new reporting pipelines for Senior Lending Management to monitor performance within market segmentations.
• Collaborate with multi-disciplinary and cross-functional teams to translate business objectives into artificial intelligence approaches and objectives.
• Work with clients and team leads to discover data sources and create data requests; collaborate with data engineers to develop and utilize the ETL process to ingest and enrich structured and unstructured data.
• Implementing data strategies and developing new data models around forecasting and risk management.
• Updating and optimizing existing AI models, both internally and through partnership with 3rd party vendor(s).
• Evaluating implemented data systems for variances, discrepancies, and efficiency, to include both existing 3rd party AI models and future implemented models
• All other duties as assigned (note: essential functions and responsibilities may change or new ones may be assigned at any time with or without notice).

JOB KNOWLEDGE, SKILLS & ABILITIES

• 4+ years of experience in the data warehouse space
• 4+ years of programming experience preferably in Python, Julia or Java.
• 4+ Experience architecting and building ETL pipelines; Hands-on experience with SQL
• Familiarity with statistical computing concepts such as R
• Strong experience with web scraping
• Strong experience designing, developing and deploying web-based applications.
• Strong experience utilizing Microsoft IIS, Windows Server 2016, & Microsoft Azure
• Strong experience utilizing Python servers and frameworks such as flask, quart, fastAPI, starlette, requests, pydantic, sqlalchemy, pyodbc, aioodbc, pandas, matplotlib and numpy.
• Extensive experience utilizing, writing, and working with asynchronous code and async frameworks.
• Strong dashboarding experience including PowerBI, Tableau and Plotly.
• Strong experience and knowledge of SQL Server and it's ecosystem (SSIS, SSRS, SSMS, etc)
• Front-end development experience (js, react, vue, etc)
• Strong experience utilizing JSON, XML, YAML, TOML, CSV and other data-interchange and configuration file formats.
• Some experience with OOP (Object-Oriented Programming)
• Knowledge of TCP/IP networking and it's principles.
• Must understand Object-Oriented Programming (classes, inheritance, etc)
• Ability to convey highly technical concepts to non-technical stakeholders
• Strong skills in Python, C#, Javascript, SQL and Visual Basic.

EDUCATION

• Bachelor's degree is required, preferably in IT, MIS, or related field.
• Lean Six Sigma Green Belt certification is preferred.

VYSTAR EXCELLENCE

Incumbent is expected to demonstrate each of the following VyStar Excellence Behaviors in performing the duties and responsibilities of their job.

Focus - Focus your full attention by carefully listening to and observing your client or member,

Connect - Consistently be friendly and approachable. Demonstrate you care.

Understand - Listen empathetically and ask questions. (70%/30%)

Counsel - Recommend solutions based on your clients or member's needs and objectives.

Advance - Ensure that member's expectations were exceeded.

Verify necessary follow-up action.

DISCLAIMERS & WORK ENVIRONMENT

Nothing in this position description is an implied contract for employment. The position description is intended to be an accurate account of the essential functions of the position. The functions are not all encompassing and are subject to change at any time by management.

The work environment characteristics described are representative of those that an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

As required or requested, may exert up to 20 pounds of force occasionally and/or a negligible amount of force constantly to lift, carry, push, pull or otherwise move objects