Pension Data Analysis and Conversion Consultant (Virtual Opportunity)

City
Virtual - USA
Job ID
2021-2591

Overview

Managed Business Solutions is seeking a Pension Data Analysis and Conversion Consultant to support our pension-related Data Profiling, Cleansing and Migration projects. The Data Analysis and Conversion Consultant will perform data analysis, write Extract, Transform, Load (ETL) scripts, write data reports and provide recommendations for improving data for clients. Pension related experience REQUIRED; .NET, Power Apps or similar programming skills a plus. This is a telecommuting (virtual) role that supports our federal clients and requires a US Citizenship. 

Responsibilities

  • Attend Data Profiling, Data Issue Resolution and Data Mapping Workshops
  • Document Data Maps and Script Designs
  • Write Data Analysis and Data Migration Scripts
  • Perform Quality Assurance on analyzed data, migrated data and developed scripts
  • Write Reports exposing data issues
  • Write Reports for custom developed software
  • Write interface and back bridge programs for systems
  • Analyze data in MS Excel
  • Set up databases and scripting environments within SQL Server
  • Analyze data issues to determine the best course of action for resolution
  • Work well in team environments, including interaction with the client, other vendors and third parties
  • Work on Business Intelligence / Ad-Hoc Reporting projects and tools
  • Suggest and explore new tools to improve processes
  • The position requires up to 5% travel. 

Qualifications

  • Bachelor's Degree in Information Systems, Computer Science or related field strongly preferred along with demonstrated professional experience
  • Must be a US citizen to be considered
  • Experience with data migrations and data conversions
  • Experience with data analysis
  • Experience with pension plan related data and Pension Administration Systems such as Vitech/V3locity
  • DBA and database setup skills preferred
  • Experience with migrating pdf images
  • Be able to analyze large quantities of complex data
  • Must work well in a team environment and be flexible as workloads and priorities change
  • Must be a self-starter and able to define and solve problems
  • Employment for this position will be subject to all relevant laws, regulations, orders, and the like and may require full vaccination against COVID-19, weekly testing, or other precautionary measures. Based on the Executive Orders issued by President Biden in September 2021, roles working on or in connection with a federal contract, or working at a federal-contractor’s workplace, will require full vaccination against COVID-19; roles which are unrelated to federal contracts will be subject to OSHA’s Emergency Temporary Standard relating to vaccination in the workplace, which applies to organizations with 100+ employees.

Desired Skills:

  • Ability to maintain and/or develop small .NET programs preferred
  • Ability to set up SQL Server databases and perform other light Database Administration (DBA) functions preferred
  • Experience with pension-related data.
  • Experience with image (e.g. pdf) conversion from imaging systems to a new system a plus
  • Experience with SharePoint a plus
  • Extensive experience with SQL, SQL Server Database Engine, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Knowledge and experience with SQL Server Analysis Services (SSAS), Tableau and Microsoft Power BI a plus
  • Experience developing small programs in .NET or a similar development environment a plus
  • Experience with source control systems, such as TFS or Git
  • Experience working with data analysis in Excel
  • Microsoft Power Apps environment, Data Factory and Flow in an Azure cloud environment

Environment (Working conditions, physical requirements):

  • This position will require moving of up to 10 lbs. This position will be mostly stationary requiring some movement around the office and frequent communication with others. The average working hours will be 8 hours a day for this position with occasional need to exceed.
  • To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable Accommodations will be made to enable qualified individuals with disabilities to perform the essential functions.
  • EOE M/F/D/V/SO

 

Apply Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed