Data Analytics and Systems Analyst (Irvine, Roseville & Walnut Creek, CA - Federal Way & Seattle Administration Office, WA)

Mechanics Bank; Federal Way (WA); On-site; USD 90,000 - 130,000; Full time

Job summary

Mechanics Bank is seeking a Data Analytics and Systems Analyst to support Internal Audit and Credit Review through data acquisition, analytics development, and reporting. This role collaborates with the Software Development team to identify data needs and enable access to timely information on-site in Washington.

You will develop automated testing, analytics capabilities in Optro Accelerate, assist with SOX testing, and help prepare reports for board-level committees while maintaining data

Qualifications

• Bachelor's degree in a related field preferred.
• Minimum 2 years in data analytics, business intelligence, reporting, audit analytics, risk management, technology, or a related field.
• Experience with data warehouses, databases, reporting platforms, or analytics tools preferred.
• Banking or financial services experience preferred.
• Strong ability to translate business and audit requirements into technical data solutions.

Responsibilities

• Identify and prioritize data requirements for Internal Audits, Credit Reviews, and continuous monitoring activities.
• Develop and maintain data analytics, automated testing routines, and monitoring solutions within Optro Accelerate.
• Support administration of the Optro platform, including user support and documentation.
• Assist Internal Audit with SOX testing, data collection, and control monitoring.
• Support Audit Manager/Director in audit administrative duties and presentations for committees.
• Travel 10-20%.

Skills

Data analytics

SQL

Power BI

Python

Education

Bachelor's degree (Information Systems, Data Analytics, CS, Business Analytics, Finance, or Accounting)

Tools

Optro

Alteryx

ACL

IDEA

SQL

Power BI

Python

Job description

Mechanics Bank is currently searching for a Data Analytics and Systems Analyst to join our team. Here at Mechanics Bank, we value connection, partnership, long term relationships and working together in person. This role will be working on-site.

Under the supervision of Audit Management, the Data Analytics & Systems Analyst is responsible for supporting the Internal Audit and Credit Review functions through data acquisition, analytics development, reporting, and technology administration. This position serves as a liaison between Internal Audit, Credit Review, business units, and the Bank's Software Development team to identify data needs, develop reporting solutions, and facilitate access to reliable and timely information. The Data Analytics & Systems Analyst supports the development and maintenance of automated testing and data analytics capabilities within Optro Accelerate, assists with application integrations and API connectivity, and provides support for audit technology platforms. The position may also support Internal Audit's SOX testing program and other department initiatives as assigned.

The Data Analytics & Systems Analyst must also assess compliance with established Bank policies, procedures, federal/state regulations, SOX requirements, and prudent banking practices. The Data Analytics & Systems Analyst may also support the Chief Auditor, Director and Audit Management team by preparing reports and presentations for Operating Committee, Audit Committee and the Board related to findings management and the status of audit plan.

What you will do:

• Partner with Internal Audit and Credit Review teams to identify and prioritize data requirements for Internal Audits, Credit Reviews, and continuous monitoring activities. This will include collaborating with the Software Development team and other technology partners to develop, validate, and maintain recurring and ad hoc reports and data extracts used by Internal Audit and Credit Review.
• Develop and maintain data analytics, automated testing routines, and monitoring solutions within Optro Accelerate to improve audit efficiency and coverage. This will include coordinating with business units, technology teams, and application owners to facilitate API connections and data integrations between enterprise systems and Optro.
• Support administration of the Optro platform, including user support, configuration, testing, documentation, and other duties assigned by the Optro System Administrator.
• Assist Internal Audit with SOX testing support, data collection, control monitoring, and special projects as assigned.
• Supports the Audit Manager and/or Audit Director in audit administrative related duties as requested to do so.
• Travel 10-20%.

Who you are:

• 4 Year Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business Analytics, Finance, Accounting, or a related field is preferred.
• Relevant analytics or technology experience may be considered in lieu of degree.
• 2 years minimum of experience in data analytics, business intelligence, reporting, audit analytics, risk management, technology, or a related field required.
• Experience working with data warehouses, databases, reporting platforms, or analytics tools preferred.
• Banking or financial services experience preferred.
• Strong understanding of data analysis, reporting, data governance, and data quality concepts.
• Familiarity with Optro, Alteryx, ACL, IDEA, Power BI, SQL, Python, or similar analytics tools is preferred
• Experience developing data analytics, automated testing, dashboards, or continuous monitoring solutions.
• Knowledge of API integrations, data interfaces, and enterprise application connectivity.
• Experience working with databases, data warehouses, reporting tools, and business intelligence platforms.
• Ability to translate business and audit requirements into technical data solutions.
• Strong analytical and problem-solving skills with attention to detail and accuracy.
• Ability to effectively communicate technical concepts to non-technical audiences.
• Proficiency in Microsoft Excel and other Microsoft Office applications.
• Strong organizational skills with the ability to manage multiple priorities and deadlines.
• Ability to work independently and collaboratively across business, audit, and technology teams.
• Maintains confidentiality and professionalism when handling sensitive company information.
• Demonstrates motivation, enthusiasm, curiosity and professionalism.
• Oral and written communications skills relating to the ability to write routine reports and correspondence, ability to comprehend