> Markdown version of [/jobs/ext/1460082-power-bi-analyst-ii](https://www.wearedevelopers.com/jobs/ext/1460082-power-bi-analyst-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Power BI Analyst II - **Company:** Loyal Source LLC - **Location:** Orlando, FL, United States - **Experience:** Experienced - **Salary:** $95,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Business Analytics Applications, Data Analysis, Computing Platforms, Software Documentation, Information Systems, Computer Literacy, Data Validation, Data Governance, Data Infrastructure, Data Structures, Data Visualization, Data Warehousing, Database Development, Microsoft Software, Microsoft SQL Server, Performance Tuning, Powerpivot, Power BI, Salesforce.Com, SQL Stored Procedures, SQL Databases, Enterprise Data Management, Freeform SQL, Data Ingestion, Azure Data Factory, Sql Optimization, Powerquery, Microsoft Fabric, Information Technology, Data Analytics, Data Management, Workday Reporting, Software Version Control - **Published:** July 27, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=9a46228461c45919 ## About the Role Required * Bachelor's Degree in Information Systems, Computer Science, Data Analytics, Mathematics, Statistics, Business Intelligence, or related field. * Minimum 4 years of experience in Business Intelligence, Analytics, or Reporting. * Minimum 3 years of hands-on Power BI development experience. * Minimum 3 years of advanced SQL development experience. Preferred * Experience with Microsoft Fabric. * Experience supporting both Commercial and GCC environments. * Experience with Salesforce reporting and analytics. * Experience with Workday reporting and analytics. * Experience supporting enterprise data warehouses. * Experience with Azure Data Factory, Synapse Analytics, or Microsoft Fabric Data Factory. * Experience with source control and deployment processes. * Microsoft Power BI certification preferred., * Has built enterprise Power BI solutions supporting hundreds of users. * Understands how to build and maintain semantic models, not just reports. * Can read and write advanced SQL without relying on others. * Understands reporting architecture, data warehouse concepts, and governance. * Is comfortable working directly with executives and business leaders. * Can operate effectively in highly regulated and secure environments such as GCC. As well as knowledge of the following: Power BI * Advanced DAX * Power Query (M) * Data Modeling * Semantic Models * Report Optimization * Security and Row-Level Security * Dashboard Development * KPI Design SQL * Advanced SQL Query Development * Stored Procedures * Data Validation * Performance Tuning * Data Quality Analysis Microsoft Technologies * Microsoft Fabric * Power BI Service * Power BI Desktop * SQL Server * Azure Data Platform Technologies * Excel Power Pivot, * Enterprise Business Intelligence architecture. * Data warehouse design methodologies. * Semantic model development. * Reporting governance practices. * Analytics and KPI frameworks., * Complex problem solving. * Data visualization and storytelling. * Requirements gathering. * Report and dashboard design. * SQL development. * Power BI optimization. Abilities * Communicate technical concepts to business stakeholders. * Balance multiple priorities simultaneously. * Work independently with limited supervision. * Drive requirements from ambiguous business requests. * Build trusted relationships across business and IT teams., Ability to sit for extended periods Manual dexterity for computer use Visual acuity for screen-based work Must be able to perform job duties with or without reasonable accommodation ## Description The Power BI Analyst II is responsible for designing, developing, and supporting enterprise reporting, analytics, and data visualization solutions across Loyal Source Government Services' Microsoft Fabric, Power BI, and SQL Server environments. This role partners closely with business stakeholders, data engineers, and technology teams to transform data into actionable insights that support strategic, operational, and executive decision-making. The ideal candidate possesses advanced Power BI development skills, strong SQL expertise, experience with dimensional data modeling and semantic models, and a deep understanding of enterprise reporting best practices. This position will support both Commercial and GCC environments while ensuring analytics solutions meet security, governance, and performance requirements. Pay: $95,000/year, * Design, develop, publish, and maintain enterprise Power BI reports and dashboards. * Develop advanced DAX measures, calculated columns, KPIs, and analytical calculations. * Create reusable semantic models and certified datasets supporting multiple reporting use cases. * Optimize report performance and usability for executive, operational, and analytical audiences. * Implement row-level security (RLS) and data access controls where required. Data Modeling & Analytics * Design and maintain dimensional data models including fact and dimension structures. * Develop semantic models that support self-service reporting and enterprise analytics. * Partner with business teams to define KPIs, metrics, and reporting requirements. * Analyze complex business processes and translate business needs into scalable reporting solutions. * Ensure data consistency, accuracy, and alignment across reports and business domains. SQL & Data Warehouse Support * Develop complex SQL queries, stored procedures, and data validation processes. * Collaborate with Data Engineers on warehouse design, data ingestion, and transformation logic. * Support Microsoft Fabric Warehouse and Lakehouse data structures. * Validate source-to-target mappings and support data quality initiatives. * Assist in troubleshooting reporting and data-related issues across multiple source systems. Microsoft Fabric & Data Platform Support * Support analytics solutions within Microsoft Fabric environments. * Work with Data Factory Pipelines, Lakehouses, Warehouses, and Semantic Models. * Coordinate development and deployment activities across Commercial and GCC environments. * Participate in data governance and reporting standards initiatives. * Implement best practices related to performance, scalability, and maintainability. Business Partnership * Facilitate requirements gathering sessions with stakeholders. * Translate business requirements into technical reporting solutions. * Present analytical findings and recommendations to technical and non-technical audiences. * Develop user documentation and provide training to business users. * Support executive reporting and strategic initiatives. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)