Azure Data Migration Engineer

**Azure Data Migration Engineer** Remote Clearance Level Required: Active Secret Blu Omega is seeking an Azure Data Migration Engineer to support a federal program focused on infrastructure modernization. This role operates within a remote environment and is responsible for leading data migration efforts across the project scope. The position requires experience supporting data migration, especially from Oracle to Azure, within a mission\-driven environment. **Program Overview** **Program:** OFAC Data Modernization **Mission overview:** Supporting the modernization of OFAC's infrastructure, focusing on data migration and system upgrades. **Key Details:** Location: Remote Clearance: Active Secret Work Authorization: US Citizen **Responsibilities:*** Collaborate with stakeholders to gather requirements and ensure data integrity throughout the migration lifecycle * Create data mapping documents (source to target) based on business rules * Perform data profiling, cleansing, and quality checks to ensure accuracy and completeness of migrated data * Analyze and map source Oracle database schemas to target Dataverse tables/entities, defining transformation and cleansing logic as needed * Write and optimize SQL queries, stored procedures, and scripts for Oracle 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 Factory to extract, transform, and load data from sources such as CSV files and Oracle CDCs * Log errors from Azure Data Factory pipelines to a Dataverse table using an audit framework * Push 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 needed * Generate reconcile reports of migrated data using SQL or scripts * Maintain familiarity with Git or source code repositories and CI/CD processes **Required Qualifications:*** Advanced experience in data migration, especially from Oracle 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 **Preferred Qualifications:*** Experience with Dataverse and Azure Data Factory * Familiarity with Azure Data Lake Analytics, Azure Functions, and Logic Apps **Salary Range:** $90,000–$150,000 *Final compensation is based on technical skills, experience, education, certifications, and clearance.* **Blu Omega Benefits \& Perks:*** Medical, Dental, and Vision 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 mental health resources * 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 * Access to wellness programs, discounts, and lifestyle benefits * Benefits eligibility and offerings may vary based on role, employment status, and program requirements **Company Overview** Blu Omega is a Woman\-Owned Small Business (WOSB) delivering technology and cybersecurity solutions to federal agencies and enterprise clients nationwide. Headquartered in Ashburn, VA, we support mission\-critical programs across civilian and defense sectors, including health, national security, and regulatory environments. We partner with government agencies and large integrators to provide expertise in cybersecurity operations, cloud and infrastructure modernization, data and analytics, and enterprise IT support. Our teams are experienced operating within federal contracting environments, supporting task orders, recompetes, and programs requiring cleared personnel and compliant delivery. **Equal Opportunity Employer** *All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability.* *\#CJ \#LI\-Remote*