Power BI Consultant || Washington, DC ( 4 days from Office )

Key Responsibilities:

Power BI Environment Management

Lead Power BI App workspace and gateway setup, configuration, and administration

Implement and manage Deployment Pipelines and version control (Git/GitHub) for Power BI artifacts

Reporting & Dashboard Development

Design, develop, and optimize complex interactive dashboards and paginated reports (Power BI Report Builder)

Embed advanced analytics, custom visuals, and performance-tuned DAX/MDX queries

SQL Server & ETL Development

Build and maintain stored procedures, functions, views, and ETL packages (SSIS)

Collaborate on data-warehouse modeling, data-loading processes, and lineage tracking

Snowflake & Modern DW (nice-to-have)

Support queries, integration, and performance tuning in a Snowflake environment

Stakeholder Engagement

Gather requirements, conduct design reviews, and provide technical guidance to non-technical users

Translate business questions into scalable technical solutions

Required Qualifications:

·                     4+ years of professional experience in Power BI report development and administration

·                     Strong Microsoft SQL Server skills: T-SQL, stored procedures, ETL, and data-warehouse design

·                     Bachelor’s degree in STEM or related field (highly preferred)

·                     Proven track record working in collaborative, fast-paced environments

·                     Experience with SQL Server Manage Studio (SSMS), SQL Server Analysis Studio (SSAS) and SQL Server Integration Services (SSIS)

Preferred Skills & Nice-to-Haves:

·                     Experience with Power BI Report Builder (paginated reports)

·                     Familiarity with Power BI Deployment Pipelines and Git-based version control

·                     Hands-on with Snowflake data warehouse—schema design, query tuning, and data ingestion

·                     Strong communication skills; able to lead requirements workshops and present to stakeholders

·                     Self-motivated, quick learner with a proactive “take initiative” mindset