Demo

Data Warehouse Architect :: Lansing, MI (Hybrid)

Ark Solutions
Lansing, MI Full Time
POSTED ON 2/2/2025
AVAILABLE BEFORE 4/28/2025

Ark Solutions Inc is looking for Data Warehouse Architect!

Position : Data Warehouse Architect

Location : Lansing, MI (Hybrid)

Duration : 6 Months and possibility of extension

Description :

Day-to-day Responsibilities :

  • Responsible 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)
  • Responsible for Teradata security and access.
  • 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.
  • Responsible for migrating the three separate DWs supporting four Program areas to Common Processes.
  • Responsible for DW standards and processes including their adherence to policies and procedures.
  • Responsible for conducting elevated access and user audits.
  • Responsible for mitigating any audit findings; providing input to SSPs.
  • Responsible for Data Warehouse Continuity Planning and testing.
  • Responsible for providing support for escalated Data Warehouse issue troubleshooting and resolution.

Required Experience :

  • Experience supporting one or more State / Federal / Government Data Warehouses projects
  • Minimum 12 years Teradata experience.
  • Minimum 10 years SQL experience.
  • Minimum 10 years shell scripting experience.
  • Minimum 5 years Linux experience.
  • Supporting the loading of data from multiple source systems.
  • Providing targeted training and technical expertise to development teams to enable them to better troubleshoot and support their batches.
  • Proven track record of working independently within a collaborative team.
  • Must be able to make decisions on the correct path forward in various situations while staying consistent with policies.
  • Top Skills & Years of Experience :

  • Experience supporting at least one (or more) State of Michigan Department of Health and Human Services Data Warehouses
  • Minimum 12 years Teradata experience
  • Minimum 10 years SQL experience.
  • Minimum 10 years shell scripting experience.
  • Minimum 5 years Linux experience.
  • Proven track record of working independently within a collaborative team.
  • 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 :: Lansing, MI (Hybrid)?

    Sign up to receive alerts about other jobs on the Data Warehouse Architect :: Lansing, MI (Hybrid) 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 Ark Solutions

    Ark Solutions
    Hired Organization Address Austin, TX Full Time
    Job Description Job Summary The data entry position will be responsible for transferring data from one source to another...
    Ark Solutions
    Hired Organization Address Columbia, SC Full Time
    Ark Solutions Inc is looking for Senior User Support Specialist / User Trainer! Position : Senior User Support Specialis...
    Ark Solutions
    Hired Organization Address Bethesda, MD Contractor
    Title: DDI/DNS Engineer (Route53) Location: - 100% Remote JOB SUMMARY: The Engineer for DDI will be part of Network Site...
    Ark Solutions
    Hired Organization Address Shawano, WI Full Time
    Position: Maintenance Supervisor Location: Shawano, WI (Onsite) Job Type: Full Time Job Description: Position summary: T...

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

    Data Warehouse Architect - Lansing, MI

    Digital Technology Solutions, Lansing, MI

    Data Warehouse Architect 5 || Hybrid in Lansing MI

    InfiCare Technologies, Lansing, MI

    AI Assistant is available now!

    Feel free to start your new journey!