Financial Crimes Data Analyst

MidFirst Bank is seeking a Financial Crimes Data Analyst in Oklahoma City, Oklahoma (onsite) to help detect, prevent, investigate, and report potential illicit financial activity. The role combines analytical problem-solving with practical data delivery through Tableau dashboards and SQL reporting, with a strong emphasis on data quality and validated insights.

In this position, you will translate business needs into technology solutions and support department operations with timely, professional analysis. You will also document business rules and reporting logic while researching and resolving data, reporting, and system issues.

Key Responsibilities

• Gather business requirements and translate 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, assess likelihood, and convert data into actionable insights.
• Write 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.

Required Qualifications

• Bachelor’s degree required; strong commensurate experience may 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, including the ability to apply analytical techniques to business problems and explain findings to technical and non-technical audiences.
• Proven ability to create effective data visualizations and user-friendly dashboards, preferably using Tableau.
• Proficient SQL development skills, including experience with Microsoft SQL Server 2016 or newer.
• Proficient in preparing, cleansing, and transforming data for reporting and analytics.
• Self-motivated, resourceful, and proactive with a strong sense of ownership and accountability.
• Strong documentation skills for communicating technical concepts, business requirements, and processes.
• Ability to manage multiple priorities, work independently, and meet deadlines with minimal supervision.
• Excellent interpersonal skills and a collaborative approach with cross-functional teams.
• Curiosity and willingness to learn new technologies, business processes, and data sources.
• Proficient with Microsoft Office, particularly Excel.
• Strong written and verbal communication skills.

Preferred Skills & Tools

• Experience building SAP Web Intelligence (BIC) reports is preferred.

Technologies

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

What a Successful Candidate Does Well

• Enjoys investigating why numbers do not match instead of accepting the first answer.
• Treats internal business units like customers and focuses on making their work easier.
• Asks questions when requests are vague or incomplete.
• Takes ownership of problem investigation and recommends next steps.
• Balances responsiveness with ensuring accuracy.
• Translates business needs into technical solutions.
• Explains findings, what still needs confirmation, and what will happen next.
• Provides feedback and contributes to a team knowledge base based on what is learned.