Power BI Report Specialist

Power Bi Report Specialist/ SME GovCIO is 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. Generates Ad-Hoc PBI Reports. Conducts PBI Training (Instructor-led Class Development, 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 that improve performance and capabilities provided by the current National Surveillance Tool (NST Reporting). Ensures smooth operations 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. Performs upgrades as needed to incorporate new features and assure elevated levels of security and support. Qualifications Required Skills and Experience: Bachelors 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 required: Ability to obtain and maintain a suitability/Public Trust clearance. 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? What You Can Expect Interview & Hiring Process: If you are selected to move forward through the process, here's what you can expect: During the Interview Process: Virtual video interview conducted via video with the hiring manager and/or team. Camera must be on. A valid photo ID must be presented during each interview. During the Hiring Process: Enhanced Biometrics ID verification screening. Background check, to include: Criminal history (past 7 years) Verification of your highest level of education. Verification of your employment history (past 7 years), based on information provided in your application. Employee Perks At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including: Employee Assistance Program (EAP) Corporate Discounts Learning & Development platform, to include certification preparation content Training, Education and Certification Assistance Referral Bonus Program Internal Mobility Program Pet Insurance Flexible Work Environment *Available to full-time employees Our employees' unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience. 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. Posted Salary Range: USD $150,000.00 - USD $175,000.00 /Yr. Location: US-Remote ID: 2025-7090 Category: Information Technology Position Type: Full-Time