Sr. ERM Data Modeler and Systems Administrator

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.

Sr. ERM Data Modeler and Systems Administrator

ACCOUNTABILITY STATEMENT: The Senior ERM Data Engineer will help modernize Enterprise Risk Management 2nd Line of Defense 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 should be comfortable in a collaborative team-based environment in which they would play a mentoring role towards more entry level-level data engineers. Must demonstrate innate drive to improve and expand their knowledge and technological skillset continuously. While building data pipelines, this role also envisions future state tools to enable 2nd Line risk oversight.

Responsibilities:

• Lead efforts to modernize and replace legacy reporting solutions
• Create and maintain key metadata artifacts including, but not limited to, data lineage, data dictionaries, and Entity Relationship Diagrams (ERD)
• Lead efforts to build access to multiple internal and external databases to enable risk oversight reporting across credit risk exposure, interest rate risk, operation risk and other related risk disciplines

• Review underlying AI scripts to support model interpretability by using python and other related scripting platforms. Reviewing and challenging existing AI models, both internally and through partnership with internal and 3rd party vendor(s).

• Writes or assists with writing test conditions, scripts, and/or scenarios. Participates in testing. Collaborates across the organization especially 2nd Line of Defense and IT teams to ensure that functional requirements are reviewed, addressed and operational in development environment before implementation. Help design and build the approach for proper back-up/restore operations.
• Lend technical and systems expertise to identify and manage risk exposure inherent within the information technology and information security stripe.
• Leverage data analysis techniques to identify trends, predictive indicators, and potential risks to assist ERM leadership with decision making
• Assist business lines with assessing their risk exposure and provide mitigating measures to counteract their inherent risk
• Build new reporting processes and automate existing reports and processes with Python, Visual Basic, Power Shell and other scripting platforms
• Act as a key stakeholder and subject matter expert in data-related projects
• Work closely with the DBA team to build and deploy views, stored procedures, and ETL pipelines for the risk and audit departments
• Work with Access Management to ensure users are allocated appropriate access to various ERM reports and apps (i.e. Least Privilege access rights)
• Build, maintain and improve application databases and warehouses for the ERM department.
• 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
• Collaborate with multi-disciplinary and cross-functional teams to translate business objectives into artificial intelligence approaches and objectives.
• Lead ERM through upcoming migration to Microsoft Azure.
• Work with desktop and systems engineering to build dedicated application servers to host ERM data services
• Work closely with other analysis units to build views and procedures in SQL Server for other analysts and business lines to access data quickly and securely
• Data Wrangling (fetching, cleaning, enriching, transforming, and integrating)
• In-depth working knowledge of software applications development principles, Microsoft operating systems, and Office applications are required.
• Ability to convey highly technical concepts to non-technical stakeholders
• Assist other team members with technical solutions.
• Responsible for working closely with Data Governance, Enterprise Architecture & Data Privacy partners to establish capabilities supporting various initiatives such as the purview cloud and data lakes migration.
• Setting, installing, testing, and maintaining application software and system management
• Evaluate the existing systems and provide the technical direction to IT support staff
• Help design and build the automation for environment/services to be online/offline
• Help design and build the approach for proper back-up/restore operations
• Assist with competitive product evaluations
• Collaborate with others to resolve technical issues and outages
• Provides support for technical issues on Data Governance tools and ensuring system availability
• 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)

EDUCATION and/or EXPERIENCE PREFERENCES:

• Bachelor's degree required. IT, MIS, or related field and experience preferred
• Master's degree in IT, MIS, or related field preferred
• 4+ years of experience in the data warehouse space preferred
• 4+ years of programming experience preferably in Python, Julia or Java.
• 5+ Experience architecting and building ETL pipelines; Hands-on experience with SQL
• Lean Six Sigma Green Belt certification is preferred.

Knowledge, Skills, and Abilities

• Advanced use with statistical computing concepts such as R, Python, etc.
• 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 skills in Python, C#, Javascript and Visual Basic.
• Ability to communicate complex concepts and findings in a clear and concise manner
• Ability to assist with multiple projects, work in fast-paced environment and meet deadlines Maintains professional composure, objectivity and fairness when dealing with conflict or sensitive matters.
• Ability to travel as needed to successfully perform position responsibilities.
• Excellent ability to rely on experience and judgment to plan and accomplish various goals and objectives and to produce high quality materials within tight timeframes.
• Experience with Python servers and frameworks such as flask, quart, fastAPI, starlette, requests, pydantic, sqlalchemy, pyodbc, aioodbc, pandas, matplotlib and numpy.
• Extensive experience working with asynchronous code and async frameworks.
• Dashboarding experience including PowerBI, Tableau and Plotly.
• Knowledge of SQL Server and it's ecosystem (SSIS, SSRS, SSMS, etc)
• Front-end development experience (js, react, vue, etc)
• Strong experience with JSON, XML, YAML, TOML, CSV and other data-interchange and configuration file formats.
• Advanced level expertise using SQL Server.
• Some experience with OOP (Object-Oriented Programming)
• Knowledge of TCP/IP networking and it's principles.
• Must understand Object-Oriented Programming (classes, inheritance, etc)
• Experience designing, developing, and deploying web-based applications.
• Experience with Microsoft IIS & Windows Server 2016

Disclaimers and 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. 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 the 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 object