Post Job Free
Sign in

Power BI Developer

Company:
RIT Solutions, Inc.
Location:
Dublin, OH, 43016
Posted:
November 07, 2025
Apply

Description:

Position Summary

We are seeking a Power BI Developer to design, build, and maintain dynamic, interactive dashboards and reports that deliver actionable insights from security and vulnerability management data. The ideal candidate will have strong experience pulling data directly into Power BI using APIs and SQL/PostgreSQL queries, combined with advanced skills in data modeling, DAX, and Power Query (M).

This role reports directly to the CISO and will collaborate with Information Security, IT, and executive leadership teams to enhance reporting visibility, automate analytics, and support data-driven decision-making across the enterprise.

Key Responsibilities

Design and develop Power BI dashboards and reports using data from multiple sources, including APIs and SQL/PostgreSQL queries.

Build and maintain data models, relationships, and DAX measures to support advanced analytics and reporting.

Develop and manage data pipelines that extract, transform, and load data from REST APIs and direct SQL connections.

Create role-based dashboards for IT, InfoSec, compliance, and executive stakeholders.

Define and visualize metrics such as vulnerability trends, remediation timelines, and asset risk scores.

Automate data refreshes, monitor performance, and ensure consistent accuracy.

Implement and enforce data governance and security standards within Power BI.

Document data models, integrations, and transformation logic for maintainability and scaling.

Required Qualifications

Bachelor's degree in Information Systems, Computer Science, Data Analytics, or equivalent experience.

3+ years of hands-on experience developing Power BI dashboards and reports with APIs and SQL/PostgreSQL integrations.

Strong proficiency in SQL, Power Query (M), and DAX for modeling and data transformation.

Proven ability to design scalable, high-performance Power BI solutions.

Excellent analytical, documentation, and communication skills.

Preferred Qualifications

Experience integrating and reporting on data from Rapid7 InsightVM / InsightIDR (preferred, not required).

Background in cybersecurity analytics, IT operations, or data engineering.

Familiarity with ETL pipelines, REST API integrations, or data warehousing concepts.

Certifications such as Microsoft PL-300 (Power BI Data Analyst) or Rapid7 Certified Administrator are a plus.

Success Indicators

Automated, accurate dashboards connecting directly to API and database data sources.

Clear, actionable insights supporting security operations, risk management, and compliance visibility.

Strong adoption and satisfaction among InfoSec, IT, and leadership stakeholders.

Apply