Power BI with strong SQL

Job Title: Power BI Consultant

Location: Washington, DC ( 4 days from Office )

Job Type: Contract

Experience Required: Minimum 10 Years

We're seeking a hands-on Contract Data Engineer to join GTS's GPE segment, focused on architecting and scaling our Power BI environment and supporting our broader data-warehouse ecosystem. The ideal candidate will have deep expertise in Power BI and Microsoft SQL Server, with additional exposure to Snowflake and data-warehouse design. You'll partner with business stakeholders and product management to translate needs into robust, maintainable dashboards, reports, and data pipelines."

•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