Description and RequirementsThe Role: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.
What You'll Do:- 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.
Cyber Security Job Responsibilities:- 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.
What We're Looking For:- 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.
- Experience with Agile/Scrum project methodology a plus.
- Proven success in managing expectations and outcomes with business leaders.
Hybrid schedule: onsite in Valhalla, NY #LI-JM4
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: $100,000- $120,000. This is a bonus eligible position with a target incentive of 8%.
