Hiring || SQL Data Migration Specialist - Remote
Please mention DailyRemote when applying
AI Summary
Lead the secure transition of data from legacy ERP systems into Deltek Vantagepoint through analysis, mapping, and transformation. Develop SQL-based ETL scripts and collaborate with operations to design custom reports and workflows.
Summary:
The SQL Data Migration Specialist plays a critical role in ensuring the seamless and secure transition of data from legacy ERP systems into Deltek Vantagepoint. This position demands a high level of technical expertise in Microsoft SQL Server and a deep understanding of data architecture, migration strategies, and ERP system functionality. The specialist will lead data analysis, mapping, and transformation efforts, working closely with cross-functional teams to design, execute, and validate migration processes. By maintaining data integrity and accuracy throughout the lifecycle, the specialist ensures that the organization’s financial and operational data is reliable, compliant, and ready for use in the new environment. This role also involves ongoing support, process improvement, and innovation in data management practices.
Experience: 8-12 years
Responsibilities:
- Collaborate with project teams to define and document data migration requirements.
- Analyze and map data structures between legacy systems and Deltek VantagePoint.
- Perform comprehensive data analysis and cleansing on source systems.
- Develop, test, and implement SQL-based ETL scripts and procedures.
- Validate migration outcomes through rigorous testing and reconciliation.
- Identify, troubleshoot, and resolve data inconsistencies and anomalies.
- Execute data migration activities in production environments with minimal disruption.
- Partner with Operations to design, build, and customize reports using Microsoft Visual Studio.
- Create and configure workflows within Deltek Vantagepoint to support business processes.
- Research, evaluate, and implement emerging tools and technologies related to Deltek Vantagepoint.
- Provide technical support, guidance, and troubleshooting for data-related issues.
- Serve as a subject matter expert on Deltek Vantagepoint data structures and migration best practices.
Requirements
- Proficiency in writing complex SQL queries for data extraction, transformation, and loading into Deltek Vision/Vantagepoint.
- Demonstrated experience with relational databases, including tables, views, T-SQL, and stored procedures.
- Proven ability to develop advanced queries and stored procedures for workflows and custom reporting.
- Strong understanding of database systems, data modeling, and migration methodologies.
- Excellent analytical, problem-solving, and troubleshooting skills.
- close attention to detail and a commitment to data accuracy and integrity.
- Ability to work independently and collaboratively within cross-functional teams.
- Experience in data mapping and transformation between legacy systems and Deltek VantagePoint.
- Hands-on experience with data extraction, cleansing, and validation processes.
- Minimum 5 years of professional development experience with Microsoft SQL Server.
- Required: In-depth knowledge and hands-on experience with Deltek Vision/Vantagepoint.
- Preferred: Experience in professional services or consulting environments.
- Understanding of accounting principles and financial data structures.
Additional Details
Total Experience: 8-12 years
Relevant Experience: 5 years in SQL and Data Migration
Skills: Proficiency in writing complex SQL queries for data extraction, transformation, and loading into Deltek Vision/Vantagepoint
Notice Period: Immediate to 20 days
Location: Remote
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
