Data Architect

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.

Do you have experience in Stakeholder management?, Do you have a Bachelor's degree?, * 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.

Pulled from the full job description

• Parental leave
• 401(k)
• Health insurance
• Paid time off
• Vision insurance
• Dental insurance
• Life insurance, 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.

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., 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.