Application Programmer (Level III) – Microsoft 365 / Power Platform & Power BI

Other Jobs To Apply

** Only US Citizens please apply**

** FEDERAL EXPERIENCE IS AN ADDED ADVANTAGE**

BITS is a growing software development company in Washington DC area. We provide database solutions, application development, infrastructure supports, network engineering, and high-end computing using innovative technologies to the health agencies. We are looking for a Application Programmer (Level III) for one of our FEDERAL projects.

Job Description:

Position Summary

The Application Programmer (Level III) will support the National Institute of Health (NIH) in the planning, design, development, delivery, and sustainment of right-sized, low-code technology solutions using Microsoft 365, SharePoint Online, and the Microsoft Power Platform, with a strong emphasis on Power BI analytics and data storytelling. This role will build and maintain data models, dashboards, and automated workflows that improve business operations, data quality assurance, and operational efficiency across the program offices, while enabling reuse of enterprise data assets.

Key Responsibilities

Data Analytics & Power BI Delivery

  • Design, develop, deliver, and support Power BI reports, dashboards, and visualizations aligned to NIH business needs and audience requirements.
  • Build and maintain data models that support reporting and visualization, documenting:
  • data entities/fields collected and produced by NIH business units
  • relationships, transformations, and business rules
  • data definitions and lineage to support data management requirements
  • Apply best practices for data storytelling presenting the right data, context, and narrative for intended stakeholders.

Power Platform & M365 Low-Code Solutions

  • Design, develop, deliver, and support solutions leveraging:
  • Power Apps (canvas/model-driven as appropriate)
  • Power Automate (workflow automation and integrations)
  • Power BI (analytics and reporting)
  • other Power Platform tools and M365 Apps and Services as they become available for use within NIH Office of the Director
  • Develop solutions that may include multiple Power Platform components (e.g., Power App + Power Automate + SharePoint + Power BI) and ensure maintainability and reuse.

SharePoint Online Solutions

  • Design, develop, deliver, and support SharePoint Online sites to enable data analytics services and products, following the best practices.
  • Execute data migration to SharePoint Online using:
  • native SharePoint Online functionality
  • Power Automate workflows
  • manual methods when needed

while maintaining data integrity and data quality standards based on business requirements.

Data Integration & Data Management

  • Create and manage data connections and integrations between Power BI/Power Platform solutions and NIH enterprise systems and sources (e.g., nVision) and other approved data sources.
  • Demonstrate working knowledge of data architecture, data management concepts, and database features, including SQL and query languages.
  • Implement and support secure, performant data access patterns (e.g., data refresh strategies, gateway configurations, role-level access where applicable, and optimization techniques).

Delivery, Operations, and Support

  • Provide ongoing support, troubleshooting, and enhancements for delivered solutions, including bug fixes, performance tuning, and incremental feature updates.
  • Produce and maintain technical documentation (design notes, configuration, data model documentation, support guides).

Required Qualifications (Must Have)

  • Demonstrated expertise in all of the following:
  • Power Apps
  • Power Automate
  • Power BI
  • SharePoint Online
  • Strong hands-on capability in:
  • data modeling for analytics (relationships, measures, transformations)
  • building end-user-ready reporting products in Power BI
  • SQL / query languages and understanding of database management features
  • Experience designing and supporting SharePoint Online sites and implementing data migration approaches while preserving data integrity and quality.
  • Ability to translate business needs into visually intuitive, audience-appropriate analytics and dashboards (data storytelling).
  • Experience integrating solutions with enterprise data sources and/or systems.

Desired Qualifications (Nice to Have)

  • Familiarity with additional Power Platform tools (e.g., Dataverse, Power Virtual Agents/Copilot Studio where applicable).
  • Familiarity with Azure DevOps (work items, source control, release coordination).
  • Familiarity with NIH enterprise applications and data sources (e.g., nVision) and common federal reporting environments.
  • Experience working in regulated or high-governance IT environments with documented standards and repeatable delivery processes.

Core Competencies

  • Analytical mindset: ability to structure ambiguous data needs into clear models and outputs
  • Quality & integrity: focus on data accuracy, consistency, and usability
  • Customer orientation: ability to deliver “right-sized” solutions that reduce time-to-delivery and lifecycle costs
  • Communication: clear documentation and the ability to explain technical concepts to non-technical stakeholders
  • Delivery discipline: follows standards, maintains documentation, and supports solutions post-launch

Education & Experience (Typical for Level III)

  • Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
  • 5–8+ years relevant experience in application development, analytics, or low-code solutions delivery, with significant hands-on work in the Microsoft 365 / Power Platform ecosystem (especially Power BI).

Job Type: Full-time

Pay: $135,000.00 per year

Work Location: Remote

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...