Business Intelligence Analyst – Power BI

System One; Washington (District of Columbia); On-site; USD 63,000 - 76,000; Full time

Job summary

System One is seeking a Business Intelligence Analyst for Washington, DC to design and maintain Power BI dashboards and reports. The role is contract-based with onsite work and a 40-hour week, requiring strong BI skills and a proven data-driven mindset.

You will build robust data models, perform in-depth analyses, collaborate with stakeholders to define KPIs, and ensure governance and security compliance across Power BI environments. Experience with DAX, Power Query, and SQL is essential.

Qualifications

• 5+ years’ experience in BI, data analytics, or data engineering.
• Proficiency in Power BI Desktop and Power BI service, including tenant administration, RLS, and workspace management.
• Strong data modeling, Power Query, ETL, and advanced DAX.
• Experience troubleshooting performance, refresh, queries, and usability in Power BI.
• Strong SQL querying and data validation skills.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports for business users and executives.
• Develop data models with Power Query and DAX, including relationships and measures.
• Analyze data to identify trends and opportunities.
• Translate findings into actionable recommendations for stakeholders.
• Collaborate with teams to define KPIs and BI requirements.
• Manage Power BI Service environments, workspaces, apps, and RLS.
• Connect data from SQL, Excel, Azure, APIs for unified reporting.
• Optimize report performance and data refresh schedules.

Skills

Power BI

SQL

Data modeling

DAX

ETL

Performance optimization

Governance

Communication

Problem solving

Analytical thinking

Education

Bachelor’s degree in Computer Science, Data Analytics, Information Systems or related field

Tools

Power BI Desktop

Power BI service

Tenant administration

Job description

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