Data Analyst

Job Description

Job Description

Lead cross-functional projects using advanced data modeling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities

Create and document routine processes around data (mining, dictionary, etc.)

Completes the gathering and cleaning processes for data from various sources, ensuring data quality and integrity

Build, develop and maintain data models, reporting systems, data automation systems, dashboards and performance metrics support that support key business decisions

Uses statistical methods and techniques to help identify patterns, trends, correclations and anomalies of bank data

Examine, interpret and report results of analytical initiatives to stakeholders in leadership, technology, sales, marketing and product teams

Lead the strategic design and maintenance of intelligence systems, reporting platforms, and other enhancements required to gather and analyze bank and portfolio data

Collaborate with other data engineers and IT professionals to optimize data collection, storage, and retrieval processes

Helps identify KPIs and develops metrics to track and measure bank performance

Maintains current knowledge of internal risk controls and loss prevention, including reporting of suspicious or unusual customer activity per Bank policy, and ensures adherence by the respective department personnel

Maintains current knowledge and complies with all federal and state laws and regulations and all established Bank policies and procedures, including internal audit controls related to department operations, and ensures adherence by the respective department personnel

Maintains current knowledge of all rules, regulations, and laws as they apply to BSA / OFAC / USA Patriot Act / CIP / AML, and ensures adherence by the respective department personnel

Qualifications

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.

• Bachelor’s degree from an accredited college or university in computer science, statistics, or data management
• Minimum of 5 years of experience in an analytical role including querying relational databases and advanced reporting methodologies
• Able to articulate complex concepts while tailoring the message to different audiences including senior leadership, technical teams, and member support teams
• Strong problem solving and ability to resolve complex issues with minimal direction
• Ability to leverage key performance metrics and data to provide insights and make strategic business recommendations
• Proficiency with SQL, Python and visual reporting tools (such as MS Power BI or Tableau)
• Some Knowledge of financial institution regulations including Reg Z, Reg. B, Truth in Lending, FCRA, FACTA and MLA
• Excellent verbal and written communication skills; able to express ideas concisely and logically
• Ability to meet deadlines, work in a fast-paced environment, and perform a variety of tasks with numerous interruptions
• Advanced knowledge of Microsoft Office Suite
• Ability to sit in front of a computer screen for long periods of time, which may cause visual strain
• Bilingual in English and Spanish is desiredMicrosoft SQL Server, Microsoft SQL, SQL Queries, Database Object, Data Analysis, Microsoft Power BI, Statistical Analysis, Python