USI Insurance Services · 1 month ago
Sr Reporting Analyst
United States
Full-time
Remote
Senior Level
$125K/yr - $130K/yr
5+ years expUSI Insurance Services is one of the largest insurance brokerage and consulting firms in the world, with a commitment to professional development and community engagement. The Sr Reporting Analyst will support new system initiatives, manage project activities, and serve as a liaison between business users and the IT team to enhance reporting and data analysis capabilities.
Property & Casualty InsuranceConsultingHuman ResourcesFinanceHealth InsuranceCommercial InsuranceEmployee BenefitsFinancial ServicesInsuranceRisk Management
Responsibilities
Research problems and plan solutions. Recommend software and system changes. Coordinate development to meet business requirements
Responsible for supporting data and reporting business needs in a structured environment using Microsoft’s BI stack tools (SQL Server Reporting Services / SSRS, SQL Server Integration Services / SSIS, SQL Server Analysis Services / SSAS)
Act as liaison between business users and the IT team. Develop business cases and financial models for systems enhancements and net new systems
Interact with customers and transform user requests into business requirements and technical specifications
Develop test plans and test cases. Manage system testing and coordinate User Acceptance Testing (UAT)
Define “as is” and “to be” workflows and review with line of business leaders
Performs comparative evaluation of internal duplicative systems and system alternatives. Present recommendations and findings to senior management
Subject matter expert (SME) in insurance and/or sales workflows and applications
Work with business leaders and IT to implement projects and systems changes
Manage system conversion activities including data mapping, data analysis, system configuration
Define and maintain systems analysis standards, deliverables, and processes
Develop and maintain project plans, issues logs and tasks in a system of record
Review project progress with project team including senior management
Manage accountability of tasks for project members
Write periodic project status reports for management
Interface with vendors to ensure vendor compliance to contractual agreements
Operate in accordance with USI Policies for the Information Security Program (PISP) and USI Standards for the Information Security Program (SISP)
Keep up to date with security updates and improvements. Implement improvements as appropriate
Protect systems against unauthorized access by appropriately defining access
Upgrade systems by implementing and maintaining security and technical controls
Qualification
Required
5-7 years of IT and/or systems experience
Expert level understanding of SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS and SSRS)
5+ years of SQL Server Integration Services experience
3+ years of database design and data modeling
3+ years of SQL Server Analysis Services experience
2+ years of SQL Server Reporting Services experience
Experience with insurance or sales applications and workflows a plus
Team orientation and hands-on approach
Able to manage multiple and rapidly changing, high visibility priorities and projects
Preferred
Experience with Agile or software development methodology a plus
Benefits
Competitive pay, incentives, and benefits
Summit Awards program, rewarding excellence
Employee programs that recognize outstanding achievement and help our associates lead healthy, productive lives
Award-winning wellness program
College scholarships for associates' children
Financial help in times of need
Medical, wellness, dental and vision
401(k)
Flexible spending and health savings accounts
Short and long-term disability
Life insurance and other unique employer-sponsored and voluntary programs
Generous paid time off policy
Paid family leave benefit
Paid holiday time
Bonus eligible position with a target incentive of 10%
Company
USI Insurance Services
USI Insurance Services is an insurance brokerage and consulting firm that delivers diversified insurance and financial services.
10001+ employees
H1B Sponsorship
USI Insurance Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
100%
Represents job field similar to this job
Engineering and Development
Trends of Total Sponsorships
*2025 (2)
2023 (3)
Funding
Current Stage
Late StageTotal Funding
$1BKey Investors
Kohlberg Kravis Roberts & Co.
2023-09-11Private Equity· $1B
2017-03-17Secondary Market
2017-03-17Acquired
Leadership Team
Dave Petno
Partner and Vice President, Employee Benefits Consultant
Micaela Keane
Vice President
Recent News
Providence Business News
2026-06-19
Company data provided by crunchbase