Business Analyst – Data Integration

The Concourse Group LLC•Marietta, GA

1d•$65,000 - $80,000•Hybrid

About The Position

The Concourse Group is looking for a mid-level Business Analyst and Data Analytics Integrator with demonstrated experience in data integration, dashboard development, and workforce analytics, with the ability to work in a small team environment within our Federal service group. The successful candidate will provide workforce analytics, manpower analysis, and enterprise data integration support to the Georgia Army National Guard Human Resources Office (HRO), which is based in Marietta, GA. This position will be embedded within the client program and will be responsible for executing all day-to-day data integration, analytics development, and dashboard delivery activities. The position requires in-office work with direct client interaction. Some hybrid hours may be available based on program needs and client requirements.

Requirements

Bachelor’s degree in Data Analytics, Information Systems, Business Analytics, Economics, Finance, Public Administration, or a related field
3-5 years of experience supporting data analysis, reporting, or system-based analytics
Ability to communicate findings to senior leadership both orally and in writing
Experience working with enterprise-scale datasets (e.g., HR, financial, operational, or workforce systems)
Advanced experience developing Power BI dashboards and executive reporting
Experience developing dashboards and executive reporting
Working knowledge of data validation, reconciliation, and quality assurance
Proficiency in Microsoft Excel for structured analysis and data transformation
Ability to document analytical logic, business rules, and data definitions clearly
Strong written and verbal communication skills for stakeholder coordination
Ability to operate within controlled, audit-sensitive environments
Strong skills in Microsoft applications, especially Microsoft Excel for structured analysis and data transformation
Advanced proficiency with Microsoft Power BI
Skilled in VBA, JavaScript, Google Apps Script, SQL, or other languages for automation development
Independent worker who can manage multiple tasks with minimal direction
Ability to confidently and professionally interact with senior-level government officials both in person and in virtual environments
Ability to solve problems, overcome obstacles, and present solutions
Ability to communicate effectively and professionally in both writing and orally
Ability to prioritize workflow to meet all deadlines
Ability to prioritize and adapt to respond to requests for ad hoc reporting and data calls
Strong attention to detail with an emphasis on data accuracy, validation, and auditability
Problem-solving mindset with the ability to identify discrepancies and recommend corrective actions
Strong process orientation integrator
Must hold a U.S. Citizenship
Ability to earn a favorable Public Trust clearance.

Nice To Haves

Army National Guard, Army HRO, or DoD manpower experience
Experience supporting workforce planning, personnel management, or budget execution
SQL, Power Query, Power Automate, or similar analytical tools
Experience with General Fund Enterprise Business System (GFEBS)
Experience with Defense Civilian Personnel Data System (DCPDS)
Experience with Full-Time Support Management Control System (FTSMCS)
Experience with ETL processes and automated data refresh cycles
Direct federal experience

Responsibilities

Execute data ingestion, extraction, transformation, validation, and integration tasks across personnel and financial source systems aligned with the approved architecture
Develop, update, and maintain Power BI dashboards and supporting datasets with defined refresh schedules
Perform structured data quality checks, discrepancy identification, and exception tracking. Support analytical and predictive modeling inputs under senior technical direction
Maintain documentation, data dictionaries, and standard operating procedures
Participate in recurring review sessions and incorporate directed refinements
Develop workforce forecasting and predictive analytics models
Build vacancy tracking and hiring projection tools
Monitor personnel actions and workforce lifecycle metrics
Create budget and status-of-funds dashboards
Develop executive-level reports and visualizations for leadership
Identify data discrepancies and recommend corrective actions
Support leadership briefings, inspections, and data validation reviews
Support process improvement initiatives through data-driven analysis
Ensure analytics products meet defined accuracy, reliability, and refresh standards