What are the responsibilities and job description for the Warehouse Architect position at Zenfreed, LLC?
Job Description
Job Description
Job Duties
- 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.
Requirements
12 years :
10 years :
5 years :
Experience supporting one or more State of Michigan Department of Health and Human Services Data Warehouses
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.
Minimum Education
Location
Additional Requirements
Employment Terms
About Zenfreed
At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent.
We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.
Benefits
We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverage options for all employees.