Note: This client does require for the resource to come on site on day 1 to obtain the laptop and get an informal orientation. The role is then remote until Covid is over and their team goes back on site. At that time, relocation by you to join their team in IL is required. Role: SQL Analyst (Data conversion) Duration: 6+ months contract Location: Naperville, IL MOI: 2 phone interviews Duties: data conversion experience, taking data and migrating and converting it into new systems. Not a SQL Developer: SQL is needed for analysis. Example of work to be done: what they need are people who can take insurance claim information from client A (and let's say its twenty characters) and convert that into a ten character claim that client B's database so that the system will recognize. This is where the analysis skills of the insurance claims come into play as they need to be able to determine what's useful and necessary info in the acquired company's claim systems that will go from client A to client BA's claims system (CTABS). Description: We need a strong SQL analyst resource with strong stored procedure and reporting background. The application is written in .NET so a candidate ideally will be familiar with that as well. This role will serve as the primary ETL used to do data migrations and conversions between vericlaim's claims system and recent acquisitions York and Cunningham. The resource needs to be able to do data integration using multiple data sources to convert into usable data in a new system, not just copying a table from a data warehouse to another data warehouse. This is the most important skill they need for this role. Candidates with strong SSIS and SQL experience will be best for this role Skills: sql server, sql database, ssis, stored procedures, tsql, data conversion, data migration, dts, claims domain (preferably P&C). Top Skills Details
Additional Skills & Qualifications: Good communication skills, a computer science degree is highly desired
- The analyst will be utilized to move data from Client's acquired companies into their claims management system, called C-Tabs.
- They must be able to understand system level data conversions.
- Those who only know or have done data warehouse conversions are not qualified for the role.