The Concourse Group

The Concourse Group

Business Analyst – Data Integration

Marietta, Georgia · Full-time

No sponsorshipDetected 27 days ago
JavaScriptSQLData AnalysisData EngineeringData VisualizationProject ManagementForecastingExcelProcess ImprovementHRLeadershipCommunicationProblem Solving

About the role

  • 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.
  • Long-Term Disability Insurance | Company-paid benefit.

Responsibilities

  • 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
  • Develop workforce forecasting and predictive analytics models
  • Build vacancy tracking and hiring projection tools
  • Create budget and status-of-funds dashboards
  • Develop executive-level reports and visualizations for leadership
  • Support leadership briefings, inspections, and data validation reviews
  • Support process improvement initiatives through data-driven analysis

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)
  • Working knowledge of data validation, reconciliation, and quality assurance
  • Proficiency in Microsoft Excel for structured analysis and data transformation
  • Ability to operate within controlled, audit-sensitive environments

Nice to have

  • 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
  • Preference is given to those with direct federal experience.

Skills

  • 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
  • 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

Compensation

  • 401K | Pre-tax employee contribution and Concourse matches up to 4% of the base salary.

Benefits

  • This position is eligible for the comprehensive Concourse benefits package.
  • Healthcare Insurance Benefit | Health, Dental, and Vision benefits.
  • Life Insurance | Company-paid benefit.
  • Short-Term Disability Insurance | Employee-paid premium.
  • Health Savings Account | Pre-tax employee contribution.
  • Paid Time-Off (PTO) Benefit | 15 PTO days per year.

Company info

  • A small business founded in 2001, The Concourse Group (Concourse) is an accomplished consulting firm committed to improving government project efficiency and budgetary goals with a focus on Making the Complex Simple.
  • We offer a flexible daily work schedule and a hybrid weekly schedule.

Equal opportunity

  • Equal Opportunity Employer

Visa & Work Authorization

  • Citizenship

This listing is sourced directly from The Concourse Group's careers page and normalized into a canonical job model.