Data Architect

What you will be doing:

• Serve as the Subject Matter Expert (SME) for data architecture, including design, analysis, evaluation, infrastructure, efficiency, migration, and overarching strategy.
• Strategically plan new designs for database structure integrations, using knowledge of system interfaces to ensure effective integration and optimal performance.
• Analyze methods for transforming existing data into new environment formats and loading it into other database structures.
• Provide recommendations for environment disaster recovery plans and migration tools.
• Manage source-to-target data mapping between different data models.
• Assist in planning, designing, and managing data migration processes between cloud
• environments.
• Work closely with the project manager and development lead to identify resources and integrate the data migration plan into the project schedule.
• Develop best practices and standards for risk management, scheduling, and data-related requirements gathering.
• Perform migration and testing of transactional data from legacy systems to modernized systems.
• Perform migration of users from source to destination systems and coordinate with customers on post-migration issues.
• Define test cases and quality control mechanisms to ensure data is migrated correctly, at the right time, and in suitable volumes for each project phase.
•  Perform post-migration quality assurance, audits, reconciliation, and exception reporting.
• Review existing migration tools and recommend performance improvements for the migration process.
• Identify migration risks and proactively communicate them to the project manager and technical lead.
• Work with management to continually improve team workflows and processes.

What you will bring:

• Education & Experience: Bachelor’s degree required along with 6 years of experience in data migration.

• Hands-on data migration experience using various methods and tools.
• SQL experience creating and maintaining queries, views, and stored procedures
• in a multi-database environment.
• Experience with relational databases, data analysis, and data conversions.
• Problem Solving: Ability to evaluate data integrity, recommend solutions, and develop methods to systematically eliminate data incompatibilities across systems.
• Troubleshooting: Ability to effectively diagnose, isolate, and expediently resolve
• complex data infrastructure problems and monitor project development.
• Consulting: Experience in consulting and active involvement with data-related projects.

• Experience with Microsoft SQL Server, MySQL, and MariaDB.
• Experience with database replication technologies.
• Familiarity with Snowflake or other data warehousing tools.
• Experience with low-code platform data migrations (such as Appian, ServiceNow, and Salesforce) and/or specific Appian-related projects.

Benefits

• Medical Insurance
• Dental Insurance
• Vision Insurance
• Disability and Life Insurance
• Parental Leave
• 401K
• Paid Time Off