Senior Power BI & SQL Analyst for Federal Programs

ApplyLogic Consulting Group, LLC; Alexandria (VA); Hybrid; USD 95,000 - 115,000; Full time

Benefits offered by this job

Employee Assistance Program

401K

Medical/Dental/Vision Insurance

Life/Short-Term Disability/Critical Il

11 Federal Holidays

Job summary

ApplyLogic Consulting Group, LLC in Northern Virginia (Alexandria/Falls Church area) is seeking a BI/Data Analyst III to independently develop BI solutions for a Federal Government customer. You will work with SQL, Power BI, and multiple data sources to deliver actionable reporting and insights for operational and management decisions.

The role emphasizes complex dashboard development, data modeling, and performance optimization, with on-site work in Northern Virginia and a strong focus on

Qualifications

• Bachelor's degree or equivalent in a related field.
• 4+ years of progressive experience in data analytics or BI.
• Advanced SQL to query, manipulate, and analyze data.
• Experience developing complex Power BI dashboards, reports, datasets, and visualizations.
• Experience integrating data from multiple databases and sources.
• Experience defining KPIs, metrics, and reporting requirements.
• Strong analytical, problem-solving, written, and verbal communication skills.

Responsibilities

• Develop and maintain complex Power BI dashboards, reports, datasets, and visualizations.
• Develop advanced SQL queries to retrieve, transform, validate, and analyze data from multiple sources.
• Analyze complex datasets to identify trends, relationships, anomalies, and actionable insights.
• Design reporting solutions that translate business requirements into effective analytical products.
• Develop recurring, ad hoc, operational, management, and executive-level reporting.
• Develop and maintain data models and analytical datasets supporting BI and reporting requirements.
• Perform complex data validation and quality analysis to ensure reporting accuracy and consistency.
• Integrate and analyze data from multiple databases, applications, and enterprise data sources.
• Optimize reports, queries, datasets, and dashboards for performance and usability.
• Work with stakeholders to define reporting requirements, metrics, KPIs, and business rules.
• Troubleshoot complex reporting, data, and visualization issues.
• Identify opportunities to automate reporting and improve analytical processes.
• Document data sources, transformations, calculations, report logic, and business rules.
• Provide guidance and knowledge sharing to less-experienced analysts.

Skills

Advanced SQL

Power BI dashboards

Data analysis

KPIs and metrics

Analytical problem-solving

Verbal and written communication

Project/time management

Stakeholder collaboration

Education

Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business Analytics, Statistics, Mathematics, or related field

Tools

Power BI

SQL Server

Oracle

PostgreSQL

Excel

Tableau

Qlik

Python

R

Job description

ApplyLogic Consulting Group, LLC in Northern Virginia (Alexandria/Falls Church area) is seeking a BI/Data Analyst III to independently develop BI solutions for a Federal Government customer. You will work with SQL, Power BI, and multiple data sources to deliver actionable reporting and insights for operational and management decisions.

The role emphasizes complex dashboard development, data modeling, and performance optimization, with on-site work in Northern Virginia and a strong focus on