What are the responsibilities and job description for the SQL ETL Developer/Data Migration Specialist position at SmartAdvocate?
Job description
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: $70,000.00 - $115,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
Compensation Package:
- Yearly bonus
Schedule:
- 8 hour shift
Experience:
- Microsoft SQL Server: 3 years (Required)
- SQL: 5 years (Required)
Ability to Commute:
- Melville, NY 11747 (Required)
Work Location: In person
Job Type: Full-time
Pay: $70,000.00 - $115,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
Schedule:
- Monday to Friday
Experience:
- Informatica: 1 year (Preferred)
- SQL: 1 year (Preferred)
- Data warehouse: 1 year (Preferred)
Ability to Relocate:
- Melville, NY: Relocate before starting work (Required)
Work Location: In person
Salary : $70,000 - $115,000