Data Warehouse Architect

Job Description

Description

Job Responsibilities:

Responsible for complex Common Batch Framework and Common Scheduler to ensure current and reliable data is available for critical business processes and decision making.

Responsible for Data Warehouse change management infrastructure and all promotions of code and ddl; performing build engineer tasks for both manual and automated promotion processes.

Responsibility for complex Linux security model on DW ETL servers. (Servers are administered by another group, but our team is responsible for the security structure and authorizes user access to the groups and sudos)

Responsibility for Teradata security and access.

Conduct data architecture reviews and audits to ensure alignment with enterprise standards

Create and maintain comprehensive documentation of data architecture, processes, and solutions

Responsible for providing support for escalated Data Warehouse issue troubleshooting and resolution.

Evaluate and recommend new data technologies and tools to improve performance and scalability

Ensure data quality, accuracy, and effective use of enterprise data assets

Manage and support data integration processes, including ETL workflows across multiple systems

Collaborate with external vendors and third-party service providers as needed

Support patch management, system upgrades, and ongoing system maintenance

Monitor system performance and troubleshoot technical issues across data platforms

Perform data profiling and implement data quality rules for assessment and validation

Execute data cleansing and standardization using both built-in and custom data rules

Develop and maintain disaster recovery and backup strategies for data systems

Lead efforts to migrate data warehouse processes to standardized/common frameworks

Conduct elevated access reviews and user audits to ensure compliance

Identify and remediate audit findings related to data systems and security

Skills

teradata, Data architecture, Data modeling, linux, business intelligence

Top Skills Details

teradata,Data architecture,Data modeling,linux,business intelligence

Additional Skills & Qualifications

Required Qualifications:

8+ years Teradata experience - top requirement

Experience supporting the loading of data from multiple source systems

Ability to provide targeted training and technical guidance to development teams for troubleshooting and batch support

Minimum Of 5 Years Of Linux Experience

Proven ability to work both independently and collaboratively within a team environment

Strong decision-making skills with the ability to determine appropriate solutions

Strong problem-solving and analytical thinking skills, particularly in troubleshooting complex data and system issues

Strong communication skills with the ability to translate complex technical concepts to both technical and non-technical stakeholders

Preferred Qualifications:

Previous government experience

Experience with cloud-based BI tools

Additional Notes:

Team Environment: The team currently consists of 2 fulltime employees and 6 long-term contractors. It's a collaborative and well-established group that is looking for a senior-level resource who can step in and contribute immediately.

Work: Most work comes through one of the Data Warehouse development teams. This role will work closely with developers, leadership, stakeholders, and various SOM and vendor staff on a day-to-day basis.

Experience Level

Expert Level

Job Type & Location

This is a Contract position based out of Lansing, MI.

Pay And Benefits

The pay range for this position is $60.00 - $80.00/hr.

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

Application Deadline

This position is anticipated to close on May 20, 2026.

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 TEKsystems.com.

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.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.