Data Warehouse Architect 5 Job at IT Engagements, Lansing, MI

QTlRcXZ3eTkyY05Nc1g2VTloQzVHRHZyRWc9PQ==
  • IT Engagements
  • Lansing, MI

Job Description

Greetings from IT Engagements !

IT Engagements is a global staff augmentation firm providing a wide-range of talent on-demand and total workforce solutions. We have an immediate opening for the below position with one of our premium clients.

Role: Data Warehouse Architect 5

Location: Lansing, MI (Onsite 2 days per week)

Roles and 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 MDHHS DWs supporting four MDHHS Program areas to Common Processes.
  • Responsible for DW standards and processes including their adherence to SOM 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:

  • 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.

Regards,
Shashank Jaitly
[email protected]

Job Tags

Immediate start, 2 days per week,

Similar Jobs

Legend Biotech US

Clinical Manufacturing Operations and Sciences Sr. Advanced Specialist, Viral Vector Job at Legend Biotech US

 ...Legend Biotech is a global biotechnology company dedicated to treating, and one day curing, life-threatening diseases. Headquartered in Somerset, New Jersey, we are developing advanced cell therapies across a diverse array of technology platforms, including autologous... 

Benjamin Obdyke Inc.

Digital Media Specialist - VIDEO & DESIGN Job at Benjamin Obdyke Inc.

 ...homes. If this sounds like you, we might have a new home for you. Benjamin Obdyke is seeking a Digital Media Specialist to help bring our products, people, and purpose to life through video and design. This is a hands-on, creative role that blends videography... 

Maania Consultancy Services

Sr. Asset Manager with Secret Clearance Job at Maania Consultancy Services

 ...Skills: Minimum of 6 years of general IT experience At least 4 years of direct IT asset management experience Strong technical knowledge of enterprise IT environments Proficiency in Microsoft Outlook, Word, and Excel Active DoD Secret Security Clearance... 

50065 Heidelberg Materials Midwest Agg, Inc.

Equipment Operator-2 Job at 50065 Heidelberg Materials Midwest Agg, Inc.

 ...Line of Business: Other operate excavator, wheel loader and skid steer. Grease and fuel equipment. Clean up debris and metal. As part of our hiring process, we may use AI-assisted tools to support the screening and evaluation of candidate applications and interviews... 

FocusGroupPanel

Work At Home Data Entry Remote Position Administrative Assistant Job at FocusGroupPanel

 ...Work From Home, Entry Level Data Entry Clerk As A Research Participant We are looking for people who want to work remotely from home. You'll need an Internet connection and a mobile device or computer. We need folks who want to do tasks, micro tasks, work at home...