COVID-19 and PPP Loan Forgiveness Update

Actualización sobre COVID-19 y el Programa de Protección de Nóminas

En Español In English

For the latest information on availability of branches, click here.

Para la información mas recente de la disponibilidad de las sucursales, haga clic aquí.

En Español In English
Skip to Main Content

JOB CLASSIFICATION

Full / Part-time: Full Time
Hours Per Week: 40
Location: McAllen, San Antonio, or Fort Worth


JOB SUMMARY

The Data Reporting Analyst is responsible for the collection and analysis of data to support enterprise strategic initiatives. This role will work directly with members of the analytics team to support the entire data lifecycle, including data cleansing, transformation, and loading into various data repositories for later analysis and reporting. This role will help support the team’s overall responsibilities including data governance, business intelligence, enterprise data warehouse, advanced analytics, and business enablement of data analytics. The role ensures that measures of success are created, monitored and reviewed. They will provide answers through analytical modeling of business questions using standardized reporting utilities.

ESSENTIAL DUTIES

The duties listed below may not include all responsibilities that the person in this role may be asked to perform. Incumbent may be required to perform other related duties as assigned.

1. Collaborate with business users to document and implement business requirements; document user requirements and translate requirements into reporting solutions to develop the implementation plan and schedule.
2. Review and interpret reports and analyses to support current business initiatives and support departmental needs for ad hoc reporting. Understand the Bank’s operational requirements and translate them into actionable and consumable reporting.
3. Design, build, and implement new report formats and layouts on a customized basis using dashboard tools
4. Optimize and improve efficiencies, quality, timeliness and sort out relevance of current routine reports and processes. Seek opportunities for automation or enhancement of existing ETL and report design processes.
5. Participate in the projects supporting company strategic initiatives surrounding information gathering, information sharing, and KPI formulation.
6. Participate in cross-functional teams to review, analyze, and strategize on business needs and potential solutions.
7. Validate operational and historical data ensuring that it is accurately captured from various data sources, understanding and interpretation of data formulas, and calculations and troubleshooting of variances.
8. Support data validation efforts as necessary to ensure useable datasets for later downstream interpretations.
9. Provide ongoing support and consultative assistance to various departments across the enterprise regarding analytics platform best practices and design approaches.
10. Work with the data engineering team in support of existing ETL processes and to prioritize data for reporting needs.
11. Automate data gathering, data cleansing, and data prep processes using various intelligent automation utilities.
12. Complete statistical trend and gap analyses to identify efficiency opportunities in internal processes using technical and analytical expertise.
13. Assist with the implementation of data gathering techniques, including digital form and workflow creation.


QUALIFICATIONS

These specifications are general guidelines based on the minimum experience normally considered essential to the satisfactory performance of this position. The requirements listed below are representative of the knowledge, skill and/or ability required to perform the position in a satisfactory manner. Individual abilities may result in some deviation from these guidelines.


1. Bachelor’s degree, with a concentration in Computer Science, Business or a related quantitative discipline.
2. Strong analytical skills to evaluate, understand and interpret data from both internal and external perspective
3. Experience using an enterprise data warehouse and the various analytical tools for visualization and reporting of information
4. Advanced Excel skills of pivot tables, macros, VBA, v-lookup, and report writing to analyze data and consolidate reports
5. Must be able to communicate ideas and analysis results effectively both verbally and in writing to both analytical and non-analytical audience
6. Must demonstrate an ability to recognize and define problems, understand business and system processes, collect data, establish facts, and draw valid conclusions
7. Meticulous attention to detail with an appreciation for the relationship between data quality and the Bank’s success.
8. Familiar with statistical analysis, along with working knowledge of any programming language.
9. Self-motivated with the ability to work both independently and in a team environment
10. Goal oriented, multi-task projects, superior time management and organizational skills
11. Able to manage multiple tasks and projects at the same time in a fast-paced environment.

PREFERRED SKILLS
1. 3-5 years of experience in the functional areas of business analysis, financial analysis, and statistical model development using SQL and/or reporting tools.
2. Banking or financial services experience
3. Proficiency with Sisense (other dashboard reporting tools like Tableau, Looker, Qlik, or similar are OK)
4. Basic knowledge of Python
5. Proficiency with MS Excel, MS Word, Power Point, PowerBI, and Visio


EOE/M/F/D/V

APPLY NOW

Why Work at Vantage?

Our People/Our Culture

At Vantage, we have a committed professional team that share a passion for service. We are a team that values relationships and work together for the greater good of our customers. We strive to follow our motto "One Team. One Bank. One Company."

Our Benefits

  • 401(k) Plan Contribution Match
  • Health & Dental Insurance
  • Disability Insurance
  • Bonus & Incentive Pay Programs
  • Life Insurance
  • Vacation and sick paid leave

Our Programs

  • Health & Wellness Programs
  • Training & Career Development Programs
  • Academic Partnerships
  • Mentorship Program
  • Internship Program

More Perks

  • Employee Advisory Committee
  • Active Community Involvement

For additional information, please call the Human Resources department at (956) 664-8485.