Demo

Data Warehouse Architect

Kesta IT
Lansing, MI Full Time
POSTED ON 2/14/2025
AVAILABLE BEFORE 5/11/2025

Come build, innovate, disrupt, and thrive!

KēSTA I.T is actively seeking a Data Warehouse Architect foran immediate contract engagement with our government client.

Work Location : This position is Hybrid

Job Description :

We are seeking an experienced Data Warehouse Architect to manage and support critical data infrastructure, security, and operations. This role will be responsible for ensuring data integrity, security, and availability while aligning with organizational policies and procedures. The ideal candidate will have extensive experience with Teradata, SQL, Linux, and data warehouse management.

Responsibilities :

  • Maintain and enforce complex Linux security models on Data Warehouse ETL servers.
  • Manage Teradata security and user access.
  • Conduct elevated access and user audits, mitigating any findings.
  • Oversee the Common Batch Framework and Common Scheduler to ensure reliable data availability.
  • Support change management infrastructure, including code promotions and build engineering tasks.
  • Ensure compliance with Data Warehouse standards and policies.
  • Troubleshoot and resolve escalated Data Warehouse issues.
  • Lead the migration of multiple Data Warehouses into Common Processes.
  • Provide training and technical expertise to development teams for troubleshooting and batch support.
  • Support Data Warehouse continuity planning and testing.

Required Skills :

  • Experience supporting State of Michigan Department of Health and Human Services Data Warehouses.
  • Minimum 12 years of Teradata experience.
  • Minimum 10 years of SQL experience.
  • Minimum 10 years of shell scripting experience.
  • Minimum 5 years of Linux experience.
  • Strong knowledge of data loading from multiple source systems.
  • Ability to work independently while collaborating with teams.
  • Strong decision-making skills that align with organizational policies and procedures.
  • Available Benefits :

  • Medical Benefits (Platinum level plans available)
  • Work from home / Hybrid / Onsite options
  • Holiday Pay
  • 401K
  • Charitable Match
  • Training reimbursement
  • About KēSTA I.T. :

    Our name says it all; KēSTA I.T. (Keys-to-I.T.) AND our people are our keys to our success!

    KēSTA I.T. is a premier Utah-based technical staffing and consulting services firm. We specialize in temporary and permanent placement of Software, Hardware, Network, Cloud, CRM / ERP, Data, End-User support, Web and Executive / leadership-based positions on a full time and consulting basis.

    If you're interested in a role where top performance is rewarded, personal time is valued, and excellence is demanded at every level we want to talk to you today!

    Where do you want to go? We've got the keys! ~ KēSTA I.T.

    WWW.KeSTAIT.COM

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Warehouse Architect?

    Sign up to receive alerts about other jobs on the Data Warehouse Architect career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $190,942 - $250,988
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Kesta IT

    Kesta IT
    Hired Organization Address Warren, MI Full Time
    IAM Architect Location : Remote / Hybrid / Onsite Options Duration : Contract Job Summary : We are seeking an experience...
    Kesta IT
    Hired Organization Address Midvale, UT Full Time
    Come Build, Disrupt and Thrive! K?STA I.T. is seeking an Instructional Designer About K?STA I.T. : K?STA I.T. is a premi...
    Kesta IT
    Hired Organization Address Midvale, UT Full Time
    Come Build, Disrupt and Thrive! K?STA I.T. is seeking an Instructional Designer About K?STA I.T. : K?STA I.T. is a premi...
    Kesta IT
    Hired Organization Address Salt Lake, UT Full Time
    Come build, innovate, disrupt, and thrive! K?STA I.T. is actively seeking a Sr. Network Engineer for an immediate long-t...

    Not the job you're looking for? Here are some other Data Warehouse Architect jobs in the Lansing, MI area that may be a better fit.

    Data Warehouse Architect 5

    Ideal Force, Lansing, MI

    Data Warehouse Architect

    VGroup Inc, Lansing, MI

    AI Assistant is available now!

    Feel free to start your new journey!