Lead Data Engineer/Architect

Job description

Description

The North Carolina Department of Transportation is embarking on a Data Migration Journey specifically for the Dept.

of Motor Vehicles.

The agency has over 30 years of data and will begin scaling their teams in order to prepare that data and begin a migration to Azure.

The Lead Data Architect/Engineer role will aid in the development of a new cloud environment by assisting the DMV Modernization Team with the design, management, and maintenance of data flow as it pertains to cloud technology.

Additionally, this role will also be responsible for data analysis, data profiling, data cleansing, data governance, in preparation for data conversion of the existing environment.

The ideal candidate will be able to develop & maintain cloud data strategy, evaluate data elements and structure, and ensure the smooth integration of data internal and external to cloud initiatives.

This position will direct a team two database programmers to complete the data analysis.

Additionally, the position will assist in a leadership role: ·Execution of cloud design and implementation strategies.
·Evaluation and selection of the appropriate data frameworks.
·Establishment of standards, best practices for data conversion, data mapping, data cleansing, and data migration as it evolves from legacy to cloud-based technologies.
·Design of system integration containing database permissions, keys, and access for authorized data usage and reporting.
·Process Instruction of infrastructure movement techniques and data transfers using multiple ETL/ELT sources.
·Responding to technical issues timely and effectively.
· Leading and solicit database programmers, application teams, security, and infrastructure teams to monitor cloud privacy, performance, and load.
· Capturing lessons learned and transitional knowledge to assist the Leadership Team in establishing a mentoring path that provides technical exposure and develops the next generation of DIT leaders and technical staff.
Additional Roles and Responsibilities The Lead Data Architect/Engineer position will also serve in a lead role in the application support team’s quality assurance for operations and maintenance initiatives.

The resource will serve as Subject Matter Expert (SME) with the following expected responsibilities:
• Lead the design of data conversion, cleansing, migration, and frameworks while ensuring security and data integrity.
• Design and enforce policies based on Data Quality, Data Security, Data retention, Data Stewardship.
• Document the data model & data mapping, create a data dictionary, define columns and data relationships.
• Maintain the end-to-end vision of the data flow diagram and develop logical data models into physical data repositories.
• Use data cleansing & governance tools to administer, manage and script database functions based on user inputs and data quality principles.
• Design and deliver Data integration solutions based on current DB2 and future Microsoft SQL Server systems.
• Identify project impacts on Business Process Models for our business stakeholders as it relates to Software Development Lifecycle methodology.
• Coordinate with all other solution architects to assist the Enterprise Services Team with the delivery of software solutions.

Skills

Python, Sql, Data, Architecture, Cloud, Design, Etl

Top Skills Details

Python,Sql,Data

Additional Skills & Qualifications

The Sr. Data Solutions Engineer position will also serve in a lead role in the application support team’s quality assurance for operations and maintenance initiatives.

The resource will serve as Subject Matter Expert (SME) with the following expected responsibilities:
• Lead the design of data conversion, cleansing, migration, and frameworks while ensuring security and data integrity.
• Design and enforce policies based on Data Quality, Data Security, Data retention, Data Stewardship.
• Document the data model & data mapping, create a data dictionary, define columns and data relationships.
• Maintain the end-to-end vision of the data flow diagram and develop logical data models into physical data repositories.
• Use data cleansing & governance tools to administer, manage and script database functions based on user inputs and data quality principles.
• Design and deliver Data integration solutions based on current DB2 and future Microsoft SQL Server systems.
• Identify project impacts on Business Process Models for our business stakeholders as it relates to Software Development Lifecycle methodology.
• Coordinate with all other solution architects to assist the Enterprise Services Team with the delivery of software solutions.

- Database Design - SQL Server & DB2 - Database Backup, and Table Partition Experience - Database Conversion, Cleansing and Migration - SQL Server SSIS Management

Experience Level

Expert Level

Pay and Benefits

The pay range for this position is $ - $

Eligibility requirements apply to some benefits and may depend on your job
classification and length of employment.

Benefits are subject to change and may be
subject to specific elections, plan, or program terms.

If eligible, the benefits
available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a hybrid position in Raleigh,NC.

Application Deadline

This position is anticipated to close on Oct 20, 2025.

h4>About TEKsystems:

We're partners in transformation.

We help clients activate ideas and solutions to take advantage of a new world of opportunity.

We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia.

As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change.

That's the power of true partnership.

TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services.

We accelerate business transformation for our customers.

Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions.

We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed.

We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology.

We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities.

TEKsystems and TEKsystems Global Services are Allegis Group companies.

Learn more at

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Required Skill Profession

Computer Occupations