Position Summary:

The Lead Data Integration Engineer, specializing in database migrations and development, will be an experienced technical generalist familiar with a wide assortment of leading database technologies and methods. The qualified candidate must possess a thorough understanding of advanced database concepts relational DBMSs, SQL programming, ETL scripting, performance, and scalability, with a working knowledge of web services, business intelligence, data warehouses, and operational data stores. In this role you will work independently with limited supervision and with other department personnel; this is an individual contributor position with no direct reports.

Position Responsibilities:

• Data Migration: Apply best practices in ETL processes involving disparate data sources, both third-party and proprietary to create migration tools for customer migrations from one product to another, as well as transformations for specific high-value enterprises.
• Database Development: Active with database development IDEs such as Oracle PL/SQL (SQL Developer), MySQL workbench, Toad, Squirrel, and including ETL job construction for data migrations between products, systems, and enterprises (Talend preferred, alternatively Microsoft Data Studio, Informatica, SSIS).
• Develop and maintain custom database tools and scripts that can be run either by our Customer Support Team or via scheduled automation, enabling the export/import or migration of entities such as customers, work orders, etc. from one system to another, while accounting for data quality and mapping challenges
• Define the development tasks and estimates for completion (including story writing)
• Manage the database lifecycle and data migrations through multiple environments
• Participate in the scrum team ceremonies: stand-up, planning, grooming, demo, retro

Position Qualifications:

• B.S. in Computer Science
• 10+ years working in a database environment with data integration tools
• High competency in entity-relationship analysis from requirements to diagramming
• Logical and physical data modeling; solid ERD skills using Erwin, Visio or similar
• Background of ETL migration of user data from one product to another, with examples
• RESTful API call experience in an ETL package; JSON/XML parsing and serialization
• Extensive Oracle, MySQL, Microsoft SQL Server experience
• SQL development, optimization, performance tuning
• Programming languages (besides SQL): Java, Python, .NET/C#
• Exceptional communication, organization, and time management skills
• Strong analytical problem-solving skills with a high attention to detail
• Track record as a self-starter, results-oriented, and delivery-focused contributor