Teradata Data Warehouse Architect 5 Job at Falcon Placement Services LLC, Lansing, MI

eGRNR2RjU01pamVDVm5MWlYvOWVtaXJKQUE9PQ==
  • Falcon Placement Services LLC
  • Lansing, MI

Job Description

Job Opportunity: Data Warehouse Architect 5 Local Candidates Only

White Lotus Talent Partner is actively seeking an experienced Data Warehouse Architect 5 to support the State of Michigan Department of Health and Human Services (MDHHS) . This role requires expertise in Teradata, SQL, shell scripting, and Linux to support complex data warehouse structures and security models.

Position Details:
  • Location: Lansing, MI (Hybrid - Onsite 2 days per week required)

  • Duration: 1 Year (with possible extension)

  • Interview Process: Virtual interviews; second round may be onsite in Lansing, MI

Top Skills & Experience Required:
  • 12+ years of Teradata experience

  • 10+ years of SQL experience

  • 10+ years of shell scripting experience

  • 5+ years of Linux experience

  • Experience supporting State of Michigan MDHHS Data Warehouses or another State of Michigan Agency Data Warehouse

  • Proven ability to work independently within a collaborative team

Key Responsibilities:
  • Manage Linux security models and authorize user access.

  • Oversee Teradata security and access.

  • Maintain Common Batch Framework and Common Scheduler for accurate data availability.

  • Handle Data Warehouse change management and code promotions.

  • Migrate multiple MDHHS Data Warehouses to Common Processes.

  • Ensure adherence to State of Michigan policies and procedures .

  • Conduct elevated access and user audits.

  • Mitigate audit findings and provide input to SSPs.

  • Perform Data Warehouse Continuity Planning and testing.

  • Provide support for escalated Data Warehouse troubleshooting and resolution.

  • Support data loading from multiple source systems.

  • Train and guide development teams to enhance batch troubleshooting and support.

  • Make informed decisions in alignment with State of Michigan and MDHHS/DTMB policies .

Additional Information:
  • Local candidates only Hiring manager is not considering relocation candidates.

  • No remote-only option Onsite presence in Lansing, MI (2 days per week) is required.

  • Security & Compliance Government-issued equipment must remain within the United States.

Application Process:

If you meet the qualifications and are interested in this opportunity, please submit your updated resume noman.m@falconpls.com

If this role isn't the right fit for you, kindly share this job posting within your network or refer someone who may be interested!

We look forward to your applications!

Job Tags

Local area, Remote job, Relocation, 2 days per week,

Similar Jobs

BL Companies

Fire Protection & Plumbing Designer Job at BL Companies

Fire Protection & Plumbing Designer Our continued growth offers a Fire Protection Engineer in our Mechanical Electrical and Plumbing group. This role requires expertise in analyzing and designing new fire protection systems. The successful candidate will work independently...

Leavitt Group

Risk Advisor Job at Leavitt Group

 ...abilities, get excited by uncapped earnings potential, and want to be in a stable industry, this opportunity is for you. As a Risk Advisor, you will have the opportunity to build lifelong relationships with C suite level individuals and business owners while helping... 

CalOpps

Correctional Officer & Correctional Officer Lateral Job at CalOpps

 ...be currently employed with an adult county, state, or federal correctional institution.The Yuba County Sheriffs Department is currently...  ...an eligibility list for the classification of Correctional Officer. Under continuing supervision incumbents perform a wide... 

Mission Restoration

Receptionist Job at Mission Restoration

 ..., we uphold high standards of quality, integrity, and presence. Role Description This is a full-time on-site role for a Receptionist based in Mesa, AZ. The Receptionist will be responsible for managing incoming phone calls, greeting clients and visitors, performing... 

Sanford Health

Respiratory Therapist - Inpatient Respiratory Therapy - Full Time Job at Sanford Health

 ...nearly 50,000 members of the Sanford Family who are dedicated to the work of health and healing across our broad footprint. Facility:...  ...benefits, and a generous time off package to maintain a healthy home-work balance. For more information about Total Rewards, visit ....