Power BI Developer, Sr. - 100% Remote

About the Company

AVER, LLC is a Data and Digital Transformation company providing specialized technical expertise and technology solutions to support government missions. The company serves customers across Homeland Security, Biometrics, Law Enforcement, and Healthcare. AVER is a verified Service-Disabled Veteran-Owned Small Business (SDVOSB) focused on building trusted client partnerships and delivering reliable technology solutions.

About the Role

AVER is seeking an experienced Senior Power BI Developer to design, develop, and maintain enterprise business intelligence solutions, interactive dashboards, and custom reporting applications. This role requires advanced Power BI development skills, strong SQL expertise, and experience integrating complex datasets from multiple enterprise systems, including Microsoft SQL Server, Oracle, and cloud-based data platforms.

The developer will work across data modeling, ETL/ELT processes, reporting architecture, and database integration to deliver scalable, high-performing analytics solutions. The position will also support legacy reporting modernization and improve access to mission-critical information for government customers.

Key Responsibilities

• Design, develop, enhance, and maintain enterprise Power BI dashboards, interactive reports, semantic models, and custom reporting solutions.
• Develop advanced Power BI reports using DAX, Power Query (M), Power BI Desktop, and Power BI Service.
• Create complex calculations, measures, data transformations, and visualizations to support business and operational reporting requirements.
• Design and optimize Power BI semantic models, including relationships, star schemas, dimensional modeling, and performance.
• Develop and optimize SQL queries, stored procedures, views, and database interactions across Microsoft SQL Server, Oracle, and other relational databases.
• Integrate and transform data from 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.
• Build user-friendly reporting interfaces that consolidate data from multiple sources into actionable business and operational insights.
• Develop paginated reports using Power BI Report Builder and SQL Server Reporting Services (SSRS), as required.
• Use 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.
• Develop reporting solutions that access cloud 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 reporting, database, data transformation, and performance issues.
• Modernize 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 reporting requirements into scalable BI solutions.
• Explore AI-enabled analytics, Microsoft Fabric, and emerging technologies to improve reporting, automation, and business intelligence capabilities.
• Participate in requirements gathering, technical design, development, testing, deployment, documentation, and ongoing support.
• Provide technical guidance and recommend BI best practices to deliver reliable and maintainable reporting solutions.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, Software Engineering, or a related technical discipline.
• 10+ years of progressive experience in business intelligence, data analytics, reporting development, database development, or related technical fields, including significant hands-on Power BI development.
• Advanced proficiency with Microsoft Power BI, including Power BI Desktop, Power BI Service, DAX, Power Query (M), and semantic data modeling.
• Strong experience developing and maintaining complex enterprise dashboards, interactive reports, and custom reporting solutions.
• Advanced SQL development skills, including complex queries, joins, CTEs, stored procedures, views, data manipulation, and query performance optimization.
• Hands-on experience with Microsoft SQL Server and Oracle databases, including 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 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.
• Ability to collaborate with technical teams, business stakeholders, and end users to deliver scalable reporting solutions.

Preferred Qualifications

• 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 Power BI integration.
• Experience integrating reports and dashboards with SharePoint Online, Teams, or custom enterprise applications.
• Familiarity with Power BI Embedded, REST APIs, and customer-facing reporting solutions.
• Experience with .NET/C#, Java, JavaScript, HTML, or CSS for 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 & Work Arrangement

• Remote position.
• Must reside within commuting distance of the customer site in Springfield, Virginia.
• The role may require travel to the customer site as needed.

Security Requirements

• Must be a U.S. citizen to support the government customer.
• Must be able to obtain and maintain a government Public Trust clearance.

Compensation & Benefits

• Target annual salary: $150,000–$170,000.
• Eligible employees receive health and wellness coverage, paid time off, paid holidays, and retirement benefits.
• Opportunities for professional development and career growth.

Equal Employment Opportunity

AVER is an Equal Opportunity Employer and provides equal employment opportunities to veterans and individuals with disabilities.