The Data Architect is responsible for designing and executing comprehensive data migration strategies from legacy systems to modernized environments. This includes creating data dictionaries, managing source-to-target mapping, and ensuring data integrity through rigorous testing and quality assurance.
Data Architect
Department: Data
Employment Type: Full Time
Location: Remote
Description
At Nüvitek, customer success is our Ethos; together, we drive transformational outcomes. We only succeed when our customers succeed. We partner with our customers to achieve business objectives by using our proven customer-centric, value-driven business practices and service delivery methodologies.
As a Data Architect, you will work closely with a team of developers and engineers in an Agile environment to support, design, and control data applications. Your primary focus will be formulating and executing comprehensive data migration strategies. You will be responsible for building a detailed understanding of legacy data structures, locations, and edge cases, creating data dictionaries, and developing the source-to-destination mapping and transformations necessary to migrate data to modernized systems. You will also engage with downstream data consumers to ensure that migrations effectively address stakeholder needs.
In assuming this position, you will be a critical contributor to meeting Nuvitek's mission: To deliver innovative, cost-effective solutions and services that enable our customers to rapidly adapt to dynamic environments.
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.
Technical Skills:
- 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.
Preferred Qualifications:
- 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
Nuvitek is proud to offer a comprehensive benefits package:
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Disability and Life Insurance
- Parental Leave
- 401K
- Paid Time Off
Equal Opportunity Employer Statement
Nuvitek is an equal-opportunity employer as to all protected groups, including protected veterans and individuals with disabilities.