On-Site Data Analytics & Audit Systems Analyst

Mechanics Bank; Walnut Creek (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

Mechanics Bank is seeking a Data Analytics and Systems Analyst to join our team on-site in Walnut Creek, CA. You will support Internal Audit and Credit Review through data acquisition, analytics development, reporting, and technology administration, serving as a bridge between audit, business units, and the software development team.

This role focuses on building data solutions within Optro Accelerate, developing dashboards and automated tests, and coordinating API connections across enterprise

Qualifications

• 4 Year Bachelor’s degree in Information Systems, Data Analytics, Computer Science, Business Analytics, Finance, Accounting, or a related field is preferred.
• 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.

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

Skills

Data analytics

Audit analytics

SQL

Python

Power BI

Alteryx

API connectivity

Data governance

Data quality

Excel

Communication

Team collaboration

Education

Bachelor's degree in Information Systems / Data Analytics / Computer Science

Tools

Optro Accelerate

Alteryx

ACL

IDEA

Power BI

SQL

Python

Job description

Mechanics Bank is seeking a Data Analytics and Systems Analyst to join our team on-site in Walnut Creek, CA. You will support Internal Audit and Credit Review through data acquisition, analytics development, reporting, and technology administration, serving as a bridge between audit, business units, and the software development team.

This role focuses on building data solutions within Optro Accelerate, developing dashboards and automated tests, and coordinating API connections across enterprise