Power BI Report Specialist

Lensa; Baton Rouge (LA); Remote; USD 150,000 - 170,000; Full time

Job summary

GovCIO seeks a Power BI Report Specialist to modernize reporting platforms and deliver enterprise-grade dashboards from Baton Rouge. This remote role involves collaborating with teams, optimizing data processes, and ensuring data governance. The ideal candidate has extensive experience in Power BI and SQL Server, focusing on data-driven insights and actionable reporting solutions.

Qualifications

• 12+ years of experience or equivalent.
• Experience in converting legacy reports into Power BI.
• Proficiency with SQL Server and Azure Data Factory.

Responsibilities

• Lead conversion of internal Power BI dashboards.
• Develop and maintain data models and visualizations.
• Administer Power BI Gateways for scheduled data refreshes.

Skills

Power BI architecture

DAX

Power Query

Azure Data Factory

SQL Server

Education

Bachelor's degree

Job description

Be among the first 25 applicants.

Get AI-powered advice on this job and more exclusive features.

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

Overview

GovCIO is currently seeking a highly skilled Power BI Report Specialist/SME with deep experience in modernizing reporting platforms, including converting legacy ATC reports into Power BI, managing Power BI Gateways, and working with Azure Data Factory and SQL Server technologies. 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, located in 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 and maintain data models and visualizations aligned with business logic, KPIs, and performance standards.
• Configure and administer Power BI Gateways (on-premises and enterprise) to support scheduled data refreshes from SQL Server and other sources.
• Collaborate with data engineers to design and manage Azure Data Factory pipelines and Self-Hosted Integration Runtimes (SHIR) to automate data ingestion and transformation workflows.
• Work directly with SQL Server databases to write, optimize, and troubleshoot queries, stored procedures, and views that feed Power BI datasets.
• Generate Ad-Hoc Power BI Reports.
• Conduct Power BI training, including instructor-led class development and delivery.
• Ensure governance of data access and security policies, including Row-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.
• Make recommendations for changes to software and hardware configurations to improve performance and capabilities of the current National Surveillance Tool (NST Reporting).
• Ensure smooth operation of NST Reporting through continuous monitoring and patching.
• Assist with 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.
• Perform upgrades as needed to incorporate new features and ensure elevated levels of security and support.

Qualifications

Required Skills and Experience

• Bachelor's degree with 12+ years (or commensurate experience)
• Proven experience designing and converting legacy or proprietary reports (e.g., ATC, SSRS) into Power BI.
• Strong knowledge of Power BI architecture, including Gateway configuration, DAX, Power Query (M), and publishing workflows.
• Proficiency in Azure Data Factory, especially pipeline creation, scheduling, and integration with SQL and cloud storage.
• Experience with SQL Server Services, including SQL Agent Jobs, Integration Services (SSIS), and relational database tuning.
• Familiarity with Self-Hosted Integration Runtime (SHIR) setup and maintenance for hybrid data environments.

Preferred Skills and Experience

• Solid understanding of data 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

• Ability to obtain and maintain a suitability/Public Trust clearance.

Company Overview

GovCIO is a team of transformers passionate about transforming government IT. We deliver innovative IT services and solutions that improve government operations and citizen services. We seek talented individuals to join us in this mission. We are an Equal Opportunity Employer. All qualified applicants will receive consideration regardless of race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or veteran status.

Pay Range

The posted pay range reflects the expected range at the start of employment; actual offers may vary based on factors like experience, skills, and location. Total compensation may include additional elements discussed during hiring. Employees are in an at-will employment position, and GovCIO reserves the right to modify compensation at any time.

Salary Range

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

Apply here: Apply for Power BI Report Specialist

Location: US-Remote

ID: 2025-6139

Category: Information Technology

Position Type: Full-Time

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Business Development and Sales

Industries

• IT Services and IT Consulting