Power BI SME

Koniag IT Systems LLC a Koniag Government Services company is seeking a Power BI SME with a Secretclearance to support KITS and our government customer in Huntsville AL. This is an onsite offer competitive compensation and an extraordinary benefits package including health dental and vision insurance 401K with company matching flexible spending accounts paid holidays three weeks paid time off and IT Systems LLC a Koniag Government Services company is seeking an experienced Power BI Subject Matter Expert (SME) to lead the design development and implementation of advanced business intelligence and data visualization solutions. The ideal candidate will have deep technical expertise in Power BI and the broader Microsoft Power Platform ecosystem. This role requires the ability to transform complex data into actionable insights through compelling dashboards reports and analytics solutions that drive informed decision-making. The Power BI SME will serve as the technical authority on all Power BI initiatives ensuring solutions are scalable secure performant and aligned with organizational data strategy. The Power BI Subject Matter Expert will be responsible for the full development of Power BI solutions from requirements gathering through deployment and ongoing maintenance. This role combines technical excellence with strategic thinking to deliver data visualization and analytics solutions that meet complex business intelligence needs. The Power BI SME will work closely with stakeholders data engineers and business users to understand requirements design optimal data models and create intuitive impactful visualizations. The SME will also serve as a technical leader and mentor establishing best practices and promoting data-driven decision-making across the organization. Principal responsibilities will include but are not limited to:Lead the design development testing deployment and maintenance of Power BI dashboards reports and paginated reportsArchitect and implement complex data models using Power BI Desktop including star schemas snowflake schemas and optimized relationshipsDevelop advanced DAX (Data Analysis Expressions) calculations measures and calculated columns to support sophisticated analytical requirementsCreate interactive user-friendly visualizations that effectively communicate insights to diverse audiencesDesign and implement Power BI solutions that integrate seamlessly with other Microsoft Power Platform components including Power Apps and Power AutomateConnect Power BI to various data sources including Microsoft Dataverse SQL Server Azure SQL Database SharePoint Excel APIs and cloud-based data platformsImplement Row-Level Security (RLS) and Object-Level Security (OLS) to ensure appropriate data access controlsOptimize Power BI reports and dashboards for performance including query optimization and data model efficiency improvementsConfigure and manage Power BI Service workspaces including capacity management gateway configuration and refresh schedulesDevelop and implement data refresh strategies including incremental refresh and real-time data connectivityIntegrate Power BI solutions with Microsoft Azure services such as Azure Synapse Analytics Azure Data Lake Azure Functions and Azure Logic AppsCollaborate with data engineers and database administrators to ensure optimal data pipeline architectureImplement Power BI embedding scenarios for custom applications using Power BI Embedded or Power BI REST APIsCreate and maintain documentation including technical specifications data dictionaries and user guidesEstablish and enforce Power BI development standards best practices and governance policiesConduct code reviews and provide technical guidance to junior developersTroubleshoot and resolve technical issues related to Power BI reports data sources and gateway connectivityProvide training and support to end users on Power BI capabilities and self-service analyticsStay current with Power BI updates new features and industry best practicesSupport Application Lifecycle Management (ALM) practices for Power Platform solutions including version control and deployment pipelinesMonitor Power BI usage analytics and capacity metrics to ensure optimal system performanceParticipate in requirements gathering sessions and translate business needs into technical solutionsEnsure all Power BI solutions meet security compliance and regulatory requirementsEducation and Experience:Required:Bachelors degree in Computer Science Information Systems Data Analytics Business Intelligence or related field from an accredited college or universityEquivalent experience may be substituted in lieu of a degree5 years of hands-on experience developing Power BI solutions in enterprise environments3 years of experience with the broader Microsoft Power Platform including Power Apps Power Automate and Microsoft DataverseDemonstrated experience designing and implementing complex data models and DAX calculationsProven track record of delivering Power BI solutions that meet business intelligence requirements and drive organizational valueExperience with data integration ETL/ELT processes and working with diverse data sourcesPreferred:Microsoft Certified: Power BI Data Analyst AssociateMicrosoft Certified: Data Analyst AssociateMicrosoft Certified: Power Platform Developer AssociateMicrosoft Power Platform Functional Consultant AssociateAdvanced certifications in Azure data services (e.g. Azure Data Engineer Associate Azure Database Administrator Associate)Experience supporting government or DoD customersMasters degree in related fieldDesired Skills and Competencies:Experience with advanced Power BI features including aggregations composite models and calculation groupsKnowledge of Power BI REST API and embedding scenariosExperience with Power BI Report Server (on-premises deployment)Familiarity with R or Python integration within Power BI for advanced analyticsExperience with Azure DevOps for Power Platform ALMKnowledge of Tabular Object Model (TOM) and Analysis ServicesExperience with paginated reports (SSRS-style reports) in Power BIUnderstanding of data warehousing concepts and dimensional modeling techniquesFamiliarity with other BI and visualization tools (Tableau Qlik etc.) for comparative analysisExperience with real-time streaming data and DirectQuery optimizationKnowledge of mobile BI design patterns and responsive report layoutsExperience implementing Power BI solutions in multi-tenant environmentsUnderstanding of Microsoft Information Protection and data loss prevention in Power BIExperience with Power BI Premium per User (PPU) and Premium capacity managementFamiliarity with Microsoft Fabric and its integration with Power BIKnowledge of Agile/Scrum development methodologiesExperience conducting Power BI training and workshops for end usersActive participation in Power BI community and contributions to forums or blogsExperience with government data standards and compliance requirements (FedRAMP FISMA etc.)Clearance Requirement: Secret Security ClearanceOur Equal Employment Opportunity PolicyThe company is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race color religion creed ethnicity sex sexual orientation gender or gender identity (except where gender is a bona fide occupational qualification) national origin or ancestry age disability citizenship military/veteran status marital status genetic information or any other characteristic protected by applicable federal state or local law. We are committed to equal employment opportunity in all decisions related to employment promotion wages benefits and all other privileges terms and conditions of company is dedicated to seeking all qualified applicants. If you require an accommodation to navigate or apply for a position on our website please get in touch with Heaven Wood via e-mail by calling to request Government Services (KGS) is an Alaska Native Owned corporation supporting the values and traditions of our native communities through an agile employee and corporate culture that delivers Enterprise Solutions Professional Services and Operational Management to Federal Government Agencies. As a wholly owned subsidiary of Koniag we apply our proven commercial solutions to a deep knowledge of Defense and Civilian missions to provide forward leaning technical professional and operational solutions. KGS enables successful mission outcomes for our customers through solution-oriented business partnerships and a commitment to exceptional service delivery. We ensure long-term success with a continuous improvement approach while balancing the collective interests of our customers employees and native communities. For more information please Opportunity Employer/Veterans/ Preference in accordance with Public Law 88-352