Financial Crimes Data Analyst

MidFirst Bank is hiring a Financial Crimes Data Analyst in Oklahoma City, OK (onsite) to help detect, prevent, investigate, and report illicit financial activity through data analytics and reporting.

Responsibilities

• Gather business requirements and convert them into technology solutions
• Provide timely, professional support to the department
• Develop, maintain, and enhance Tableau dashboards
• Apply statistical and analytical techniques to identify unusual patterns and assess likelihood
• Develop SQL queries for reporting, analysis, and data validation
• Research and resolve data quality, reporting, and system issues
• Participate in quality control and validation activities
• Identify opportunities to automate manual processes
• Document business rules, data definitions, processes, and reporting logic

Requirements

• Bachelor’s degree required; strong commensurate experience will be considered in lieu of degree
• Advanced degrees and certifications are a plus
• 2+ years of experience in data analysis, reporting, and data validation
• Strong analytical and critical-thinking skills; ability to apply analytical techniques to business problems
• Ability to explain findings to both technical and non-technical audiences
• Proven ability to create effective, user-friendly dashboards (preferably using Tableau)
• Proficiency in SQL development, including experience with Microsoft SQL Server 2016 or newer
• Proficiency preparing, cleansing, and transforming data for reporting and analytics
• Self-motivated, resourceful, proactive; strong ownership and accountability
• Strong documentation skills for technical concepts, business requirements, and processes
• Ability to manage multiple priorities, work independently, and meet deadlines with minimal supervision
• Excellent interpersonal skills and collaborative approach with cross-functional teams
• Curiosity and willingness to learn new technologies, business processes, and data sources
• Proficiency with Microsoft Office, especially Excel
• Experience building SAP Web Intelligence (BIC) reports is preferred
• Strong written and verbal communication skills

Technologies

• Tableau
• SQL
• Microsoft SQL Server 2016
• Microsoft Office
• Excel
• SAP Web Intelligence (BIC)

A successful candidate will

• Investigate why numbers do not match rather than accepting the first answer
• Treat internal business units as customers and focus on making their work easier
• Ask questions when requests are vague or incomplete
• Take ownership of problem investigation and recommend next steps
• Balance responsiveness with ensuring answers are accurate
• Translate between business needs and technical solutions
• Explain findings, what still needs confirmation, and what happens next
• Provide feedback and contribute to a team knowledge base