Database Architect

Satwic - Los Angeles, CA

Full-time

Los Angeles, CA

Professional, Scientific, and Technical Services

About the position

The Database Architect will be responsible for overseeing the data migration from the Bitfocus platform to the Salesforce environment. This role involves ensuring data integrity, security, and accuracy throughout the migration process while collaborating closely with the project team and stakeholders. The position requires daily meetings with the project team to facilitate effective data extraction, validation, and ingestion into Salesforce.

Responsibilities

• Conduct a thorough review of the current data within the Bitfocus system.
• Follow and study the current data mapping strategy.
• Complete the development of the data mapping strategy to align existing data fields with the structure of the new Salesforce environment.
• Identify any data inconsistencies, duplicates, or inaccuracies within the Bitfocus system.
• Cleanse and transform the data to ensure compatibility and proper formatting within Salesforce.
• Extract data from the Bitfocus system, ensuring secure handling and minimal disruption to ongoing operations.
• Populate the extracted and cleansed data into the Salesforce templates.
• Work with the developer to ensure proper data mapping and migration.
• Load the cleansed and transformed data into the new Salesforce environment following best practices.
• Conduct comprehensive testing for all migrated data to verify relationships, dependencies, and functionality against the legacy system's requirements.
• Document all migration steps, including issues encountered and resolutions, for future reference.
• Support users and stakeholders to ensure the new system functions as expected and address post-migration issues.

Requirements

• Data migration specialist proficient in SQL queries.
• Experience in data migration and database management, particularly with SQL queries.
• Familiarity with Salesforce data architecture is a plus.

Nice-to-haves

• Knowledge of Salesforce data architecture preferred.