CI Business Intelligence Analyst
Apply NowCompany: USI Holdings Corporation
Location: Valhalla, NY 10595
Description:
General Description:
The Business Intelligence Analyst will meet with multiple business stakeholders to capture requirements, design and synthesize datasets, build reports, perform ad-hoc analysis and prioritize projects based on business value and need. You will leverage a variety of technologies to continually improve the accuracy, usage and efficiency of our data and reporting processes. You will perform exploratory data analysis and provide insights to stakeholders.
Responsibilities:
Develop reports and dashboards for internal business partners.
Perform data extraction, cleansing and wrangling on diverse data sets from internal and external sources. Perform data profiling to identify and understand anomalies.
Primarily use Microsoft tools and languages: Power BI, Power Query, SQL, SQL Server Analysis Services (SSAS), DAX. Able to understand various data structures and common methods in data transformation.
Communicate requirements and project progress to business leaders clearly and concisely. Provide insights through data visualizations.
Manage project meetings, set expectations and resolve obstacles and issues with limited direction. Collaborate with fellow analysts to move projects forward quickly.
Participate in the overall design of our Data and Reporting Architecture with focus on improving the overall report creation and usage experience for our internal business partners.
Mentor fellow team members on Business Intelligence techniques and code.
Provide constructive feedback (peer review) objects created by others on the team.
Participate in the development, deployment and maintenance of data models.
Develop policies and procedures for the collection and analysis of data
Create or discover new data procurement and processing programs
Monitor analytics and metrics results
Knowledge, Skills and Abilities:
Bachelor's Degree in Computer Science, Statistics, or related field a plus.
2+ years' practical experience with Power BI, DAX, SQL and data analytics.
Strong communication skills. Ability to document requirements.
Working knowledge of insurance brokerage or sales workflows and systems an asset.
Must be able to manage multiple and rapidly changing, high visibility priorities and projects.
Agile/Scrum project methodology experience a plus.
Proven ability to manage expectations and outcomes with business leaders.
Why USI?
With more than $2.7 billion in revenue and over 10,000 associates across approximately 200 offices nationwide, USI is one of the largest insurance brokerage and consulting firms in the world. At USI, we have created one of the most dynamic personal and professional development cultures in the industry. We invest heavily in our associates, and we take pride in celebrating their growth and success through our one-of-a-kind employee reward and recognition programs.
Unrivaled Resources and Support
What truly distinguishes USI as a premier insurance brokerage and consulting firm is the USI ONE Advantage, a game-changing value proposition that delivers to clients a robust set of risk management and benefit solutions with bottom-line financial impact. USI ONE represents Omni, Network, Enterprise-the three key elements that set USI apart from the competition. Through USI ONE, we develop strategic, timely, and effective risk management and benefit programs in terms that are easy to understand, and we demonstrate how the solutions can have a positive economic impact.
Industry-Leading Programs, Rewards, and Recognition
In addition to competitive pay, incentives, and benefits, USI recognizes associates through our Summit Awards program, rewarding excellence in those who build our brand each day. USI offers employee programs that recognize outstanding achievement and help our associates lead healthy, productive lives. We turn care into action with our award-winning wellness program, college scholarships for associates' children, and financial help in times of need.
Deep Community Engagement
We are committed to giving back to our local communities and supporting a culture of environmental sustainability. From sharing our time, talent, and resources to support local non-profit organizations, animal shelters, and environmental beautification and restoration projects - to partnering with eco-conscious vendors and taking steps to reduce our own environmental footprint - we're working together as ONE to build a better future.
Committed to a Diverse, Equitable, and Inclusive Workplace
Our award-winning I'm With U diversity, equity, and inclusion program educates our associates to help them better understand and serve our clients, prospects, fellow team members, and local communities through curated education and training resources, employee support programs, and community outreach initiatives to build a more diverse, equitable, and inclusive culture.
Nationally Recognized as a Top Insurance Employer
Visit our Awards and Accolades page for a complete list of our latest industry awards and recognitions!
USI is committed to providing a full-suite of competitive benefits for our growing population and its diverse needs. We offer a wide range of health, welfare and financial benefits including 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. USI also offers a generous paid time off policy, paid family leave benefit as well as paid holiday time.
Salary Range: $85,000- $100,000. This is a bonus eligible position with a target incentive of 8%.
Job ID:
29932
The Business Intelligence Analyst will meet with multiple business stakeholders to capture requirements, design and synthesize datasets, build reports, perform ad-hoc analysis and prioritize projects based on business value and need. You will leverage a variety of technologies to continually improve the accuracy, usage and efficiency of our data and reporting processes. You will perform exploratory data analysis and provide insights to stakeholders.
Responsibilities:
Develop reports and dashboards for internal business partners.
Perform data extraction, cleansing and wrangling on diverse data sets from internal and external sources. Perform data profiling to identify and understand anomalies.
Primarily use Microsoft tools and languages: Power BI, Power Query, SQL, SQL Server Analysis Services (SSAS), DAX. Able to understand various data structures and common methods in data transformation.
Communicate requirements and project progress to business leaders clearly and concisely. Provide insights through data visualizations.
Manage project meetings, set expectations and resolve obstacles and issues with limited direction. Collaborate with fellow analysts to move projects forward quickly.
Participate in the overall design of our Data and Reporting Architecture with focus on improving the overall report creation and usage experience for our internal business partners.
Mentor fellow team members on Business Intelligence techniques and code.
Provide constructive feedback (peer review) objects created by others on the team.
Participate in the development, deployment and maintenance of data models.
Develop policies and procedures for the collection and analysis of data
Create or discover new data procurement and processing programs
Monitor analytics and metrics results
Knowledge, Skills and Abilities:
Bachelor's Degree in Computer Science, Statistics, or related field a plus.
2+ years' practical experience with Power BI, DAX, SQL and data analytics.
Strong communication skills. Ability to document requirements.
Working knowledge of insurance brokerage or sales workflows and systems an asset.
Must be able to manage multiple and rapidly changing, high visibility priorities and projects.
Agile/Scrum project methodology experience a plus.
Proven ability to manage expectations and outcomes with business leaders.
Why USI?
With more than $2.7 billion in revenue and over 10,000 associates across approximately 200 offices nationwide, USI is one of the largest insurance brokerage and consulting firms in the world. At USI, we have created one of the most dynamic personal and professional development cultures in the industry. We invest heavily in our associates, and we take pride in celebrating their growth and success through our one-of-a-kind employee reward and recognition programs.
Unrivaled Resources and Support
What truly distinguishes USI as a premier insurance brokerage and consulting firm is the USI ONE Advantage, a game-changing value proposition that delivers to clients a robust set of risk management and benefit solutions with bottom-line financial impact. USI ONE represents Omni, Network, Enterprise-the three key elements that set USI apart from the competition. Through USI ONE, we develop strategic, timely, and effective risk management and benefit programs in terms that are easy to understand, and we demonstrate how the solutions can have a positive economic impact.
Industry-Leading Programs, Rewards, and Recognition
In addition to competitive pay, incentives, and benefits, USI recognizes associates through our Summit Awards program, rewarding excellence in those who build our brand each day. USI offers employee programs that recognize outstanding achievement and help our associates lead healthy, productive lives. We turn care into action with our award-winning wellness program, college scholarships for associates' children, and financial help in times of need.
Deep Community Engagement
We are committed to giving back to our local communities and supporting a culture of environmental sustainability. From sharing our time, talent, and resources to support local non-profit organizations, animal shelters, and environmental beautification and restoration projects - to partnering with eco-conscious vendors and taking steps to reduce our own environmental footprint - we're working together as ONE to build a better future.
Committed to a Diverse, Equitable, and Inclusive Workplace
Our award-winning I'm With U diversity, equity, and inclusion program educates our associates to help them better understand and serve our clients, prospects, fellow team members, and local communities through curated education and training resources, employee support programs, and community outreach initiatives to build a more diverse, equitable, and inclusive culture.
Nationally Recognized as a Top Insurance Employer
- Recognized as one of Insurance Business America's Top Insurance Employers for the seventh consecutive year (2018-2024).
- Named to Business Insurance's annual list of the Best Places to Work in Insurance five years in a row (2020-2024).
- Named to Fortune's 2024 Best Workplaces in Financial Services & Insurance list.
- Honored by Glassdoor as a Best-Led Company in the U.S. in 2024.
- Recognized by Newsweek as one of America's Greatest Workplaces for Diversity in 2024
Visit our Awards and Accolades page for a complete list of our latest industry awards and recognitions!
USI is committed to providing a full-suite of competitive benefits for our growing population and its diverse needs. We offer a wide range of health, welfare and financial benefits including 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. USI also offers a generous paid time off policy, paid family leave benefit as well as paid holiday time.
Salary Range: $85,000- $100,000. This is a bonus eligible position with a target incentive of 8%.
Job ID:
29932