BI Developer POST NUMBER: 307829
Vaco is seeking a highly skilled Business Intelligence (BI) Developer to design, develop, and deliver enterprise-grade reporting, dashboards, and analytical solutions. This role leverages Power BI and IBM Cognos Analytics to provide actionable insights across Claims, Underwriting, Agency, Finance, and Operations.
The ideal candidate brings a strong combination of insurance domain expertise, technical BI proficiency, and the ability to translate complex business requirements into scalable, governed data and visualization solutions.
Key Responsibilities:
Data & Guidewire Integration
· Design and develop reporting solutions leveraging data from Policy, Claims, Billing, Agency Management systems, and third-party data sources party data sources
· Build reusable semantic and data models to support enterprise analytics
· Collaborate closely with business stakeholders and Data Engineering teams on ETL/ELT processes and curated data layer integration
BI & Visualization Development
Develop interactive dashboards and reports using:
Power BI
IBM Cognos Analytics
· Build executive level dashboards (Senior Leadership Team ready views, SLTready views)
· Develop operational dashboards across the enterprise
· Implement row level security (RLS) and role based accesslevel security (RLS) and role based access
Translate business KPIs into structured, reusable data models
Partner with Claims, Underwriting, and Finance stakeholders to refine and standardize metrics
Design and deliver cloudbased BI solutions on Azure, leveraging Azure Data Lake, Azure SQL, and Power BI to enable scalable, secure analytics.
· Build and optimize semantic models and dashboards using Power BI, integrating data from Azure platforms with strong performance, governance, and cost efficiency.
Data Modeling & Architecture
· Design and implement star schemas for reporting and analytics
· Develop advanced DAX calculations and measures in Power BI
· Optimize report performance through query tuning and aggregation strategies
· Ensure data lineage, governance, and metric consistency
· Support Medallion architecture (Raw → Silver → Gold)
· Leverage Copilot and other LLM tools to enable self service analytics and reportingservice analytics and reporting
Governance & Quality
· Perform data validation and reconciliation against source systems
· Implement and support data quality checks
· Support audit and regulatory reporting requirements
· Document data definitions, transformations, and business logic
Required Qualifications:
Technical Skills:
· 5 years of experience in BI / Data Analytics development
· 3 years working with insurance products
· Strong hands on experience with: on experience with:
· Power BI (DAX, Power Query, data modeling)
· IBM Cognos Analytics
· Strong SQL skills (complex joins, window functions, performance tuning)
· Experience with Azure, Data Lake, and SQL Server preferred
· Experience working with large insurance datasets
Insurance Domain Knowledge:
· Strong understanding of:
o P&C insurance operations
o Claims lifecycle and reserving concepts
o Underwriting workflows
o Agency hierarchy
o Premium and billing structures
· Ability to interpret insurance KPIs and regulatory metrics
Preferred Qualifications:
· Experience with Guidewire DataHub / InfoCenter
· Experience with ETL tools such as ADF, SSIS, Informatica, or similar
· Experience supporting AMS or modernization programs
· Familiarity with Data Governance and MDM concepts
· Experience supporting Digital / Transformation initiatives
EEO Notice
Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.
Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact HR@vaco.com.
Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.
Representation Notice
By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.
For residents of Ontario, Canada: Based on Highspring’s discussions with its Client, Highspring’s understanding is that this position for employment is a current vacancy (either through Highspring as a contractor or with the client directly).
Privacy Notice
Vaco by Highspring and its parents, affiliates, and subsidiaries (“we,” “our,” or “Vaco by Highspring”) respects your privacy and are committed to providing transparent notice of our policies.
- California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here.
- Virginia residents may access our state specific policies here.
- Residents of all other states may access our policies here.
- Canadian residents may access our policies in English here and in French here.
- Residents of countries governed by GDPR may access our policies here.
Additionally, submissions to this position are subject to the use of AI to perform preliminary candidate screenings, focused on ensuring minimum job requirements noted in the position are satisfied. More details about Vaco by Highspring’s use of AI can be found here (https://www.highspring.com/ai-use-notices/). Further assessment of candidates beyond this initial phase will be conducted by recruiters and hiring managers. Vaco by Highspring does not know and cannot opine on if its client’s use of AI products in hiring.
Pay Transparency Notice
Determining compensation for this role (and others) at Vaco by Highspring depends upon a wide array of factors including but not limited to:
- the individual’s skill sets, experience and training;
- licensure and certification requirements;
- office location and other geographic considerations;
- other business and organizational needs.
With that said, as required by local law, Vaco by Highspring believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.