Business Intelligence Developer

INVID; San Juan (PR); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Paid time off

Health insurance

Retirement plan

Hybrid work model

Flexible working hours

Continuing education reimbursement

Company-paid life insurance

Job summary

INVID in San Juan, Puerto Rico is seeking a talented BI Developer to design scalable, self-service reporting solutions using Power BI. You will translate business requirements into dashboards and reports that deliver reliable, business-aligned insights while reducing ad hoc requests.

The role emphasizes data modeling, performance optimization, and collaboration with QA and data engineers in a hybrid work environment that combines office and remote work, with bilingual English/Spanish

Qualifications

• 5-7 years of experience in Power BI development, business intelligence, or related roles.
• Advanced experience with Power BI, including semantic models, complex DAX calculations, and enterprise-level report development.
• Strong expertise in data modeling, including star schema design, relationships, performance optimization, and aggregations.
• Proven ability to translate complex business requirements into scalable, standardized reporting solutions.
• Experience designing reusable datasets and semantic layers to support self-service BI.
• Strong experience with report performance tuning, refresh optimization, and usability best practices.
• Ability to work independently and manage end-to-end report development lifecycle, including stakeholder communication and UAT support.

Responsibilities

• Design and build Power BI semantic models, including tables, relationships, measures, and DAX calculations
• Develop interactive dashboards and reports aligned to standardized business reporting requirements
• Ensure reporting outputs are consistent, reusable, and scalable, minimizing ad hoc report development
• Optimize report performance, data refresh strategies, and overall usability
• Collaborate with QA teams and business stakeholders to support validation and UAT processes
• Enable self-service reporting through well-designed, governed datasets and semantic models
• Partner with data engineering teams to ensure alignment between reporting and upstream data structures

Skills

Power BI development

Data modeling

DAX calculations

Star schema

UAT support

Self-service BI

Reporting optimization

Job description

Job Summary

We are seeking a talented BI Developer to support the delivery of standardized, scalable, and self-service reporting solutions as part of our data transformation initiatives. This role is focused on designing high-quality reporting outputs that enable consistent, reliable, and business-aligned insights while reducing one-off reporting requests.

The ideal candidate has strong experience in Power BI development, data modeling, and performance optimization, along with the ability to translate business requirements into effective, user-friendly dashboards and reports.

What sets INVID apart is our collaborative and flexible work environment. We encourage our team to raise the bar in everything they do while maintaining a healthy work-life balance. With our hybrid work model, team members thrive both in the office and remotely. We foster a culture of mutual respect, autonomy, and accountability, where your voice matters and your growth is supported. From structured career paths and paid professional development to access to industry events, we’re committed to your success.

Duties and Responsibilities

• Design and build Power BI semantic models, including tables, relationships, measures, and DAX calculations
• Develop interactive dashboards and reports aligned to standardized business reporting requirements
• Ensure reporting outputs are consistent, reusable, and scalable, minimizing ad hoc report development
• Optimize report performance, data refresh strategies, and overall usability
• Collaborate with QA teams and business stakeholders to support validation and UAT processes
• Enable self-service reporting through well-designed, governed datasets and semantic models
• Partner with data engineering teams to ensure alignment between reporting and upstream data structures

Teamwork and Communication

Work under Agile methodologies and frameworks such as Scrum or Kanban. Provide daily status and feedback on the work performed. Assist in the analysis, design, development, and deployment of necessary data. Provide accurate explanations of any written code. Communicate with internal and external personnel in English or Spanish to discuss requirements and specifications, provide status updates, and explain the work performed.

Required Qualifications

• 5-7 years of experience in Power BI development, business intelligence, or related roles
• Advanced experience with Power BI, including semantic models, complex DAX calculations, and enterprise-level report development
• Strong expertise in data modeling, including star schema design, relationships, performance optimization, and aggregations
• Proven ability to translate complex business requirements into scalable, standardized reporting solutions
• Experience designing reusable datasets and semantic layers to support self-service BI
• Strong experience with report performance tuning, refresh optimization, and usability best practices
• Ability to work independently and manage end-to-end report development lifecycle, including stakeholder communication and UAT support

Preferred Qualifications

• Working knowledge of upstream data processes (e.g., Python, ETL/ELT concepts) to effectively collaborate with data engineers
• Experience in standardizing reporting frameworks across teams or departments
• Familiarity with data governance, certification of datasets, and BI best practices
• Strong stakeholder management skills with the ability to influence reporting strategy and design decisions

Other requirements:

Ability to obtain security clearance (if required)

US Resident | US Citizenship

Fully Bilingual (Spanish and English)

Work Modality: Hybrid

Location: San Juan, Puerto Rico

Benefits and Perks

We believe in supporting our employees’ well-being, growth, and work-life balance. As part of our team, you will have access to a comprehensive benefits package that includes:

• Paid time off, including vacation and sick leave
• Company-sponsored health insurance coverage
• Retirement plan to help you plan for the future
• Hybrid work model offering flexibility between office and remote work
• Flexible working hours to support work-life balance
• Continuing education reimbursement to encourage professional development
• Company-paid life insurance

EEO