Business Intelligence Analyst – Power BI

Job Title: Business Intelligence Analyst – Power BI
Location: Washington, DC
Type: Contract
Compensation: $45.92 - $55.00 per hour
Work Model: Onsite – onsite
Hours: 40.0 hours per week
Security Clearance: Ability to obtain Public Trust Clearance

Responsibilities

• Design, build, and maintain interactive Power BI dashboards and reports that deliver clear, actionable insights to business users and executives.
• Develop robust data models using Power Query and DAX, including relationships, calculated columns, measures, and optimized star schemas.
• Perform in-depth data analysis to identify trends, patterns, and business opportunities.
• Translate findings into meaningful recommendations for stakeholders.
• Partner with business teams to gather requirements, define KPIs, and deliver tailored BI solutions.
• Manage Power BI Service environments, including workspaces, apps, data gateways, row-level security (RLS), and content publishing workflows.
• Connect and integrate data from multiple sources (SQL databases, Excel, Azure, APIs, etc.) into Power BI for unified reporting.
• Optimize report performance, DAX queries, and data refresh schedules to ensure fast and reliable user experiences.
• Implement automated reporting processes, alerts, and advanced analytics features such as AI visuals, forecasting, and decomposition trees.
• Create clear documentation for reports and data models.
• Provide training and support to end-users on Power BI usage and self-service analytics.
• Ensure data accuracy, consistency, and compliance with governance standards.
• Implement version control and change management for BI assets.
• Stay current with Power BI updates, new features, and industry best practices.
• Recommend and implement enhancements to the BI environment.

Requirements

• Bachelor’s degree in Computer Science, Data Analytics, Information Systems or related field
• 5+ years’ experience in Business Intelligence, Data Analytics, or Data Engineering roles
• Proficiency in Power BI Desktop and Power BI service, including tenant administration, RLS, and workspace management
• Strong expertise in data modeling, power query, ETL processes, and writing advanced optimized DAX formulas
• Experience troubleshooting performance, refresh, query, and usability in Power BI environments
• Strong command of SQL for querying databases, joining tables, and performing data validation
• Experience connecting Power BI to various data sources like SQL, Rest APIs, and Azure services
• Knowledge of modern BI development practices, including governance, documentation, testing, and deployment
• Excellent written and verbal communication skills, including the ability to clearly explain technical concepts to non-technical audiences

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.

Ref: #851-Rockville-S1