Power BI Analyst II

Summary

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

Duties and Functions

Power BI Development

• 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.

Education and Experience

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.

Preferred Requirements

The ideal candidate

• 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

Knowledge/Skills/Abilities (KSA)

Knowledge

• Enterprise Business Intelligence architecture.
• Data warehouse design methodologies.
• Semantic model development.
• Reporting governance practices.
• Analytics and KPI frameworks.

Skills

• 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.

Supervisory Responsibilities

This position does not have supervisory responsibilities

Work Environment/Condition

Indoor office setting

Standard lighting and temperature-controlled environment

Remote and hybrid work options may be available

Physical Demands

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

Acknowledgement

Loyal Source does not discriminate in employment based on race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factors.

This job description is not an exclusive or exhaustive list of all job functions that an employee in this position may be asked to perform. All employees are required to perform the essential functions, physical demands and intended purpose of their role in a satisfactory manner.

I attest that I can perform the essential job functions as outlined in this job description with or without any reasonable accommodation(s). I understand if I want to inquire about or seek reasonable accommodations, I am required to contact Human Resources at HR@loyalsource.com.

I acknowledge that I have read and understand the essential job functions, work environment/conditions, exemption classification and physical demands set forth in the job description provided for my position.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation by contacting HR at HRmgt@loyalsource.com. If you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability, please select the accessibility menu to the (right or left) for more assistance.

You can also request reasonable accommodations by contacting a telecommunications relay service by dialing 711 for direct access and assistance (tty).

This contractor and subcontractor abides by the requirements of 41 CFR 60-300.5(a) and 41 CFR 60-741.5(a).

These regulations prohibit discrimination against qualified individuals on the basis of protected veteran status or disability, and require affirmative action by covered prime contractors.