Senior Power BI Developer

AVer Information

United States

Hybrid

USD 150,000 - 170,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health benefits
Paid time off
Retirement benefits
Career growth opportunities

Job summary

AVer Information is seeking an experienced Senior BI Engineer to design, develop, and optimize enterprise Power BI solutions. You’ll build semantic models, dashboards, and paginated reports, working with SQL Server/Oracle and cloud data platforms to deliver actionable insights.

The role requires strong Power BI, DAX, SQL, and Python skills, plus experience integrating multiple data sources, ETL/ELT processes, and governance. Remote-ready with on-site collaboration in Springfield, VA.

Qualifications

  • 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

Responsibilities

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

Skills

Power BI
DAX
SQL
Python
ETL/ELT
SSRS
SSIS
Azure Data Factory
Data modeling
Security governance
Performance tuning

Education

Bachelor's degree in Computer Science, Information Technology, Data Analytics, Software Engineering, or related

Tools

Power BI Report Builder
SSRS
SQL Server
Oracle
Python

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Power BI Developer
Senior Power BI Developer

Aver, Llc • Springfield (VA)

Remote
USD 150,000 - 170,000
Health and wellness coverage
Paid time off and holidays
Retirement benefits
+1
Power BI/ SQL Developer
Power BI/ SQL Developer

AVER • Hanover (MD)

On-site
USD 65,000 - 78,000
Benefits package
.Net Application Developer
.Net Application Developer

Aver, Llc • Washington

Hybrid
USD 110,000 - 124,000
Data Integration & Application Support Specialist
Data Integration & Application Support Specialist

AVER • Washington

On-site
USD 120,000 - 145,000
Senior Solutions Architect
Senior Solutions Architect

AVER • Springfield (VA)

Hybrid
USD 180,000 - 230,000
Senior .Net Application Developer
Senior .Net Application Developer

Aver, Llc • Washington

Hybrid
USD 130,000 - 157,000
Senior .Net Data Integration Engineer
Senior .Net Data Integration Engineer

AVER • Washington

On-site
USD 120,000 - 145,000
Health benefits
Paid time off
Retirement benefits
+1
Business Intelligence Engineer (Power BI)
Business Intelligence Engineer (Power BI)

Avanza • Arlington (VA)

Hybrid
USD 90,000 - 130,000
Business Intelligence Engineer (Power BI)
Business Intelligence Engineer (Power BI)

Avanza LLC • Arlington (VA)

Hybrid
USD 120,000 - 150,000
Competitive salary
Health insurance
401(k) retirement plan
+1
Senior Power BI Architect — Remote Enterprise Analytics
Senior Power BI Architect — Remote Enterprise Analytics

Aver, Llc • Springfield (VA)

Remote
USD 150,000 - 170,000
Health and wellness coverage
Paid time off and holidays
Retirement benefits
+1