Home / Careers / Data Migration Engineer

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.

Sound like you? Join us.

arrow&v
Are you 18 years of age or older
Are you an United States citizen or legally authorized to work in the United States
Will you now or in the future require sponsorship for employment
Upload Resume
Upload Cover Letter

I certify that I have read and understand the applicant instructions included with this application and that the answers given by me to the foregoing questions and statements made by me are complete and true to the best of my knowledge and belief.

​

I understand that any false information, omissions or misrepresentations of facts called for in this application, whether on this document or not, may result in rejection of my application or discharge at any time during my employment.

​

I understand that this application form is intended for use in evaluating my qualifications for employment and that this application is not an offer of employment. I further understand that if hired, my employment will be considered "at-will" and that my employment may be terminated for any reason, with or without cause or notice, at any time by me or the Company and that this application is not intended to constitute a contract of continued employment.

Thanks for applying!