Data Migration Engineer
DEPARTMENT: Information Technology
OFFICE LOCATION: Fort Wayne, IN/Remote
FLSA STATUS: Exempt
TYPE: Regular Full-time
Who You Are
You like order and accuracy and troubleshooting. You also like technology. You’re fully aware of the strategic advantage clean and timely data can be to a company. In addition to your technical prowess, you’re a service-minded person, because you understand relationships are foundational to success. If this sounds like you, please continue.
What You’ll Do
As the Data Migration Engineer, you play a critical role in helping us onboard new customers to our platforms by leading the data migration efforts from a customer’s legacy system to our system.
To be successful, you will have to:
-
Learn and understand our core data model
-
Work with software providers, customers, and implementation team to obtain data files
-
Downloading, decrypting, and placement of raw data files to Azure Storage
-
Creation of stage and target SQL databases for new customer via scripts
-
Creation and configuration of customer migration pipelines in Azure Data Factory from template
-
Execute on importing raw customer data to customer’s staging data via Azure Data Factory pipelines
-
Analysis on tables imported to look for new/unexpected objects within the schema
-
Provide implementations team with a statistical overview of the data received (how many files, record counts, any other data explicitly requested.)
-
Build migration SQL views/objects for the given source system based on existing templates
-
Execute on object data migration via Azure Data Factory to customer target database based on implementation timelines/deadlines
-
Review data migration feedback provided by the implementation team and make any customer-specific adjustments as required
-
Will oversee and be responsible for the final “go-live” production migration
-
Will also have responsibility for ensuring customer data security and segmentation
-
Mitigate any post “go-live” production issues related to data mapping or in support of the app development team’s needs
What You Need
-
A Bachelor’s degree in Computer Science, Information System, or a related field, or equivalent experience;
-
A minimum of 5 years’ experience working on a database team or on database projects;
-
Proven development experience with Microsoft SQL Server Database platform;
-
Proven experience in data migrations between two systems and/or ETL experience
-
Ability to create and maintain database objects including but not limited to tables, views, indexes, user-defined functions, stored procedures, triggers, constraints, custom data types, etc.;
-
Demonstrated understanding of database architectural concepts including but not limited to creating relational models, data segmentation/partitioning, implementing data security models, etc.;
-
Prior experience with or understanding the following is a plus:
-
Microsoft SQL Server Reporting Services or similar enterprise reporting tool;
-
Microsoft Azure Data Factory o Microsoft SQL Server Integration Services or similar ETL tool;
-
Creation and/or management of data feeds utilizing both structured (ex XML/JSON) and flat schemas (ex CSV,TXT,XLSX) across a wide range of electronic delivery mechanisms (ex API/ASMX/SFTP)
-
Database performance optimizations including index tuning, execution plan analysis, and troubleshooting
-
Techficient is an equal opportunity employer.
We celebrate diversity and are committed to creating an inclusive environment for all employees.