Data Analyst

First Convenience Bank; Killeen (TX); On-site; USD 55,000 - 75,000; Full time

Job summary

First Convenience Bank in Texas seeks a data analyst to query and analyze data across multiple vendor programs, while maintaining datasets and automating ETL processes.

You will integrate automation, perform exception handling, and create department reports; assist in reconciling data loads into relational and dimensional databases. The role requires rigor, teamwork, and timely distribution of accurate data analyses.

Qualifications

• Use multiple vendor programs to query and extract data for analysis.
• Maintain datasets using Oracle/SQL.
• Integrate automation, ETL/ELT of data, and perform exception handling.
• Create, maintain, and distribute assigned department reporting.
• Assist in reconciliation of data loads into relational and dimensional databases.
• Review department reports for accuracy prior to distribution.
• Perform research and analysis on assigned areas as directed.

Responsibilities

• Use multiple vendor programs to query and extract data for analysis.
• Maintain datasets using Oracle/SQL.
• Integrate automation, ETL/ELT of data, and perform exception handling.
• Create, maintain, and distribute assigned department reporting.
• Assist in reconciliation of data loads into relational and dimensional databases.
• Review department reports for accuracy prior to distribution.
• Perform research and analysis on assigned areas as directed.
• Regular and predictable attendance and punctuality.
• Other duties as assigned.

Skills

Analytical experience

MS Office proficiency

Database understanding

Education

Bachelor's degree in IT/Accounting/Finance preferred

Tools

Oracle/SQL

Job description

• At least 18 years of age
• High School Diploma or equivalent
• Bachelor's Degree in Information Technology, Accounting, or Finance preferred
• Proficient in Microsoft Office with a minimum of one year of analytical experience
• Must be innovative, analytical, and adaptive to working with various applications
• Understand database structures, query languages, and reporting metrics
• Must be able to get along with co-workers and work effectively in a team environment
• Must successfully pass a background investigation according to company policy

Job Description

• Use multiple vendor programs to query and extract data for analysis
• Maintain datasets using Oracle/SQL
• Integrate automation, ETL/ELT of data, and perform exception handling
• Create, maintain, and distribute assigned department reporting
• Assist in reconciliation of data loads into relational and dimensional databases
• Review department reports for accuracy prior to distribution
• Perform research and analysis on assigned areas as directed
• Regular and predictable attendance and punctuality
• Other duties as assigned

Physical Requirements

• Must be able to remain in a sitting stationary position for extended periods of time
• Constantly operate a computer and other office machinery
• Ability to lift up to 25 pounds

Member FDIC, Equal Housing Lender

FCBI is an Equal Opportunity Employer

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at[phone].