Business Analyst I

Arlington VA 22206 AFSC Magellan Federal

Job Description

This position is temporary to permanent.
Serves as liaison between departmental team business owners, end users, IT, Claims and Clinical departments. Responds to ad hoc requests for support, reports and analysis. Supports departmental management team by providing trending and performance data. Supports special projects. Maintains and monitors reporting queues and requests (if appropriate), and internal share point sites. May participate in full life cycle development by performing requirements analysis, process development and design, and testing using development methodology. Collaborates with functional teams, as well as with IT business analysts and programmers to develop detailed design specifications according to standards.
  • Develops and documents workflow, systems requirements, system impact analysis, systems design, process analysis and testing (including reasonableness checks) using software development methodology to provide efficient, cost-effective solutions as directed.
  •  Identifies impact of solutions on existing and future systems.  May perform operational activities.
  • Creates and maintains standard related reports to support operational and development needs.  
  • Manages reporting and requests for ad hoc reports to support sales, implementation, new product development, specials.  
  • Queries data warehouse and internal databases and prepares user friendly reports according to outlined requirements.  
  • Creates and maintains internal management tools and databases to support CQI, rates, workflow business rules and system configuration, reimbursement and document management requirements.   
  • Develops and maintains project plans.
  • Manages small to medium sized projects, system enhancements impacting data management.    
  • Conducts root cause analyses, gathering data to pinpoint problem areas on which to focus, validating that the analysis is data driven, recommending and implementing solutions and evaluating those results, and implementing controls to monitor consistent use of the solution. 
  • Participates in design plans for implementation, produces user documentation and training materials.  May conduct end user training.
  • Provides status reports that give a detailed description of the current project's progress and indicates time devoted to each task of the project; leads status meetings, creating agendas and documenting meeting minutes as needed.
  • Identifies reporting needs based on system configuration and workflows and documents reporting requirements and testing of new reports in development prior to implementation to Production.
  • Participates in initiatives or projects that support process improvements, leveraging new system capabilities or the integration of data/other applications into existing systems.
  • Perform data upload from Workday into Costpoint

  • Design and run comparison reports to assess system continuity. Evaluate fields in both systems to verify the successful daily transfer of inbound and outbound data

  • Report data discrepancies to Workday and Deltek integration POCs

  • Identify resolution of variances with cross-functional teams including Finance, HR, Payroll and Workday Systems teams

  • Confirm data corrections and run verification reports

  • Create desktop procedures for work flow and instructional purposes

  • Performs other duties as assigned.

General Job Information


Business Analyst I



Job Family

General Services Group


United States of America

FLSA Status

United States of America (Exempt)

Recruiting Start Date


Date Requisition Created


Minimum Qualifications


A Combination of Education and Work Experience May Be Considered. (Required), Bachelors (Required)

License and Certifications - Required

License and Certifications - Preferred

Other Job Requirements


  • 5+ years of experience with advanced Excel, Access, or related analytical tool performing data mapping, extraction, transformation and loading between a variety of enterprise platforms, to include Workday or Deltek Costpoint.

  • Strong cross-functional collaboration skills and the proven ability to work effectively with numerous stakeholders and contributors, both internally and externally

  • Strong technical writing skills to clearly communicate process flow

  • Ability to work with graphical tools to illustrate workflow

  • Analytical/problem solving skills.
  • Excellent verbal and written communication skills.
  • Strong PC skills.
  • Proficient in using standard software.
  • Knowledge of system process analysis and/or program management, estimating IT system development and testing

Magellan Health Services is proud to be an Equal Opportunity Employer and a Tobacco-free workplace. EOE/M/F/Vet/Disabled