Job Description:
This position is located onsite in Richmond VA.
Position is responsible for supporting data and information needs of the VACU enterprise, requiring strong partnership with various business areas to understand objectives, identify opportunities, and interpret data for improved business decision making. Individual will work with various data sets using scripts, queries, and online platforms to extract, clean, interpret, and prepare data for answering business questions and providing actionable insights. Individual will also partner heavily with data scientists for predictive model development and deployment. In addition to analytic results, deliverables may also include production of new reports, customized dashboards, data workflows, and automated processes.
JOB DUTIES AND RESPONSIBILITIES:
- Provide data and analytical support to departments throughout VACU
- Analyze data to identify trends, opportunities, and general insights, and partner with departments to create actionable response plans
- Design and develop data visualizations and contextual data narratives
- Regularly monitor performance of ongoing models and data solutions ensuring continued performance
- Work with business departments to gather and translate high-level requirements into effective reporting and process efficiency solutions
- Write stored procedures, triggers, packages and jobs to extract data for reporting and integrating with other systems/uses
- Deliver on time-critical ad hoc requests
- Assist end users with issues/questions relating to data, analytics, business intelligence, the data warehouse and other processes supported by the team
- Develop and document procedures for programs and processes
- Develop and maintain a working knowledge and understanding of VACU data sources
- Complete all required, ongoing enterprise level training including, but not limited to BSA, OFAC, and Information Security.
- Report all Risk Management Policy violations in accordance with policy.
- Other duties may be required and assigned by the supervisor
JOB QUALIFICATIONS:
Knowledge:
- Strong knowledge of credit union operations and underlying databases (e.g. MISER, Member360, Temenos, etc.)
- Strong working knowledge of SQL and Microsoft SQL Server tools (e.g. SSMS, SSRS)
- Strong working knowledge of R and/or Python preferred
- Knowledge of Tableau for dashboard creation, data visualization, and deployment
- Proficient with Microsoft Office products (e.g. Excel, Power Point, etc)
- Knowledge of business intelligence principles and best practices
- Knowledge of business process analysis
Skills:
- Strong critical thinking, analytical and problem solving skills
- Experience formulating or contributing to proof concept analyses
- Ability to derive in depth insights from data
- Strong coding skills
- Experience translating complex business requirements into technical specifications
- Strong attention to detail
- Excellent oral and written communication skills
- Experience working on project teams
Abilities:
- Ability to leverage concepts and tools used in statistical analysis, model building, and data analysis
- Ability to consult with end users to identify and clarify business objectives
- Ability to work independently and extensively with SQL databases, views, tables and related disciplines
- Proven ability to work creatively and analytically in a problem-solving environment
- Ability to gather business requirements and translate them into functional models, prototypes, and live solutions
- Ability to effectively communicate technical information to non-technical staff
- Ability to independently and effectively organize, prioritize, and manage multiple assignments with challenging deadlines
- Ability to validate, standardize, and cleanse data when needed
- Ability to troubleshoot problems and suggest alternatives, looking beyond the obvious to find answers
- On rare occasion, must be able to meet flexible work schedule including holidays, weekends and evenings
Minimum Education and Experience:
- Bachelor’s degree in statistics, math, computer science, engineering, or other analytic discipline.
- Significant work experience in an environment with emphasis on business analytics, reporting, and data warehouse systems.
- Significant hands-on experience coding in a scripting language
- SQL experience including SQL database design, stored procedures, SSIS, SSRS
- Experience with Tableau and/or other BI tool packages
- Experience with R or Python preferred
- Experience documenting business processes preferred
- Prior experience in financial industry preferred
PHYSICAL REQUIREMENTS:
- This job requires the ability to sit for long periods of time.
- This job requires infrequent lifting or carrying of objects up to 10 pounds.