[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.
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
Skills
- 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
- Experience with Dataverse and Azure Data Factory
- Familiarity with Azure Data Lake Analytics, Azure Functions, and Logic Apps
Benefits
- 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