Maryland Heights MO 63043 St Louis 1 14100 Magellan Plaza
Job DescriptionServes 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 requestors' 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. Responsible for keeping up with latest software trends. 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.
- Performs other duties as assigned.
• SQL, PL/SQL, T-SQL for Oracle & MS SQL Server
• ETL Experience in SSIS or similar
• Report development experience in SSRS
General Job Information
Job FamilyGeneral Services Group
CountryUnited States of America
FLSA StatusUnited States of America (Exempt)
Recruiting Start Date10/25/2018
Date Requisition Created10/25/2018
License and Certifications - Required
License and Certifications - Preferred
Other Job Requirements
ResponsibilitiesMinimum of 4 years systems analysis experience in appropriate technical environment.Related professional experience in the managed care, healthcare, or insurance industries. Analytical/problem solving skills, excellent verbal and written communication skills, strong PC background, efficient 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