BI Developer

BI Developer – USI Insurance Services

Join to apply for the BI Developer role at USI Insurance Services
.

The Business Intelligence Developer is responsible for creating Power BI reports for multiple lines of business. This role involves engaging with stakeholders to gather requirements, synthesizing and transforming datasets, building insightful reports, conducting ad‑hoc analyses, and prioritizing projects based on business impact. The developer will leverage a range of technologies to continually improve the accuracy, accessibility, and efficiency of data and reporting processes, while also performing exploratory data analysis to generate actionable insights.

• Design and develop interactive Power BI reports and dashboards using DAX expressions, tailored to internal business needs.
• Extract, cleanse, and transform data from various internal and external sources. Conduct data profiling to identify anomalies and ensure data integrity.
• Work primarily with Microsoft technologies including Power BI, Power Query, SQL, SSAS, DAX, and Snowflake. Demonstrate proficiency in understanding diverse data structures and transformation techniques.
• Collaborate with business leaders to define requirements and communicate project progress clearly. Deliver insights through effective data visualizations.
• Manage project meetings, set expectations, and resolve issues with limited direction. Collaborate with other analysts to drive timely project completion.
• Contribute to the design and evolution of the Data and Reporting Architecture, focusing on improving the report development and user experience.
• Mentor fellow team members on BI best practices and coding standards.
• Provide peer reviews and constructive feedback on objects created by team members.
• Participate in the development, deployment, and maintenance of data models.
• Establish policies and procedures for data collection and analysis.
• Create or discover new data procurement and processing programs.
• Monitor analytics and metrics results.

• 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.

• 2+ years of practical experience with Power BI, DAX, SQL, and data analytics.
• 2+ years of experience in tabular data modeling.
• Bachelor’s degree in computer science, statistics, or related field preferred.
• Strong communication skills with the ability to document requirements.
• Familiarity with insurance brokerage or sales workflows and systems is a plus.
• Ability to manage multiple high-priority projects in a fast‑paced environment.
• Experience with Agile/Scrum project methodology a plus.
• Proven success in managing expectations and outcomes with business leaders.

Onsite in Valhalla, NY 2–3 days per week.

Salary Range: $100,000–$120,000. Bonus eligible with a target incentive of 8%.

With approximately $3 billion in revenue and over 10,500 associates across approximately 200 offices nationwide, USI is one of the largest insurance brokerage and consulting firms in the world. We invest heavily in our associates and take pride in celebrating their growth and success through our unique employee reward and recognition programs. USI offers a full suite of health, welfare, and financial benefits, including medical, wellness, dental, and vision, 401(k), flexible spending accounts, and generous paid time off.

We are committed to diversity, inclusion, and community engagement, and our programs are designed to help associates lead healthy, productive lives.