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 wit h 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