Business Intelligence Analyst II

Alliant Insurance Services•Omaha, NE

About The Position

Responsible for ensuring data visibility and insights across SMS platforms, Salesforce and connected systems. This role is responsible for gathering, interpreting, analyzing, and generating reports from native reporting and dashboards to advanced analytics through Tableau and CRM Analytics (CRMA). The analyst acts as both strategist and practitioner, this role defines standards for data visibility, partners with business stakeholders to align on requirements, and builds scalable solutions that drive adoption and value.

Requirements

Bachelor's Degree or equivalent combination of education and experience
Two (2) or more years in requirements gathering, data analysis, design and coding of database processes
Insurance Industry experience
Demonstrated understanding of system integrations and database structures
Proficient in BI Tools (SQL, SSIS, SSRS, SSAS, Salesforce CRMA, Tableau, Power BI)
Proficient in Microsoft Office suite applications
Strong written and verbal communication skills
Strong presentation and interpersonal skills
Sharp analytical and problem-solving skills
Strong ability to manage multiple projects simultaneously and adapt to rapidly changing priorities

Responsibilities

Performs data analysis, table designs, developing, and reporting solutions utilizing BI tools (CRMA, Tableau, Power BI).
Reviews, understands and documents the current operational processes and data sources to establish support for current and future reporting requirements.
Design and develop dashboards and reports using Snowflake and other enterprise data sources
Determines solutions to business questions through hands-on exploration of data sets via SQL for dashboards, statistical analysis and data visualizations.
Analyzes data in source systems to assess data quality and makes recommendations for addressing within the source systems or as part of the analytics process.
Works with team to establish the data management framework that improves the data quality and standards for both database structures and the warehouse repository.
Assists with the development of the data models for the data warehouse, and provides recommendations for all data strategies and out of scope processes.
Performs analysis and design mapping data between source systems and Alliant Analytics.
Works with business users to understand and translate user stories/requirements into data structures, models and reports.
Reviews and explores source data as it relates to business concepts as well as how it relates to other data elements.
Develops reports and other appropriate data access objects for end user reporting depending on business and business operation needs.
Monitors the analytics platform to ensure that scheduled jobs are successfully ran and analytics data aligns to timeliness and completeness of requirements.
Designs and deliver end-user training and training materials; provides technical support as necessary.
Troubleshoots BI tools, systems, and software; performance-tune these applications as necessary.
Other duties as assigned.