Reporting & Analytics Specialist II

First Financial Bank • Cincinnati, OH

3d • $74,000 - $100,000 • Onsite

About The Position

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.

Requirements

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

Nice To Haves

• In-depth understanding of product features, benefits, pricing, and positioning preferred.
• Microsoft certifications or other relevant data analytics certifications.
• Experience with other programming languages (I.e. Python)
• Experience in financial services industry.

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

Benefits

• We have relevant, thoughtful benefits and programs that support every aspect of our associates' holistic wellbeing. Please review our Benefits Guide.
• All roles are incentive eligible with the exception of Co-Op, Intern, or Student positions.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree