Power BI Report Specialist

Lensa is the leading career site for job seekers at every stage of their career. Our client, GovCIO, is seeking professionals in Columbus, OH. Apply via Lensa today!

Overview

GovCIO is currentlyseekinga highly skilledPower BIReportSpecialist/ SMEwith deep experience in modernizing reporting platforms, including converting legacyATC reportsintoPower BI, managingPower BI Gateways, and working withAzure Data FactoryandSQL Servertechnologies. The ideal candidate will bridge the gap between data engineering and business reporting, delivering enterprise-grade dashboards and reports supported by a scalable, secure, and automated backend infrastructure.This position is fully remote,locatedin the United States.

Responsibilities

• Lead the conversion of internal, dynamic Power Bi dashboards for exposure to external audiences,ensuring security, accuracy, interactivity, and user-friendly layouts.
• Develop andmaintaindata modelsandvisualizationsaligned with business logic, KPIs, and performance standards.
• Configure and administerPower BI Gateways(on-premises and enterprise) to support scheduled data refreshes from SQL Server and other sources.
• Collaborate with data engineers to design and manageAzure Data Factory pipelinesandSelf-Hosted Integration Runtimes (SHIR)to automate data ingestion and transformation workflows.
• Work directly withSQL Serverdatabases to write,optimize, and troubleshoot queries, stored procedures, and views that feed Power BI datasets.
• Generates Ad-Hoc PBI Reports.
• Conducts PBI Training (Instructor-led Class Development, Delivery).
• Ensure governance of data access and security policies, includingRow-Level Security (RLS)and workspace permission models.
• Partner with stakeholders to gather requirements, define data strategies, and deliver meaningful reporting solutions that drive decision-making.
• Makerecommendations for changes to software and hardware configurations that improve performance and capabilities provided bythe currentNational Surveillance Tool (NST Reporting). 
• Ensures smoothoperationsofNSTReportingthrough continuous monitoring and patching.
• Assistwith performance tuning and report optimization to improve loading speed, usability, and scalability.
• Provide guidance and support to teams adopting Power BI, ensuring best practices in report design, modeling, and deployment.
• Performs upgrades as needed to incorporate new features and assureelevated levelsof security and support.
  
  

Qualifications

Required Skills and Experience

• Bachelorswith 12 years (orcommensurateexperience)
• Proven experience designing and convertinglegacy or proprietary reports(e.g., ATC, SSRS) intoPower BI.
• Strong knowledge ofPower BI architecture, including Gateway configuration, DAX, Power Query (M), and publishing workflows.
• ProficiencyinAzure Data Factory, especially pipeline creation, scheduling, and integration with SQL and cloud storage.
• Experience withSQL Server Services, including SQL Agent Jobs, Integration Services (SSIS), and relational database tuning.
• Familiarity withSelf-Hosted Integration Runtime (SHIR)setup and maintenance for hybrid data environments.
  
  

Preferred Skills And Experience

• Solid understanding ofdata security, access controls, and compliance standards in cloud and on-prem environments.
• Ability to communicate technical concepts to non-technical stakeholders and produce high-quality documentation.
  
  

Clearance required

• Ability to obtain andmaintaina suitability/Public Trust clearance
  
  

#TAPS

Company Overview

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.

But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.

Posted Pay Range

The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an “at-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.

Posted Salary Range

USD $150,000.00 - USD $170,000.00 /Yr.

Submit a referral to this job (https://careers-govcio.icims.com/jobs/6139/power-bi-report-specialist/job?mode=apply&apply=yes&in_iframe=1&hashed=-1834385473)

Location US-Remote

ID 2025-6139

Category Information Technology

Position Type Full-Time