Home

Direct Client: Data Warehouse Architect 5 - Lansing MI (Hybrid) - Local Only - 12+ Years at Lansing, Michigan, USA
Email: [email protected]
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=2113523&uid=

Job ID: 139308

Job Title: Data Warehouse Architect
5

Location: Lansing MI (Hybrid)

Duration: 12+ months contract

Last date of Submission 01-27-2025

1st round: MS Teams
Interview

2nd round: In-person Interview in Lansing MI Office

Locals to MI Only no relocation
candidates

Short Description:

Top
Skills & Years of Experience Required:

Experience supporting at least one (or more) State of Michigan Department of
Health and Human Services Data Warehouses
Required

Minimum 12 years Teradata experience
Required

Minimum 10 years SQL experience.
Required

Minimum 10 years scripting experience.
Required

Minimum 5 years Linux experienc
e.
Required

Data
Warehouse Architect 5

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

Experience supporting 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 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 State
of Michigan and MDHHS/DTMB policies.

Thanks & Regards
,

Rahul Kumar | Vendor Management || BDM

Accrete Macro Solutions LLC

Number: +1 (319) 382-5568

E-Mail: [email protected]

Website: www.accretemacro.com

--

Keywords: information technology microsoft Idaho Michigan
Direct Client: Data Warehouse Architect 5 - Lansing MI (Hybrid) - Local Only - 12+ Years
[email protected]
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=2113523&uid=
[email protected]
View All
05:45 AM 25-Jan-25


To remove this job post send "job_kill 2113523" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.

Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]


Time Taken: 11

Location: Lansing, Michigan