Reporting & Analytics Specialist II

First Financial Bank; Cincinnati (OH); On-site; USD 74,000 - 100,000; Full time

Job summary

First Financial Bank seeks a Reporting & Analytics Specialist to support data-driven decision making. You will design, develop, and deliver SQL-driven reports, dashboards, and analytical solutions across departments.

Responsibilities include shaping data strategies, creating advanced dashboards, and partnering with leaders to drive performance. Strong SQL, data visualization, and financial services experience are preferred.

Qualifications

• Bachelor's degree in related field or equivalent experience.
• 5-6 years of business analytics experience with advanced data mining tools.
• Strong analytic, technical, and statistical skills.
• Proficiency in SQL and Excel.
• Experience in financial services is preferred.

Responsibilities

• Design, write, and optimize complex SQL queries to extract and analyze data.
• Develop dashboards and data models to track key metrics and provide insights.
• Collaborate with stakeholders to align solutions with strategic goals.
• Lead reporting requirements and deliver ad hoc analyses as needed.
• Serve as liaison with Enterprise Data Warehouse team for data solutions.

Skills

Advanced data analysis

Strategic thinking

Strong communication

Data visualization

Education

Bachelor's degree in related field

Tools

SQL

Power BI

Tableau

SSIS

Azure DevOps

Git

Job description

We do the right things, right now. We do them in a way that is relevant to our clients. Become a part of our history as it continues to be written!

The Reporting & Analytics Specialist plays a pivotal role in supporting the organization’s data-driven decision-making processes. This position is responsible for collecting, analyzing, and reporting on a wide variety of data to help drive business insights and optimize performance across departments. The specialist assists in the design, development, and delivery of standardized and ad hoc reports, dashboards, and analytical solutions per business requirements.

Essential Functions/Responsibilities

Assist in shaping and executing data strategies to inform business decisions.

Design, write, and optimize complex SQL queries to extract and analyze data from various sources.

Document, evaluate and improve design of reports and processes to ensure that analytical tools, evolve as the business changes.

Develop trend analyses and other quantitative reports to determine business trends.

Partner with leaders to further analyze data and develop recommendations for improvement.

Maintain capacity planning models in partnership with each business unit.

Adjust model based on business needs and provides recommendations and solution (i.e. load balancing) to drive business performance.

Develop advanced dashboards, reports, and data models to track key metrics and provide actionable insights.

Perform maintenance on existing schedules and reports for changes to information.

Serve as the primary liaison between assigned business units and Enterprise Data Warehouse team for new development requests and complex data solutions.

Lead the identification of reporting requirements and collaborate with stakeholders to develop solutions that align with strategic business goals.

Support system changes and analysis while executing User Acceptance Testing plans to ensure overall risk management.

Define and document data definitions, report logic, and data sources using standard industry methodology.

Minimum Knowledge, Skills, and Abilities Needed to Perform Essential Functions of the Job

Bachelor's degree in related field or equivalent experience.

5-6 years of business analytic experience which includes advanced data mining tools.

Must possess ability to think strategically.

Strong analytic, technical, and statistical skills with proven ability to process vast amounts of data into meaningful information and interpret statistical trends.

In-depth understanding of product features, benefits, pricing, and positioning preferred.

Ability to design and deliver reporting to meet various business needs and management requirements.

Proficiency in data visualization tools such as SSIS (SQL Server Integration Services); Azure Dev Ops; GIT, Power BI, Tableau, etc.

In depth knowledge of database concepts and data warehousing principles.

Ability to communicate effectively with leadership and internal business partners.

Ability to thrive in a dynamic and fast-paced environment.

Strong computer aptitude.

Proficiency in SQL, and Excel.

Preferred Knowledge and Skills Microsoft certifications or other relevant data analytics certifications.

Experience with other programming languages (I.e. Python)

Experience in financial services industry.

Level of Complexity and Scope

Support important initiatives and key projects across the company in a rapid-moving environment. Leverage critical thinking skills to help the team meet objectives. Handles moderate to high-complexity data analysis and reporting assignments.

Degree of Independence and Decision-Making

Independently develops, customizes, and maintains multi-source reports, advanced dashboard and analytical solutions.

Ability to identify opportunities for methodological improvement and proposes enhancements.

Manage task and priorities with guidance from management using your best judgment to solve various problems.

Required Supervisory Responsibilities

No direct supervisory responsibilities over other employees. Provide support and guidance to other team members and mentor junior data analysts to ensure successful project delivery.

Physical Requirements

Prolonged periods of deskwork. Frequent use of computer, keyboard, phone, and office equipment. Clear and effective communication in person and over the phone. Occasional moving within the office or to other locations within the building. Occasionally lifting and carrying light objects, typically up to 10-15 pounds.

Compliance Statement

The associate is responsible for meeting all compliance requirements imposed by First Financial Bank by State and Federal law and regulation, as well as all related First Financial Bank policies and procedures. This includes all Bank Secrecy Act, Anti-Money Laundering, OFAC and Suspicious Activity reporting requirements, as well as all other lending and deposit compliance requirements.

Development and Training Pay Range: $74,000/year to $100,000/year

Benefits

We have relevant, thoughtful benefits and programs that support every aspect of our associates' holistic wellbeing. Please review our Benefits Guide.

Incentive Eligibility

All roles are incentive eligible with the exception of Co-Op, Intern, or Student positions.

It is our policy to not discriminate against any individual in violation of federal, state, and local laws as it relates to age, race, color, religion, national origin, sex, marital status, pregnancy, gender identity, disability, sexual orientation, genetic information, veteran/military service, or any other characteristic protected by law.

We are an E-Verify Employer.

At first financial bank, our mission is clear: to be the best bank to do business with, the best place to work, and the best financial partner for our shareholders and the communities we serve. We believe that how we work is just as important as what we achieve. That’s why we’re guided by core values that shape everything we do: Doing the right thing Teamwork Mutual respect Wellbeing Excellence Our success starts with our people. We know that when our associates are talented, engaged, and supported, they create outstanding results. If you're looking to be part of a team that values integrity, inclusion, and collaboration—and where your growth matters—you’ll find your future here.