Business Analyst – Data Integration

Business Analyst – Data Integration: (Federal / Manpower & Budget) SUMMARY: 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. ROLE PROFILE AND EXPERIENCE EXPECTATION The Business Analyst and Data Analytics Integrator will have 3-5 years of professional experience supporting data analytics, reporting, budget tracking, or operational business intelligence in structured, enterprise environments. Proven ability to automate reporting processes, improve data accuracy, and support decision-making across manpower and financial domains. SKILLS AND ABILITIES: - 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 ROLE 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 REQUIRED EDUCATION AND EXPERIENCE: 1. Bachelor’s degree in Data Analytics, Information Systems, Business Analytics, Economics, Finance, Public Administration, or a related field 2. 3-5 years of experience supporting data analysis, reporting, or system-based analytics 3. Ability to communicate findings to senior leadership both orally and in writing 4. Experience working with enterprise-scale datasets (e.g., HR, financial,…