BI/Data Analyst II

ApplyLogic Consulting Group, LLC; Alexandria (VA); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Employee Assistance Program

401K

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

Short-Term Disability

Advanced illness/Accident Insurance

PTO 15 days

Federal Holidays 11

Education stipend

Job summary

ApplyLogic Consulting Group, LLC in Northern Virginia seeks a BI/Data Analyst II to transform data into useful reports, dashboards, and insights. You will use SQL, Power BI, Excel, and other analytic tools to support reporting and decision-making. This onsite role requires a U.S.

citizen able to obtain Government security clearance, a Bachelor's degree, and 2+ years of data analysis experience. You will develop dashboards and collaborate with data engineers and stakeholders to improve reporting

Qualifications

• - Bachelor's degree in Data Analytics, CS, IS, Business Analytics, Statistics, Mathematics, or related field, or equivalent.
• - 2+ years of professional experience in data analysis, BI, reporting, or related discipline.
• - Experience using SQL to query and analyze data.
• - Experience developing reports/dashboards using Power BI or similar BI platform.
• - Experience working with data from relational databases or multiple sources.
• - Understanding of data analysis, validation, and quality concepts.
• - Strong analytical and problem-solving skills.
• - Ability to translate data into clear reports and visuals.
• - Strong attention to detail and communication skills.

Responsibilities

• Develop and maintain reports, dashboards, and data visualizations using Power BI or similar BI tools.
• Write and execute SQL queries to retrieve, analyze, and validate data.
• Perform data analysis to identify trends, anomalies, and areas needing attention.
• Prepare data for reporting by cleaning and validating sources.
• Support development of Power BI datasets, reports, dashboards, and visuals.
• Collaborate with stakeholders to gather reporting requirements and document data sources.

Skills

SQL

Excel

Data visualization

Data analysis

Reporting

Stakeholder communication

Attention to detail

Independent work

Problem solving

Education

Bachelor's degree in Data Analytics/CS/IS/Business Analytics/Statistics/Math

Tools

SQL Server

Oracle

PostgreSQL

Tableau

Power BI

Power Query

DAX

Job description

ApplyLogic is a fast-paced Service-Disabled Veteran-Owned Small-Business, headquartered in Vienna, VA. Our people are our greatest asset, and our company culture is grounded on that belief. We offer challenging and interesting work in a friendly and supportive environment. Through prime and subcontracts, we deliver best-in-class expertise to solve complex technical problems.

We're looking for a talented BI/Data Analyst II to join our team supporting a complex Federal Government customer in Northern Virginia (Alexandria/Falls Church area). This individual will help transform data from multiple sources into useful reports, dashboards, and insights. You will use SQL, Power BI, Excel, and other analytical tools to support reporting and decision-making.

Work Location:

• Onsite – Northern Virginia (Alexandria/Falls Church area)

Clearance: Must be a U.S. Citizen with the ability to obtain and maintain Government security clearance.

Primary Roles and Responsibilities:

• Develop and maintain reports, dashboards, and data visualizations using Power BI or similar business intelligence tools.
• Write and execute SQL queries to retrieve, analyze, and validate data from relational databases and other sources.
• Perform recurring and ad hoc data analysis to identify trends, patterns, anomalies, and areas requiring attention.
• Prepare data for reporting and analysis by reviewing, cleaning, and validating data from multiple sources.
• Support the development and maintenance of Power BI datasets, reports, dashboards, and visualizations.
• Assist with gathering and documenting reporting and analytical requirements from business and technical stakeholders.
• Perform data validation and quality checks to ensure reports and dashboards accurately reflect underlying data.
• Assist with developing recurring operational, management, and analytical reports.
• Troubleshoot reporting and data issues and coordinate with technical teams when additional support is required.
• Document report definitions, data sources, business rules, and reporting procedures.
• Support efforts to improve reporting processes, data accuracy, and reporting efficiency.
• Collaborate with data engineers, database administrators, developers, and business stakeholders.

Required Education, Experience, & Skills:

• Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business Analytics, Statistics, Mathematics, or a related field, or equivalent combination of education and relevant experience.
• 2+ years of professional experience in data analysis, business intelligence, reporting, or a related discipline.
• Experience using SQL to query and analyze data.
• Experience developing reports, dashboards, or data visualizations using Power BI or a similar BI platform.
• Experience working with data from relational databases or multiple data sources.
• Understanding of data analysis, data validation, and data quality concepts.
• Strong analytical and problem-solving skills.
• Ability to translate data into clear and understandable reports and visualizations.
• Strong attention to detail and ability to identify inconsistencies or anomalies in data.
• Strong written and verbal communication skills.
• Ability to work independently while collaborating effectively with technical and business stakeholders.

Preferred Qualifications

• Advanced Power BI experience, including DAX and Power Query.
• Experience with SQL Server, Oracle, PostgreSQL, or similar databases.
• Advanced Microsoft Excel skills, including PivotTables, Power Query, and complex formulas.
• Experience with Tableau, Qlik, or other BI platforms.
• Experience developing executive, operational, or management dashboards.
• Experience with data modeling and analytical datasets.
• Experience with Python, R, or other analytical programming languages.
• Experience with data warehousing.
• Experience with data quality or data governance practices.
• Experience supporting complex enterprise environments.
• Experience supporting U.S. government or federal contracting programs.
• Active or previously held U.S. government security clearance.

The Perks of Being on Our Team

ApplyLogic offers competitive salaries with a robust Fortune-500 type benefits package. Some of the benefits you will receive when you join us are:

• Employee Assistance Program
• 401K
• Medical/Dental/Vision Insurance
• Life/Short-Term Disability/Critical Illness/Accident Insurance
• 15 PTO Days
• 11 Federal Holidays
• Up to $5K towards continuing education and/or professional development

Salary Range

$75,000-$95,000

The posted salary range represents the anticipated compensation for this position. Final compensation will be based on the selected candidate's qualifications, years of directly relevant experience, education, certifications, security clearance, contract requirements, and other business considerations.