New

Financial Crimes Data Analyst II

MidFirst Bank
United States, Oklahoma, Oklahoma City
Feb 20, 2025
Description Position Description: The Financial Crimes Data Analyst 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. This position will focus heavily on requirements gathering, data analysis and building dashboards/reports/tools to: solve problems, automate reporting or meet specific business needs. Data Analyst will be required to 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. They will be expected to determine effective, innovative, and timely solutions to challenging business needs and translate often difficult concepts and issues from business to technology and vice versa. Principal duties and responsibilities: 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 Apply statistical and/or other common analytical methodologies to detect outliers, estimate probability or provide important data insights. Utilize tools like Tableau, SAP Web Intelligence, Excel, and Notepad++ to perform data validation, develop reporting or explore new datasets Build SQL queries to explore datasets, run reports and compare data Work with DBAs, providing them contextual information regarding data usage and reporting needs when onboarding new datasets Build and utilize dashboards to monitor various data processes for data errors, failures, accuracy and completeness Position Requirements: Bachelor's degree required (advanced degrees/certifications a plus, commensurate experience accepted) Strong analytical skills with 2+ years' experience in statistical data analysis, problem solving, data validation and reporting Proficient in applying analytic methods to solve business problems and effectively evaluate data or processes to communicate meaningful results and insights 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 in data cleansing and data shaping for visualization purposes Proficient with Microsoft Office applications (especially Excel) Experience with SAP Web Intelligence (BIC) report building preferred Ability to complete assignments with little supervision while adhering to deadlines Proven ability to create technical documentation Strong work ethic, independent initiative, and interpersonal skills. Proactive and self-starting Strong oral and written communication skills To be considered for this position you must reside in the area Incomplete applications will not be considered Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)