New

Data Warehouse Architect

TEKsystems
$60.00 - $80.00 / hr
life insurance, sick time, 401(k), retirement plan
United States, Michigan, Lansing
May 19, 2026
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 & LocationThis is a Contract position based out of Lansing, MI. Pay and BenefitsThe 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 TypeThis is a hybrid position in Lansing,MI. Application DeadlineThis 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.