Mid-Level Power BI Developer – SQL, DAX & Power Query
About The Position
HarmonyTech Inc. is seeking a mid-level Power BI Developer to design, develop, enhance, and support enterprise business intelligence, data analytics, and reporting solutions for a client. The role involves working with business and technical stakeholders to turn requirements into secure, reliable, and high-performing reporting and analytics solutions. This is a full-time, onsite position at 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 meet applicable federal personnel security and onboarding requirements. HarmonyTech provides IT services and solutions to federal government and commercial clients. Its teams typically work in small, agile groups, and the company describes its structure as flat and efficient, supporting consultant flexibility and innovation.
Requirements
- At least 7 years of overall IT, data, analytics, application development, or business intelligence experience.
- At least 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 ability to collaborate effectively with business and technical teams.
- Must be a U.S. citizen and must not hold dual citizenship with another country.
- Must meet applicable federal personnel security and onboarding requirements.
Nice To Haves
- 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.
- Bachelor's degree in Computer Science, Information Technology, Information Systems, Data Analytics, Engineering, or a related field preferred.
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.
Benefits
- Medical, dental, and vision insurance
- Short- and 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
- Learning and professional development opportunities
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
