Mid-Level Power BI Developer – SQL, DAX & Power Query

HarmonyTech Inc. is seeking a talented and self-motivated Mid-Level Power BI Developer to design, develop, enhance, and support enterprise business intelligence, data analytics, and reporting solutions for a client.
The ideal candidate will have strong hands-on experience with Microsoft Power BI, SQL, DAX, Power Query, data modeling, ETL, data transformation, dashboards, and data visualization. This role will work closely with business and technical stakeholders to translate requirements into secure, reliable, and high-performing reporting and analytics solutions.

This position requires full-time onsite work from HarmonyTech's office in Fairfax, Virginia. Remote work is not available.

Candidates must be U.S. citizens and may not hold dual citizenship with another country. The selected candidate must also meet applicable federal personnel security and onboarding requirements.

Key Responsibilities

• Design, develop, enhance, and maintain Power BI dashboards, reports, metrics, visualizations, and data models.
• Develop and optimize SQL queries, DAX measures, calculated columns, and Power Query transformations.
• Gather and analyze business requirements and translate them into technical, reporting, and analytics solutions.
• Design and optimize data models, relationships, and complex data transformations.
• Integrate Power BI solutions with databases, files, applications, and other enterprise data sources.
• Validate data accuracy and troubleshoot ETL pipelines, transformations, data connectors, data-quality issues, and performance problems.
• Publish and maintain reports through Power BI Service, including workspace management and scheduled data refreshes.
• Optimize reports, dashboards, queries, and data models for performance and maintainability.
• Implement appropriate data security and access controls, including row-level security (RLS).
• Collaborate with product owners, subject-matter experts, data teams, developers, and other business and technical stakeholders throughout the development lifecycle.
• Participate in solution design, development, testing, implementation, and production support.
• Create and maintain technical documentation, including specifications, data models, scripts, workflows, and user guidance.
• Develop reporting solutions consistent with applicable Section 508 accessibility requirements.
• Follow established development, security, source-control, documentation, and solution-management standards.

Required Skills & Qualifications

• 7+ years of overall IT, data, analytics, application development, or business intelligence experience.
• 3+ years of hands-on Microsoft Power BI development experience.
• Strong hands-on experience with Power BI, SQL, DAX, and Power Query.
• Experience developing interactive dashboards, reports, visualizations, metrics, and data models.
• Strong understanding of relational databases, data modeling, data relationships, and business intelligence concepts.
• Experience with ETL, data transformation, data preparation, pipelines, and connectors.
• Experience integrating Power BI with multiple databases and enterprise data sources.
• Experience with Power BI Service, performance optimization, scheduled refreshes, troubleshooting, and data validation.
• Knowledge of data security, access controls, and row-level security (RLS).
• Ability to translate business requirements into effective technical and analytics solutions.
• Strong analytical and problem-solving skills with attention to data quality and accuracy.
• Strong written and verbal communication skills and the ability to collaborate effectively with business and technical teams.
• Must be a U.S. citizen and must not hold dual citizenship with another country.

Preferred Qualifications

• Experience supporting federal government, financial services, or other regulated environments.
• Experience with Microsoft Power Automate and SharePoint Online.
• Familiarity with Amazon Web Services (AWS) and cloud-based data and analytics solutions.
• Experience with Python for data analysis, transformation, automation, or scripting.
• Familiarity with GitHub, JIRA, ServiceNow, or DBeaver.
• Experience with source control and established software development lifecycle practices.
• Knowledge of Section 508 accessibility requirements.
• Familiarity with federal information security, privacy, data governance, or compliance requirements.
• Experience supporting enterprise-scale business intelligence, reporting, data analytics, or automation solutions.

Education

• Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Engineering, or a related field preferred.