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

HarmonyTech; Fairfax (VA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical/Dental/Vision Insurance

Short/Long Term Disability

Life and AD&D Insurance

401(k) Retirement Plan with Company M

Tuition Reimbursement

Employee Referral Bonus

Paid Federal Holidays

Paid Time Off

Job summary

HarmonyTech Inc. is seeking a Mid-Level Power BI Developer to design, develop, and support enterprise BI and analytics solutions from our Fairfax, VA office. The role focuses on Power BI dashboards, data models, and ETL enhancements to deliver actionable insights for clients.

The ideal candidate will have 3+ years of Power BI development and strong SQL/DAX skills, with experience in data modeling, ETL, and data visualization. This onsite position requires U.S.

Qualifications

• 7+ years of IT, data, analytics, or BI experience.
• 3+ years of hands-on Microsoft Power BI development.
• Strong hands-on experience with Power BI, SQL, DAX, and Power Query.
• Experience developing interactive dashboards, reports, and data models.
• Understanding of relational databases, data modeling, and BI concepts.
• Experience with ETL, data transformation, and data preparation pipelines.
• Experience integrating Power BI with multiple databases and enterprise data sources.
• Knowledge of data security and row-level security (RLS).
• Ability to translate business requirements into technical analytics solutions.
• Strong analytical and communication skills.
• Must be a U.S. citizen and not hold dual citizenship.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and data models.
• Develop and optimize SQL queries, DAX measures, and Power Query transformations.
• Gather requirements and translate them into technical analytics solutions.
• Design data models and optimize data transformations.
• Integrate Power BI with enterprise data sources and databases.
• Validate data quality and troubleshoot ETL pipelines and data issues.
• Publish and manage reports in Power BI Service with scheduled refreshes.
• Implement data security and access controls including RLS.
• Collaborate with stakeholders throughout the development lifecycle.
• Create technical documentation and user guidance.

Skills

Power BI

SQL

DAX

Power Query

Data modeling

ETL

Data transformation

Dashboards

Data visualization

Education

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

Tools

Power Automate

SharePoint Online

AWS

Python

GitHub

JIRA

ServiceNow

DBeaver

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 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.