Data Analyst II - Waterford

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. We’re proud of the opportunities, training, benefits and work-life balance we provide to those who help people take their money further, and reach their goals sooner. We strive to provide a culture where employee development, teamwork, integrity, respect and quality of life are the cornerstones of delivering superior member experience. We thank our employees for making us a part of our community’s "Top Workplaces" and are always looking to add people to our team who share our passion for helping members build their finances and confidence. In return, we offer employees a challenging and rewarding work environment and are committed to maintaining an atmosphere that promotes teamwork and continual improvement. Virginia Credit Union is an Equal Opportunity Employer. We've officially merged with Member One Federal Credit Union, now a division of Virginia Credit Union. This merger signifies a step forward in providing our members with a better banking experience and more robust financial products, services, and benefits. Virginia Credit Union employees in the Roanoke and the surrounding area support the Member One division and its members.