Business Intelligence Analyst – Power BI

This role is responsible for transforming complex business data into actionable insights through the design, development, and maintenance of high-impact reports, dashboards, and analytical solutions. Manage Power BI Service environments, including workspaces, apps, data gateways, row-level security (RLS), and content publishing workflows.

Job Summary

We are seeking a talented Business Intelligence Analyst with strong expertise in Power BI to join our team in Washington, DC, a vibrant city rich in history and culture. This role is responsible for transforming complex business data into actionable insights through the design, development, and maintenance of high-impact reports, dashboards, and analytical solutions. The ideal candidate will combine strong analytical skills with deep technical proficiency in Power BI to support data-driven decision-making across the organization. You will work closely with business stakeholders, data engineers, and leadership to understand requirements, deliver compelling visualizations, and drive business performance through insightful analytics.

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

Qualifications

• Bachelor's degree in Computer Science, Data Analytics, Information Systems, or a related field.
• 5 years of 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.
• Must be a US Citizen.
• Ability to obtain Public Trust Clearance.

Schedule

Location: Washington, DC (5 days a week onsite)

Benefits PEAK's benefit offerings available for our associates include medical, dental, vision, Flexible Spending Account (FSA), Dependent Care Savings Account (DCA), and 401K plan.PEAK believes that taking care of our team is essential for success and we are proud to provide benefits that enhance both your well-being and your future. Additionally, our associates may be eligible for Paid Sick Leave as required by Federal, State, or local laws. Equal Opportunity Employer (EEO) PEAK Technical Staffing is committed to creating a diverse and inclusive environment and is proud to be an Equal Opportunity Employer. PEAK does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or veteran status, or any other characteristic protected by applicable law. All employment decisions are made based on qualifications, merit, and business need. We encourage all individuals to apply. Americans Disabilities Act (ADA) The physical and mental requirements described in this job description are representative of those that must be met by an employee to successfully perform the essential functions of the position. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.Must be able to perform the essential physical functions of the position, including sitting, standing, walking, stooping, kneeling, andlifting upto 25 pounds, with or without reasonable accommodation. Candidate Privacy To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to https://peaktechnical.com/privacy-policy/and https://peaktechnical.com/ca-residents-privacy-rights/ AI Recruiting Disclosure We use AI-assisted tools to help review applications and compare your experience to job requirements, but all hiring decisions are made by human recruiters. You may request a human-only process or opt out of automated communication at any time. Required notices and our latest bias audit are available on our website: www.peaktechnical.com/ai-disclosure.