[Remote] Azure Data Migration Engineer

Note: The job is a remote job and is open to candidates in USA. Blu Omega 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 Oracle to Azure.ResponsibilitiesCollaborate with stakeholders to gather requirements and ensure data integrity throughout the migration lifecycleCreate data mapping documents (source to target) based on business rulesPerform data profiling, cleansing, and quality checks to ensure accuracy and completeness of migrated dataAnalyze and map source Oracle database schemas to target Dataverse tables/entities, defining transformation and cleansing logic as neededWrite and optimize SQL queries, stored procedures, and scripts for Oracle databases to support data migrationImplement data transformation processes to ensure data compatibility with Dataverse data types, relationships, and constraintsConfigure data pipelines in Azure Data Factory to extract, transform, and load data from sources such as CSV files and Oracle CDCsLog errors from Azure Data Factory pipelines to a Dataverse table using an audit frameworkPush data to Dataverse tables, including necessary transformations for target 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 neededGenerate reconcile reports of migrated data using SQL or scriptsMaintain familiarity with Git or source code repositories and CI/CD processesSkillsAdvanced experience in data migration, especially from Oracle to AzureStrong skills in Azure SQL data migrationProficiency in SQL, including writing and optimizing queries and stored proceduresExperience with data migration tools and processes, including CSV importsAbility to work independently with minimal supervisionUS Citizen with an active Secret clearance to startExperience with Dataverse and Azure Data FactoryFamiliarity with Azure Data Lake Analytics, Azure Functions, and Logic AppsBenefitsMedical, Dental, and Vision coverage through national providers401(k) with company match (eligible after 6 months; vesting applies)Company-paid Life and AD&D insurance with additional voluntary optionsShort-term disability (company-paid) and long-term disability optionsEmployee Assistance Program (EAP) with 24/7 confidential support and mental health resourcesTelehealth and virtual care options available through medical plansPet insurance, legal services, and identity theft protection optionsPaid Time Off (PTO) for eligible employeesPaid federal holidays for salaried employeesAccess to wellness programs, discounts, and lifestyle benefitsBenefits eligibility and offerings may vary based on role, employment status, and program requirementsCompany OverviewBlu Omega offers IT services and Clinical Research management consulting, focusing on technology solutions for federal sectors. It was founded in 2020, and is headquartered in Ashburn, Virginia, USA, with a workforce of 51-200 employees. Its website is https://bluomega.com.