BI Developer

Vaco by Highspring; Cincinnati (OH); On-site; USD 90,000 - 130,000; Full time

Job summary

Vaco is seeking a BI Developer to design, build, and deliver enterprise reporting and dashboards using Power BI and IBM Cognos Analytics. You will work across Claims, Underwriting, Agency, Finance, and Operations to translate complex business requirements into scalable data models.

The role requires strong BI development experience, SQL, and data governance with cloud-based implementation on Azure data services for enterprise analytics.

Qualifications

• 5+ years of BI / Data Analytics development experience.
• Experience with insurance data or domains is a plus.
• Ability to translate complex business requirements into scalable data models.

Responsibilities

• Design and develop enterprise reporting, dashboards, and analytics.
• Build semantic data models and implement RLS and role-based security.
• Collaborate with stakeholders on ETL/ELT processes and data integration.
• Develop Power BI and IBM Cognos analytics solutions across multiple business areas.
• Design cloud-based BI solutions on Azure with data lake and SQL.

Skills

BI/Analytics development

SQL skills

DAX calculations

Data governance

Tools

Power BI

IBM Cognos Analytics

Azure Data Lake

Azure SQL

SQL Server

ADF

SSIS

Informatica

Job description

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

Equal Opportunity Notice

Highspring LLC (d/b/a Vaco by Highspring) and its parents, affiliates, and subsidiaries ("we," "our," or "Vaco by Highspring") are committed to the full inclusion of all qualified individuals 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 applicable law. The company is also committed to ensuring that persons who need them are provided with reasonable accommodations; if an accommodation is needed to participate in the job application or interview process, please contact [e-mail] .

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. Additionally, you agree to be included in our talent pool for future hiring for similarly qualified positions. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. Lastly, you 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 only: to the extent the position for employment is not with Highspring or not otherwise noted as vacant above, candidate should be informed that this role is to replace a presently employed person at Vaco by Highspring's client.

Privacy Notice

Vaco by Highspring respects your privacy and are committed to providing transparent notice of our policies.

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; and

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 and/or participation in medical, dental, and vision benefits as well as the company's retirement plan (or similar retirement benefits).