Data Architect

Nüvitek•Arlington, VA

2d•Remote

About The Position

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.

Requirements

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.
Ability to evaluate data integrity, recommend solutions, and develop methods to systematically eliminate data incompatibilities across systems.
Ability to effectively diagnose, isolate, and expediently resolve complex data infrastructure problems and monitor project development.
Experience in consulting and active involvement with data-related projects.

Nice To Haves

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.

Responsibilities

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.