Reporting & Analytics Specialist II

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!

If you are interested and qualified for this role we invite you to apply.

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

• Bachelors 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 on 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:

$74000/year to $100000/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.