Job description

Job Title: Power BI Consultant Location: Washington, DC ( 4 days from Office ) Duration: 12+ Months 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

Requirements