Power BI Developer

Power BI Developer

6-  9 Months Contract – possible extension

Location:   Onsite Vienna, VA / Open for 100% remote job

 Job description:
Required Experience: 5+ years (adjustable based on project requirements)
Technical Skills: Power BI, MicroStrategy, SQL Server

Hands-on experience in Wealth Management / Investment Management / Asset Management / Banking, or the Financial Services industry is required.

Job Summary

• We are looking for an experienced Power BI Developer with hands-on experience migrating reports and dashboards from MicroStrategy to Power BI.
• The ideal candidate should have strong expertise in Power BI development, SQL Server, data modeling, and report optimization, along with the ability to analyze existing MicroStrategy reports and rebuild them in Power BI.

 Key Responsibilities

• Migrate existing reports, dashboards, and business intelligence solutions from MicroStrategy to Power BI.
• Analyze MicroStrategy reports, datasets, metrics, filters, prompts, and business logic to ensure accurate migration.
• Design, develop, and maintain interactive Power BI dashboards and reports based on business requirements.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, and views using SQL Server.
• Develop efficient data models, relationships, calculated columns, and measures using DAX.
• Connect Power BI to SQL Server and other relevant data sources, ensuring data accuracy and consistency.
• Validate migrated reports by comparing results, calculations, and visualizations between MicroStrategy and Power BI.
• Optimize report performance, data refresh processes, and dashboard responsiveness.
• Work closely with business stakeholders, data teams, and other technical teams to understand reporting requirements.
• Document migration activities, report mappings, data definitions, and technical specifications.
• Troubleshoot data discrepancies and resolve issues during migration, testing, and deployment.

Required Skills and Qualifications

• Strong hands-on experience developing reports and dashboards using Microsoft Power BI.
• Practical experience migrating reports and dashboards from MicroStrategy to Power BI.
• Strong SQL Server skills, including complex queries, joins, aggregations, views, and stored procedures.
• Proficiency in DAX, Power Query (M), and Power BI data modeling.
• Experience with report reconciliation, data validation, and performance optimization.
• Understanding of ETL processes, data warehousing, and business intelligence concepts.
• Experience working with business users to gather requirements and translate them into reporting solutions.
• Strong analytical, troubleshooting, and communication skills.

 Preferred Qualifications

• Experience with Power BI Service, workspaces, gateways, scheduled refreshes, and deployment.
• Knowledge of row-level security (RLS) and report access management.
• Experience with large datasets and complex enterprise reporting environments.
• Familiarity with MicroStrategy architecture, semantic layers, metrics, and reporting components.
• Experience supporting UAT, production deployments, and post-migration issue resolution.

 Expected Deliverables

• Successfully migrated MicroStrategy reports and dashboards in Power BI.
• Validated reports with accurate calculations and consistent business results.
• Optimized Power BI dashboards and SQL queries.
• Migration documentation and reconciliation results.

 Ideal Candidate

• The ideal candidate is not just a Power BI report developer but someone who understands existing MicroStrategy reporting solutions and can independently migrate, validate, and optimize them in Power BI while maintaining business logic and data accuracy.