Design and own data migration strategy and architecture. Map source-to-target data models, build data dictionaries, perform migrations and testing, reconcile results, and collaborate with stakeholders and project teams to ensure successful modernization.
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.
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.
Nuvitek is an equal-opportunity employer as to all protected groups, including protected veterans and individuals with disabilities.
About
Nuvitek is a systems integrator and technology service provider who strive to improve it's customers performance through technological innovation and by delivering IT services that are faster and more efficient.We are a team of engineers who are passionate about solving technology problems, we believe with the right team and the right technology, IT organizations can solve complex problems and make your business leaner, faster and more flexible.Our team of engineers has more than 20 years of experience delivering successful IT projects to Federal Government and commercial clients. Our services put technology to work for our customers so that they can devote all their energies to their core mission.With our strong pool of talented, expert staff, Nuvitek has a sterling track record of providing innovative and reliable IT solutions in the area of IT modernization, cloud integration, infrastructure automation, IT operations, IT service management and data integration to both government and commercial clients.We believe in getting things done effectively and efficiently with simple, innovative solutions. Nuvitek believes in going above-and-beyond and delivering results — outstanding results.
Similar Jobs
Big Data • Cloud • Productivity • Software • Database • Analytics • Automation
The Staff Data Architect will enhance Jellyfish's data platform through architectural design, automation, advanced observability, and efficient data governance, while collaborating across teams.
Top Skills:
AirflowBigQueryDagsterDatabricksPrefectPythonSnowflakeSQLTerraform
Artificial Intelligence • Fintech • Healthtech • Software
Lead the design and execution of a new enterprise data platform, ensuring metrics reliability and supporting AI-driven products, while mentoring engineers and collaborating across teams.
Top Skills:
AirflowCdcDbtFivetranKafkaLiquibaseOpenmetadataPythonSnowflakeSQLStreaming/Event Driven Architectures
Information Technology • Database • Consulting
Design and implement AWS-based data architectures and lakehouse solutions, lead data engineering teams, build ETL and real-time pipelines (Kafka/Kinesis), use DBT and Airbyte for ingestion and transformation, orchestrate workflows with Airflow/MWAA, enforce security/compliance, and guide infra automation with Terraform/CloudFormation and CI/CD.
Top Skills:
AirbyteApache AirflowApache KafkaAPIsAws EmrAws GlueAws KinesisAws LambdaAws MwaaAws RedshiftAws S3CloudFormationData LakehouseDbtHudiJenkinsPysparkPythonSQLTerraform
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
