Data Wrangler

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.

Data Wrangler

ACCOUNTABILITY STATEMENT

The incumbent will execute the data development function of the Advanced Data Analytics (ADA) team and assist the Senior Manager Advanced Analytics in carrying out the team's goals as well as the broader Finance department mission in collaboration with the Financial Planning and Analysis (FP&A) and Financial Risk Management (FRM) teams.

The Advanced Data Analytics function refers to the predictive and prescriptive modeling imperative. This includes shaping the analytics strategy from design, development and modeling through implementation of solutions. This team will work heavily with business groups and senior leadership to ensure advanced analytic use cases are defined and implemented with value in mind. ADA is responsible for a wide spectrum of use cases including member-, operation-, market-, and industry-focused analytics. The ADA team's mandate is to add business value through focused advanced data analytics.

The objective interest of the incumbent is to meet the data needs of the team's data scientists in support of defined use cases and identified mathematical models by using internal enterprise data sets and external public and/or purchased data sets. The incumbent must be able to work with very large data sets that are either static or dynamic, understand trade-offs associated with cost and time in handling and migrating very large data sets. The incumbent must be able to work with both numerical and text data, and know how to use and manage metadata to define and add dimension to data sets. Data may originate from a wide selection of data sources such as databases, document directories, CDs, DVDs, magnetic tape, paper documents, electronic documents (e.g., PDFs), email, web servers (especially cookies), websites, FTP servers, and online data sources (especially public data sources such as the US Census), and the incumbent must be able to work with these sources and more. The incumbent will partner closely with IT offices (Information Management, Enterprise Architecture, Operations, Information Security) to ensure data are captured, ingested, curated, stored, and transported to point-of-need, in compliance with governmental laws, established data ethics, and company security protocols, and properly resourced to support model development and deployment. Incumbent will principally use Microsoft solutions for on-premise (e.g., MS SQL Server) and cloud-based (e.g., MS Azure) resources to actualize the objective interest of this job. Incumbent will work with tabular (e.g., CSV) and hierarchical data (e.g., JSON, XML) sources using SQL database scripting, according to need. The incumbent will use Python, R, Java, and related modules (e.g., pandas), packages, and libraries in support thereof, to handle and process data to meet modeling needs as described and detailed by the team's data scientists. The incumbent will make use of APIs to retrieve specific data from large data sources. The incumbent will practice version control via GitHub or another suitable environment, as identified by team leadership, and project documentation via Jupyter Notebooks or another suitable utility, as identified by team leadership. The incumbent will utilize the scrum development method for iterative and incremental progression towards project objectives, and will routinely collaborate with the team's data scientists and/or business units to discover, define, and modify deliverables. The incumbent will share and transfer knowledge with other team members and be able to receive knowledge from other team members.

The successful incumbent will be able to perform exploratory data analysis (EDA) to explore data structure, data variables, data types, range of possible values, and data errors, missing values, and outliers. The incumbent will modify data sets by extracting variables, merging data sources, converting data formats, restructuring data, removing outliers, correcting errors, or imputing missing values, as needed. The incumbent will report on data quality and recommend action for improving data quality either through techniques related to data processing, or by working with business units and employees at data point-of-entry to improve business processes related to data quality. The incumbent will work with business units to source data, identify data definitions, and understand work processes that informs such data definitions. The incumbent will produce summary statistics and data visualizations that report on the quality of data sets.

ESSENTIAL JOB DUTIES

• Use SQL, Python, Julia, R, Java, and related modules, packages, and libraries, to handle and process tabular and hierarchical data to meet modeling needs as described and detailed by the team's data scientists.
• Modify data sets by extracting variables, merging data sources, converting data formats, restructuring data, removing outliers, correcting errors, or imputing missing values, to meet use case specifications as defined by the team's data scientists.
• Work with both numerical and text data to develop requisite data models in support of identified use cases. Apply metadata to define and add dimension to such data models.
• Work with tabular and hierarchical data sources using SQL database scripting.
• Capture, ingest, curate, store, and transport data sets, including very large data volumes, to meet the modeling needs of the team's data scientists.
• Comply with all governmental laws, established data ethics, and company security protocols, in the handling and development of data objects.
• Ingest and curate identified internal and external structured and unstructured datasets, along with associated metadata, in support of identified use cases.
• Partner and collaborate with IT (Information Management, Enterprise Architecture, Information Security, Operations, Project Management) to secure and use resources and processes necessary to support the business objectives of Advanced Analytics.
• Develop and maintain data dictionaries used in identified use cases. Coordinate with data governance on custom data definitions.
• Analyze data sets for integrity and quality and report out using summary statistics and/or data visualization tools such as dashboards.
• Conduct exploratory data analysis to explore data structure, data variables, data types, range of possible values, and data errors, missing values, and outliers.
• Use cloud or on-premise infrastructure to pipeline data into data models in the development environment. Assist and make recommendations in data and technology road mapping through partnership with IT Information Management and IT Enterprise Architecture.
• Make use of APIs to retrieve specific data from large data sources.
• Practice version control and project documentation.
• Use scrum development method for iterative and incremental progression towards project objectives.
• Collaborate with business unit sponsoring the use case to identify solutions, source data, identify data definitions, and understand work processes that informs such data definitions.
• Share information and transfer knowledge with other team members and be able to receive knowledge from other team members.

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

