SQL ETL Programmer/Data Migration Manager

SmartAdvocate Conceptualized by the founding partner of a leading personal injury law firm, SmartAdvocate is a leading state of the art legal case management platform that offers flexible deployment options and a modular suite of applications, including both a traditional server and Cloud versions. Legal professionals use SmartAdvocate to manage their law firms which include contacts, communication, new case intake wizards, barcoding of documents, document generation, easy template creation, email and attachment filing, workflow, client portal, Dashboards, iPhone, iPad and Android app, calendaring and docketing. Smart Advocate can also track time, and functionality is available for firms that also want integrated accounting, billing, and invoicing. Position Summary We are looking for a SQL Developer to work on data conversion projects. Data from legacy case management systems is mapped to fields in SmartAdvocate database. SQL Developer is responsible for creating and running data conversion scripts that move data from old systems to SmartAdvocate. Required Skills MS SQL Demonstrated experience in data mapping and data conversion Comfortable navigating large quantities of data. Strong analytical, conceptual, problem solving and troubleshooting skills. Nice to Have Skills Experience in Legal Industry ASP.NET C# Additional Information/Benefits We offer a competitive compensation and benefit package along with the opportunity to be part of a unique, cutting edge software development company. We maintain a safe and healthy working environment. Our office is a non-smoking facility. We offer a competitive compensation and benefit package including medical insurance, PTO, and 401K Plan. We are an equal opportunity employer. Job Type: Full-time Pay: $60,000.00 - $110,000.00 per year Benefits: 401(k) 401(k) matching Dental insurance Flexible spending account Health insurance Life insurance Paid time off Parental leave Vision insurance Schedule: 8 hour shift Experience: Microsoft SQL Server: 3 years (Required) SQL: 5 years (Required) Work Location: In person