Financial Crimes Data Analyst II

• Title
  :
  Financial Crimes Data Analyst II
• Type
  :
  Full Time
• Experience
  : 2+ Years
• Function
  :
  Audit
• Location
  :
  Oklahoma City, OK, United States
• Company
  :
  Mid First Bank

Mid First Bank offers a full range of personal, commercial, trust, private banking, and mortgage banking products and services.

The bank is hiring a Financial Crimes Data Analyst II who will work in a high-paced environment supporting the Financial Crimes department’s ever‑changing data, reporting, and analytical needs in its efforts to mitigate and report on illicit financial activities.

Focus heavily on requirements gathering, data analysis, and building dashboards/reports/tools to: solve problems, automate reporting, or meet specific business needs.

Develop a solid understanding of the existing prevention and detection systems, their related data, and their usage by the business units supported within the Financial Crimes department.

Determine effective, innovative, and timely solutions to challenging business needs and translate often difficult concepts and issues from business to technology and vice versa.

• Bachelor’s Degree is required (advanced degrees/certifications a plus, commensurate experience accepted)

• 2+ years of experience in statistical data analysis, problem-solving, data validation, and reporting
• Experience with SAP Web Intelligence (BIC) report building (preferred)

• Apply statistical or other common analytical methodologies to detect outliers, estimate probability, or provide important data insights.
• Build and utilize dashboards to monitor various data processes for data errors, failures, accuracy, and completeness
• Build SQL queries to explore datasets, run reports, and compare data
• Utilize tools like Tableau, SAP Web Intelligence, Excel, and Notepad++ to perform data validation, develop reporting, or explore new datasets
• Work with DBAs, providing them contextual information regarding data usage and reporting needs when onboarding new datasets
• Work with Financial Crimes business users, outside departments, and vendors to provide or capture data requirements. Build dashboards, reports, processes, or data feeds to facilitate those needs

• Ability to complete assignments with little supervision while adhering to deadlines
• Proactive and self-starting
• Proficient in applying analytic methods to solve business problems and effectively evaluate data or processes to communicate meaningful results and insights
• Proficient in data cleansing and data shaping for visualization purposes
• Proficient in developing clean and intuitive data visualizations and dashboards. (strongly prefer this experience in Tableau)
• Proficient in writing SQL queries and using Microsoft SQL Server 2016+ as a data source
• Proficient with Microsoft Office applications (especially Excel)
• Proven ability to create technical documentation
• Strong oral and written communication skills
• Strong work ethic, independent initiative, and interpersonal skills.

• 401(k)
• Banking Discounts
• Behavioral Health Benefit
• Bonus Awards
• Dental Insurance
• Disability Insurance
• Family Medical Leave
• Health First Wellness Program
• Life Insurance
• Medical Insurance
• Paid Sick Leave
• Paid Vacation Leave
• Tuition Reimbursement Program

Mid First Bank is an Equal Opportunity Employer.