Focus Give your full attention by observing and listening.

Connect Build rapport by consistently being friendly and approachable.

Understand Actively listen and ask questions to identify needs.

Counsel Recommend solutions based on needs and objectives.

Advance Ask for or assume next step action; verify follow-up action.

EDUCATION & EXPERIENCE

Required

• Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, Data Science, Business Analytics, Engineering or other technology-related field or equivalent number of years of experience.
• Minimum two (2) years of experience with data warehousing to include dimensional data tables, fact tables, and data intelligence solutions.
• Strong analytical and problem-solving skills.
• Experience with data handling, sourcing, storage, merging, shaping, and quality analytics, and especially of very large data volumes.
• Experience with exploratory data analysis used to explore data structure, data variables, data types, range of possible values, and data errors, missing values, and outliers.
• Experience working directly with business units in requirements gathering and data discovery.
• Experience with a wide selection of data sources such as databases, document directories, CDs, DVDs, magnetic tape, paper documents, electronic documents (e.g., PDFs), email, web servers (especially cookies), websites, FTP servers, and online data sources (especially public data sources such as the US Census).
• Experience with metadata, data dictionaries, and data governance.
• Experience with relational database management systems.
• Experience with confidential data.
• Experience with communication of technical material using accessible language appropriate to audience.
• Experience with data visualization tools in business intelligence and/or data science such as PowerBI, Tableau, D3.js, GGplot, etc.
• Experience with Python, R, Julia, Java, Scala, and associated modules, packages, or libraries.
• Experience with computational notebooks such as Jupyter.
• Experience with version control environments such as GitHub.
• Experience with use of APIs for data extraction and transfer.
• Experience with JSON, XML, and other hierarchical data formats.
• Experience with scrum project management.
• Experience with digital storytelling via dashboards and other forms of data visualization.

Preferred

• Experience developing data and analytic solutions for a credit union or bank.
• Experience with Cassandra or similar environments.
• Experience with cloud services for data analytics and especially in MS Azure with Machine Learning Studio, Databricks, SQL Database, Data Lake, and Data Factory.
• Experience with statistical modelling, quantitative analysis, CRISP-DM, or ASUM-DM.
• Experience with Pandas.
• Experience with data mining tools such as SAS, SPSS, or other similar statistics and analytics environments.
• Experience with business analytics, data science, machine learning, or artificial intelligence.

JOB KNOWLEDGE, SKILLS & ABILITIES

Required

• Knowledge of data analysis, visualization, and statistical tools. Such systems may include SQL, Python, R, Julia, Java, Scala, SAS, SPSS, Power BI, Tableau, etc.
• Skills in data handling, sourcing, storage, merging, shaping, and quality analysis.
• Ability to conduct exploratory data analysis (EDA) to explore data structure, data variables, data types, range of possible values, and data errors, missing values, and outliers.
• Skills in discovery and requirements gathering with clients in a business unit.
• Ability to work with a wide assortment of data sources including mixed media.
• Knowledge of data governance and as it relates to data dictionaries and associated metadata.
• Knowledge of time versus cost trade-offs related to data transfer and maintenance.
• Ability to appropriately handle confidential data.
• Strong communication skills including presentation, interpersonal, and writing skills.
• Skills in data visualization with business intelligence tools such as PowerBI, Tableau, D3.js, Ggplot, etc.
• Skills with usage of computational notebooks such as Jupyter.
• Skills with version control methods.
• Skills with usage of APIs for data extraction and transfer.
• Ability to work with hierarchical data formats.
• Knowledge of scrum project management.
• Avid and positive team player that works well across multi-disciplined organization.
• Creative, logical, and strategic thinker with very strong analytical skills.
• Advanced skills in MS Excel, and typical skills in MS PowerPoint and MS Word.

Preferred

• Understanding of core financial systems used in banking.
• Working knowledge of the credit union or banking industry.
• Understanding of the process of innovation and concept development.
• Understanding of model deployment into production.

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 objects.