Remote Senior Power BI Developer


Description



AVER is seeking an experienced Senior Power BI Developer with deep hands-on expertise in designing, developing, and delivering enterprise business intelligence solutions, interactive dashboards, and custom reporting applications. The ideal candidate brings advanced Power BI development skills, strong SQL expertise, and experience integrating and transforming complex datasets from multiple enterprise systems, including Microsoft SQL Server, Oracle, and cloud-based data platforms. This role requires a versatile, technically proficient developer who can work across data modeling, ETL/ELT processes, reporting architecture, and database integration to deliver scalable, high-performing analytics and reporting solutions. Experience with Python, AWS, Azure, Databricks, and Microsoft Power Platform is highly valued, along with the ability to modernize legacy reporting solutions and improve access to mission-critical information. Join a collaborative team that values AVER's mission, focus, and culture of delivering exceptional client service with great people and transformative technology solutions that ensure Government mission success.

Responsibilities Include:

  • Design, develop, enhance, and maintain enterprise Power BI dashboards, interactive reports, semantic models, and custom reporting solutions supporting complex business and operational requirements.
  • Develop advanced Power BI reports using DAX, Power Query (M), Power BI Desktop, and Power BI Service, including complex calculations, measures, data transformations, and visualizations.
  • Design and optimize Power BI semantic models, including relationships, star schemas, dimensional modeling, and performance optimization.
  • Develop and optimize complex SQL queries, stored procedures, views, and database interactions across Microsoft SQL Server, Oracle, and other relational database platforms.
  • Integrate and transform data from multiple enterprise systems, relational databases, APIs, cloud data warehouses, data lakes, and lakehouse environments.
  • Develop and maintain ETL/ELT processes using SQL, Python, Power Query, and other data integration technologies to support reporting and analytics.
  • Create customized, user-friendly dashboards and reporting interfaces that consolidate data from disparate sources into actionable business and operational insights.
  • Develop paginated reports using Power BI Report Builder and SQL Server Reporting Services (SSRS), as required.
  • Leverage Python for data processing, scripting, automation, data validation, and integration with enterprise reporting solutions.
  • Integrate Power BI with Microsoft SharePoint, Power Apps, Power Automate, and other enterprise applications to improve reporting accessibility and automate business processes.
  • Develop reporting solutions that access cloud-based analytics platforms, including AWS Redshift, Databricks, and Azure-based data environments.
  • Configure and manage Power BI workspaces, datasets, data refresh schedules, gateways, deployment pipelines, and reporting environments.
  • Implement data security and governance controls, including row-level security (RLS), workspace permissions, and role-based access.
  • Troubleshoot and optimize complex reporting, database, data transformation, and performance issues.
  • Support modernization of legacy reporting applications, including migration to Power BI and integration with modern enterprise data platforms.
  • Collaborate with business analysts, data engineers, database administrators, application developers, and stakeholders to translate complex reporting requirements into scalable BI solutions.
  • Explore opportunities to leverage AI-enabled analytics, Microsoft Fabric, and emerging technologies to enhance reporting, automation, and business intelligence capabilities.
  • Participate in requirements gathering, technical design, development, testing, deployment, documentation, and ongoing support of enterprise BI solutions.
  • Provide technical guidance, recommend BI best practices, and support the delivery of reliable, maintainable reporting solutions aligned with customer requirements.

Education Requirements:

  • Bachelor's degree in Computer Science, Information Technology, Data Analytics, Software Engineering, or a related technical discipline.

Experience Requirements:

  • 10+ years of progressive experience in business intelligence, data analytics, reporting development, database development, or related technical disciplines, including significant hands-on Power BI development experience
  • Advanced proficiency with Microsoft Power BI, including Power BI Desktop, Power BI Service, DAX, Power Query (M), and semantic data modeling
  • Strong experience designing, developing, and maintaining complex enterprise dashboards, interactive reports, and custom reporting solutions
  • Advanced SQL development expertise, including complex queries, joins, CTEs, stored procedures, views, data manipulation, and query performance optimization
  • Hands-on experience working with Microsoft SQL Server and Oracle databases, including familiarity with Oracle SQL and PL/SQL.
  • Strong understanding of relational database structures, dimensional data modeling, star schemas, data relationships, and enterprise reporting architecture
  • Experience integrating Power BI with multiple enterprise databases, APIs, external data sources, and cloud-based data environments
  • Experience developing and maintaining ETL/ELT processes, data transformations, and automated data refresh solutions
  • Hands-on Python experience for data processing, scripting, automation, data validation, or integration with reporting and analytics platforms
  • Experience optimizing Power BI performance, including DAX calculations, semantic models, query execution, and data refresh processes
  • Knowledge of Power BI security, workspace administration, access controls, and data governance practices
  • Experience gathering and translating business and operational reporting requirements into technical specifications and functional BI solutions
  • Strong analytical, troubleshooting, and problem-solving skills with the ability to work across complex enterprise data environments
  • Ability to collaborate with technical teams, business stakeholders, and end users to deliver reliable, scalable reporting solutions

