Job Description
Salary: $150,000 - 170,000 per year Requirements:
- Bachelors degree in Computer Science, Information Technology, Data Analytics, Software Engineering, or a related technical field.
- 10+ years of progressive experience in business intelligence, data analytics, reporting or database development, or a related discipline, including substantial hands-on Power BI development.
- Advanced proficiency with Power BI Desktop and Service, DAX, Power Query (M), and semantic data modeling.
- Experience developing complex enterprise dashboards, interactive reports, and custom reporting solutions.
- Advanced SQL skills, including complex queries, joins, CTEs, stored procedures, views, data manipulation, and performance optimization.
- Hands-on experience with Microsoft SQL Server and Oracle, including familiarity with Oracle SQL and PL/SQL.
- Knowledge of relational databases, dimensional modeling, star schemas, data relationships, and enterprise reporting architecture.
- Experience integrating Power BI with enterprise databases, APIs, external sources, and cloud data environments.
- Experience building and maintaining ETL/ELT processes, data transformations, and automated refresh solutions.
- Hands-on Python experience for data processing, scripting, automation, validation, or analytics integration.
- Experience optimizing Power BI performance, including DAX, semantic models, queries, and refresh processes.
- Knowledge of Power BI security, workspace administration, access controls, and data governance.
- Ability to translate business and operational reporting needs into technical specifications and BI solutions.
- Strong analytical, troubleshooting, and problem-solving skills, and ability to collaborate with technical teams, stakeholders, and end users.
- Ability to obtain and maintain a government Public Trust clearance; U.S. citizenship is required to support the government customer.
- Desired: Experience with Power BI Report Builder, paginated reports, SSRS, SSIS, Azure Data Factory, Microsoft Fabric, AWS Redshift, Databricks, Azure SQL, cloud data warehouses, data lakes, or lakehouse architectures.
- Desired: Advanced Oracle PL/SQL, Python libraries such as Pandas or PySpark, Microsoft Power Platform, SharePoint Online, Teams, Power BI Embedded, REST APIs, or custom enterprise applications.
- Desired: Experience with .NET/C#, Java, JavaScript, HTML, CSS, AWS or Azure, Git, CI/CD, AI-enabled analytics, legacy reporting modernization, or federal government and mission-critical applications.
Responsibilities: - Design, develop, enhance, and maintain enterprise Power BI dashboards, reports, semantic models, and custom reporting solutions.
- Build advanced Power BI reports using DAX, Power Query, Power BI Desktop, and Power BI Service, including calculations, transformations, and visualizations.
- Design and optimize semantic models, relationships, star schemas, dimensional models, and reporting performance.
- Develop and tune SQL queries, stored procedures, views, and database interactions across SQL Server, Oracle, and other relational platforms.
- Integrate and transform data from enterprise systems, databases, APIs, cloud warehouses, data lakes, and lakehouse environments.
- Develop and maintain ETL/ELT processes using SQL, Python, Power Query, and other integration technologies.
- Create accessible, user-friendly dashboards that turn data from diverse sources into actionable insights.
- Develop paginated reports with Power BI Report Builder and SSRS as needed.
- Use Python for data processing, scripting, automation, validation, and reporting integrations.
- Connect Power BI with SharePoint, Power Apps, Power Automate, and other enterprise applications to improve access and automate processes.
- Build reporting solutions using AWS Redshift, Databricks, Azure, and other cloud analytics platforms.
- Administer Power BI workspaces, datasets, refresh schedules, gateways, deployment pipelines, and reporting environments.
- Apply security and governance controls, including row-level security, workspace permissions, and role-based access.
- Troubleshoot and improve reporting, database, transformation, and performance issues.
- Modernize legacy reporting applications by migrating them to Power BI and integrating them with current data platforms.
- Work with analysts, data engineers, database administrators, developers, stakeholders, and customers to turn reporting needs into scalable BI solutions.
- Explore AI-enabled analytics, Microsoft Fabric, and emerging technologies to strengthen analytics, reporting, and automation.
- Participate in requirements gathering, technical design, development, testing, deployment, documentation, and ongoing support.
- Provide technical guidance, recommend BI practices, and help deliver reliable, maintainable solutions aligned with customer needs.
Technologies: - AI
- AWS
- Redshift
- Azure
- Business Intelligence
- C#
- CI/CD
- Cloud
- CSS
- Databricks
- DAX
- ETL
- Embedded
- Fabric
- Git
- Support
- Java
- JavaScript
- Microsoft Power Platform
- Oracle
- Power BI
- Power Query
- Python
- PySpark
- REST
- SQL
- Security
- SharePoint
- SSIS
- pandas
- ASP.NET
- Copilot
More:
We are AVER, LLC, a data and digital transformation company delivering technology solutions and client service to support Government mission success. Our expertise spans Homeland Security, Biometrics, Law Enforcement, and Healthcare. As a verified Service-Disabled Veteran-Owned Small Business, we focus on trusted, customer-centered partnerships. Youll join a collaborative team supporting enterprise analytics and mission-critical information. The role is based in Springfield, Virginia, with remote work available for candidates who live within commuting distance of the customer site. Our compensation package includes a target salary of $150,000–$170,000 per year, health and wellness coverage, paid time off and holidays, retirement benefits, and career development opportunities. We are an equal opportunity employer.
last updated 43 week of 2026
Job Tags
Full time, Remote work