Job was saved successfully.
Job was removed from Saved Jobs.

This job is archived

(Archived) Business Intelligence Analyst

Last Updated: 9/01/22

Job Description

Apply in the link below!
Business Intelligence Analyst in CINCINNATI, Ohio | Careers at QCS - HOME OFFICE (icims.com)

Summary of Responsibilities:


Leverages technical skills along with understanding of business strategies, priorities and initiatives to provide actionable reports, dashboards, data analysis tools and CRM capabilities that empower business decision-makers and business users to gain insights and make strategic business decisions. Responsible for leading or participating in requirements, design, development, testing, training, and production support across these solutions. Serves as the subject matter expert for WSFGD and Touchstone data, reporting and CRM needs. Demonstrates an understanding of multiple databases, data flows and relationships across various sources. Builds collaborative relationships and communicates effectively with business and IT leaders, project team members and vendors to assure project success. Solves moderately complex business and technical problems. Responds with flexibility to changing priorities or new project assignments as they arise throughout the year. Works with minimal supervision and is responsible to make an established range of decisions. Escalates to management when necessary and updates management on a regular basis.

Position Responsibilities:

  • Develops solid understanding of business strategies, priorities and initiatives. Builds collaborative relationships and communicates successfully with associates at all levels, across business and IT. Uses appropriate business-friendly terminology and speaks in appropriate technical terms with IT associates.

  • Leverages business knowledge, coupled with technical skills, to offer solutions and work in partnership with both business and IT to lead or participate in technology-related projects.

  • Designs, develops, tests and delivers reports, visualizations, dashboards and CRM enhancements.

  • Understands databases, collects requirements from business partners and collaborates with IT to create data structures that support reporting and dashboard development.

  • Troubleshoots report, business intelligence, data and CRM-related issues.

  • Mentors, trains and shares knowledge with peers and business users.

  • Develops and implements best practices with peers and maintains confidentiality.

  • Responds with flexibility to changing priorities and new projects that arise throughout the year.

  • Performs other duties as assigned by management.

Selection Criteria
  • 2-4 years of experience in SQL, relational database knowledge, reporting, business intelligence and CRM support.

  • Demonstrated moderate experience with query tools and relational databases.

  • Beginner to moderate experience with business intelligence and CRM tools.

  • Demonstrated ability to understand business strategies and establish appropriate priority across multiple projects.

  • Proven experience successfully communicating with all levels of associates, including executives and developing relationships with business and IT associates.

  • Proven experience delivering reports, dashboards and visualizations to business users.

  • Demonstrated ability to respond in a positive, professional manner to multiple deadlines and shifting priorities.

  • Demonstrated experience identifying and solving problems independently.

  • Proven strong analytical skills that demonstrate experience troubleshooting, assessing impact, quantifying problems and providing effective resolutions. Must cite examples of sound decision-making when dealing with multiple alternatives or solutions.

Work Setting
  • This position works primarily in an office setting and requires being in a stationary position for long periods of time frequently while working at a desk, on a computer or with other standard office equipment, or while in meetings. Position requires frequent movement of wrists, hands and fingers for continuous computer work.

Education Requirement

Bachelor's degree or commensurate selection criteria experience

Computer skills and knowledge of hardware and software required
  • Moderate SQL (Oracle, SQL Server) and relational database knowledge required.

  • Beginner BI/reporting tool knowledge required (Tableau, Cognos, Crystal Reports, etc.)

  • Exposure to CRM tools such as SalesPage, Salesforce, etc.

  • Proficient in word processing, spreadsheet, database and report development applications.

  • Exposure to basic ETL and Dimensional Data Modeling concepts.

  • Experience in the financial services industry is preferred.

Certifications and Licenses
  • Tableau, Cognos or CRM certifications preferred but not required.

Position Demands
  • Extended hours required during peak workloads or special projects.

Company Details

Cincinnati, Ohio, United States
Western & Southern Financial Group, a Fortune 500 Company, has over a 130-year heritage of meeting the financial stability needs of our customers — individuals, families, businesses, foundations and nonprofits — with a wide range of insurance, investment and retirement solutions through an ever-growing distribution system.Our family of companies continues to grow and diversify, fortifying our...