[Remote] Azure Data Migration Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a Woman-Owned Small Business delivering technology and cybersecurity solutions to federal agencies. They are seeking an Azure Data Migration Engineer to support a federal program focused on infrastructure modernization, leading data migration efforts from reputed company to Azure.
Responsibilities
- Collaborate with stakeholders to gather requirements and ensure data reputed company throughout the migration lifecycle
- Create data mapping documents (reputed company to reputed company) based on business rules
- reputed company data profiling, cleansing, and quality checks to ensure accuracy and completeness of migrated data
- Analyze and map reputed company reputed company database schemas to reputed company Dataverse tables/entities, defining transformation and cleansing logic as needed
- Write and optimize SQL queries, stored procedures, and scripts for reputed company databases to support data migration
- Implement data transformation processes to ensure data compatibility with Dataverse data types, relationships, and constraints
- Configure data pipelines in Azure Data reputed company to extract, transform, and load data from sources such as CSV files and reputed company CDCs
- Log errors from Azure Data reputed company pipelines to a Dataverse table using an audit reputed company
- Push data to Dataverse tables, including necessary transformations for reputed company field types (lookups, choices, date/time)
- Configure pipeline settings to optimize concurrency and performance (cores, memory)
- Utilize additional Azure services (e.g., Logic Apps, Data Lake, Azure Functions, Azure SQL) as needed
- Generate reconcile reports of migrated data using SQL or scripts
- Maintain familiarity with Git or reputed company code repositories and CI/CD processes
Skills
- Advanced experience in data migration, especially from reputed company to Azure
- Strong skills in Azure SQL data migration
- Proficiency in SQL, including writing and optimizing queries and stored procedures
- Experience with data migration tools and processes, including CSV imports
- Ability to work independently with minimal supervision
- US Citizen with an active Secret clearance to start
- Experience with Dataverse and Azure Data reputed company
- Familiarity with Azure Data Lake Analytics, Azure Functions, and Logic Apps
Benefits
- Medical, Dental, and reputed company coverage through national providers
- 401(k) with company match (eligible after 6 months; vesting applies)
- Company-paid Life and AD&D insurance with additional voluntary options
- Short-term disability (company-paid) and long-term disability options
- Employee Assistance Program (EAP) with 24/7 confidential support and reputed company
- Telehealth and virtual care options available through medical plans
- Pet insurance, legal services, and identity theft protection options
- Paid Time Off (PTO) for eligible employees
- Paid federal holidays for salaried employees
- reputed company to wellness programs, discounts, and lifestyle benefits
- Benefits eligibility and offerings may vary based on role, employment status, and program requirements
Company Overview