Job Title: Microsoft Power BI Developer
Location: Richmond, VA (Hybrid)
Duration: 15 Months + Extension
Bill Rate: $68/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:

The Power BI Developer will design and deliver enterprise-level business intelligence solutions that transform complex business data into meaningful insights. This role involves developing interactive dashboards, building optimized semantic data models, creating advanced DAX calculations, and integrating data from multiple enterprise systems. The candidate will collaborate with business stakeholders, data engineers, and analysts to understand reporting needs and deliver reliable, scalable analytics solutions.

Dashboard Design & Business Intelligence:

• Develop interactive Power BI dashboards, reports, scorecards, and KPI visualizations for business users.
• Translate business requirements into meaningful reports with clear data storytelling and user-friendly layouts.
• Create drill-through reports, bookmarks, tooltips, slicers, and dynamic visualizations.
• Build executive-level dashboards to track operational, financial, and business performance metrics.
• Maintain and enhance existing reports based on changing business requirements.

Data Modeling & Transformation:

• Develop optimized semantic models using Star Schema and Snowflake Schema approaches.
• Create complex DAX measures, calculated columns, and KPIs for business reporting.
• Perform data extraction, cleansing, and transformation using Power Query and M language.
• Connect Power BI to SQL Server, Azure SQL, Excel, SharePoint, Snowflake, and other data sources.
• Implement data validation and reconciliation to maintain reporting accuracy.

Power BI Service & Enterprise Reporting:

• Publish and manage reports, datasets, and dashboards through Power BI Service.
• Configure workspaces, gateways, scheduled refreshes, and deployment pipelines.
• Implement Row-Level Security (RLS) and workspace-level access controls.
• Optimize report performance using DAX Studio, Performance Analyzer, and query optimization techniques.
• Support report migration, production deployments, and troubleshooting of refresh failures.

Microsoft Data Platform Integration:

• Work with Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, and Azure SQL services.
• Integrate Power BI with enterprise data warehouses and cloud-based data platforms.
• Collaborate with ETL and data engineering teams to establish reliable reporting pipelines.
• Maintain documentation for datasets, data sources, business metrics, and reporting dependencies.

Skills & Professional Experience:

• 5–8 years of experience in Business Intelligence, Data Analytics, or Power BI development.
• Strong hands-on expertise in Power BI Desktop, Power BI Service, DAX, and Power Query.
• Advanced SQL skills with experience in SQL Server, joins, CTEs, stored procedures, and query optimization.
• Strong understanding of dimensional data modeling, semantic models, and data warehousing.
• Experience with Azure data services or Microsoft Fabric is preferred.
• Knowledge of RLS, workspace administration, deployment pipelines, and performance tuning.
• Bachelor's degree in Computer Science, Information Technology, or a related field preferred.
• Microsoft PL-300 or DP-600 certification is an advantage.