Business Intelligence Analyst/ Data Analyst (Onsite Role Must be local to DC)

Job Title: Business Intelligence Analyst Power BI

Location: Washington DC

Duration: 6 + Months contract to full time hire

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

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