Desired Requirements:

  • Experience with Power BI Report Builder, paginated reports, and SQL Server Reporting Services (SSRS)
  • Experience with SQL Server Integration Services (SSIS), Azure Data Factory, or other enterprise ETL/ELT technologies
  • Familiarity with Microsoft Fabric, including OneLake, Lakehouse, Data Factory, and related analytics capabilities
  • Experience integrating Power BI with AWS Redshift, Databricks, Azure SQL, cloud data warehouses, data lakes, or lakehouse architectures
  • Advanced Oracle PL/SQL development experience, including stored procedures, functions, packages, and database performance tuning
  • Experience using Python libraries such as Pandas or PySpark for data transformation, automation, and analytics
  • Knowledge of Microsoft Power Platform, including Power Apps, Power Automate, and integration with Power BI
  • Experience integrating reports and dashboards with SharePoint Online, Teams, or custom enterprise applications
  • Familiarity with Power BI Embedded, REST APIs, and development of customer-facing reporting solutions.
  • Experience with .NET/C#, Java, JavaScript, HTML, or CSS to support custom reporting interfaces, embedded analytics, and application integration
  • Familiarity with AWS or Azure cloud services and enterprise data integration architectures
  • Experience with Git, version control, deployment pipelines, and CI/CD practices for BI development
  • Familiarity with AI-enabled analytics, Microsoft Copilot, predictive analytics, or emerging AI technologies
  • Experience modernizing legacy reporting systems and migrating enterprise reporting solutions to Power BI
  • Previous experience supporting federal government customers or mission-critical enterprise applications

Location:

  • Springfield, VA
  • REMOTE- MUST live in commutable distance to customer site.

Security Requirements:

  • Ability to obtain and maintain a government Public Trust clearance
  • U.S. citizenship required to support the government customer

Compensation Package:

At AVER, we believe our people are the foundation of our success and are committed to providing meaningful work, competitive compensation, and a supportive environment where employees can grow while making a direct impact on critical Government missions. AVER offers a competitive total compensation package designed to support our employees both professionally and personally. Eligible employees receive a comprehensive benefits package that includes health and wellness coverage, paid time off and holidays, retirement benefits, and opportunities for career growth

Target Salary: $150,000–$170,000/year

About Us:

AVER, LLC is a Data & Digital Transformation company that delivers exceptional client service with great people and transformative technology solutions to enable Government mission success. We provide customers with specialized technical skills and deep subject matter expertise focused on Homeland Security, Biometrics, Law Enforcement, and Healthcare domains to meet the complex mission challenges of today and tomorrow. We are a verified Service-Disabled Veteran-Owned Small Business (SDVOSB) that strives to provide a customer-centric experience by building trusted partnerships with our clients and people.

AVER is an Equal Opportunity Employer/Veterans/Disabled



Back to blog

Other Jobs To Apply

Remote Director, GSI Alliances (Global Systems Integrators)

Senior Embedded Product Security Engineer, Docker Desktop (Remote)

Remote Director, Customer Support Systems

Remote Project Manager, Atlas

(EG0077) Marketo Specialist

Technical Account Manager 3

Remote POS Solution Specialist - PA Outside Sales

Product Manager - Dashboard & Enterprise Platforms (Remote)

Director, Cyber Security – IT Audit

Business Analyst, Capital Markets - Integration Hub

Senior Manager, CS Upgrade Technical Delivery Lead - Remote

Remote Implementation Consultant, ERP, National

Senior Manager – Datacenter Engineering

Lead Software Engineer: AI for Hardware Verification

Global Product Support Engineer - Hybrid/Remote

Remote Semiconductor Devices & Microelectronics Expert

Experienced Project Manager, WTR

Remote SMTS Software Engineer – OS & FPGA

LVN or LPN, Case Manager – Remote

Care Solutions Personal Advocate

Senior Premium Auditor

Construction Surety Underwriter/Associate Account Executive - Financial Analyst

SAP S/4HANA PTP/MM Consultant (Public Cloud)

Contact Center and UC Engineer

Client Support Specialist at Fidelity Investments: 100% Remote (San Diego, CA, Del Mar, Rancho Bernardo)

Senior Associate, Executive Search - High-Impact Roles

Supplemental Health Claims CSR (Remote)

Environmental, Health, and Safety Project Manager at Kelly: 100% Remote (Richmond, VA)

Cisco Network Engineer - REMOTE Iowa Residents - FTE

Associate - Manufacturing & Supply Chain

Data Platform Engineering Lead at Deloitte: 100% Remote (US)

Solution Architect, Forward Deployed AI at EPAM Systems: 100% Remote (US)

Customer Service Representative and Data Entry Specialist

Remote CyberArk / Venafi /PKI Certificate Management Analyst

Databricks Platform Architect Remote AWS & AI

Staff Product Manager, Cloud Networking

Remote Lead SAS Developer: SAS-to-Python Migration

Remote Systems Support Specialist I - REMOTE

SAP Manufacturing Architect (PP, MM, PLM) - Remote Opportunity

Odoo Bookkeeper reputed company | 20556

Remote Zoho Developer and Support

AI Transformation Consultant — Forward-Deployed

Content Editor - Audio Projects - Freelancer - Remote

Freelance iOS Developer

Virtual IOP Therapist – Evening Groups (Remote)

Subscriptions & Closings Manager – New York City, NY / San Francisco, CA

Startup & VC Partnerships Manager Brex San Francisco, California, United States $136–170K Sales & Partnerships 2d ago check more →

Lead Product Designer (Design System Specialist)

Meeting Planner

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