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

HarmonyTech; Virginia; On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical/Dental/Vision Insurance

401(k) Retirement Plan with Company –M

Tuition Reimbursement

Employee Referral Bonus

Paid Federal Holidays

Accrued Paid Time Off

Job summary

HarmonyTech is seeking a Mid-Level Power BI Developer to design, develop, enhance, and support enterprise BI and reporting solutions. The role emphasizes Power BI, SQL, DAX, Power Query, data modeling, ETL, and data transformation across secure, reliable reporting landscapes. The position is full-time onsite at HarmonyTech’s Fairfax, VA office.

Candidates must be U.S. citizens; no remote work is available. Strong collaboration with business and technical stakeholders is required to deliver

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.
• 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 collaboration with teams.
• Must be a U.S. citizen and not hold dual citizenship.

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 data security and access controls, including row-level security (RLS).
• Collaborate with product owners, data teams, developers, and stakeholders throughout the 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 Section 508 accessibility requirements.
• Follow development, security, source-control, documentation, and solution-management standards.

Skills

Power BI development

SQL

DAX

Power Query

Data modeling

ETL

Data visualization

Data analysis

Education

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

Tools

Power BI Desktop

Power BI Service

SQL Server

Job description

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.

About HarmonyTech

We have been delivering information technology services and solutions across the federal government and commercial clients for over a decade. Our employees are the most important assets of our company because they deliver value and care for our clients. We are a company of passionate technologists, constantly evolving in our understanding and application of technology to best fulfill our clients’ mission needs. We operate under a flat and efficient organizational structure to ensure our hand‑picked consultants have the flexibility to take risks and be innovative. We typically work in small, agile teams as we design and develop solutions to address our clients’ business challenges. Our success is measured with every satisfied customer and employee.

Why you want to join us

• You have a passion for solving our customers’ complex business problems
• Awesome learning and professional development opportunities
• A culture built on teamwork and excellence

Benefits

HarmonyTech offers a highly competitive salary and benefits package, including:

• Medical/Dental/Vision Insurance
• Short/Long Term Disability Coverage
• Life and AD&D Insurance
• 401(k) Retirement Plan with Company Match
• Tuition Reimbursement
• Employee Referral Bonus
• Paid Federal Holidays
• Accrued Paid Time Off
• View our full benefits package

Legal

HarmonyTech believes in a policy of equal employment and opportunity for all people based on merit. We are an Equal Opportunity Employer (EEO) and Drug Free Workplace Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, disability status, or any other category protected by applicable federal, state, or local laws.

The statements herein are intended to describe the general nature and level of work being performed by employees and are not to be construed as an exhaustive list of responsibilities, duties, and skills required of personnel. Additionally, they do not establish a contract for employment and are subject to change at the discretion of HarmonyTech.