Financial Crimes Data Analyst II

FinanceInfos; Oklahoma City (OK); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

401(k)

Banking Discounts

Behavioral Health Benefit

Bonus Awards

Dental Insurance

Disability Insurance

Family Medical Leave

HealthFirst Wellness Program

Life Insurance

Medical Insurance

Paid Sick Leave

Paid Vacation Leave

Tuition Reimbursement Program

Job summary

MidFirst Bank in Oklahoma City is seeking a Financial Crimes Data Analyst II to support the Financial Crimes department’s data, reporting, and analytical needs. Focus on gathering requirements, analyzing data, and building dashboards, reports, and tools to automate reporting and meet business requirements.

Develop understanding of prevention and detection systems, translating concepts between business and technology, and delivering innovative solutions for challenging business needs.

Qualifications

• Bachelor’s degree is required (advanced degrees/certifications a plus, commensurate experience accepted).
• 2+ years of statistical data analysis, problem-solving, data validation, and reporting.
• Experience with SAP Web Intelligence (BIC) report building (preferred).

Responsibilities

• 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.

Skills

Independent worker

Analytical thinking

Data cleansing

Data visualization (Tableau)

SQL querying

Excel proficiency

Technical documentation

Communication skills

Project initiative

Problem solving

Education

Bachelor’s Degree

Tools

SAP Web Intelligence

Tableau

SQL Server

Excel

Notepad++

Job description

Job Highlights

• Title: Financial Crimes Data Analyst II


• Type: Full Time


• Experience: 2+ Years


• Function: Audit


• Location: Oklahoma City, OK, United States


• Company: MidFirst Bank

Company Profile

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

Job Profile

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.

Education Level

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

Work Experience

• 2+ years of experience in statistical data analysis, problem-solving, data validation, and reporting


• Experience with SAP Web Intelligence (BIC) report building (preferred)

Duties/Responsibilities

• 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

Skills/Knowledge/Abilities

• 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.

Benefits/Perks

• 401(k)


• Banking Discounts


• Behavioral Health Benefit


• Bonus Awards


• Dental Insurance


• Disability Insurance


• Family Medical Leave


• HealthFirst Wellness Program


• Life Insurance


• Medical Insurance


• Paid Sick Leave


• Paid Vacation Leave


• Tuition Reimbursement Program

Employer’s Statement

MidFirst Bank is an Equal Opportunity Employer.