Data Warehouse Architect

Job Duties
<\/h2>

<\/div>

• Defines the technical planning, implementation plan, and delivery of the EDW platform services and supporting technologies to meet the State of Michigan’s business requirements and objectives. 
  <\/span><\/li>
• Vendor communication, trouble reporting, escalated troubleshooting, and release/patch management.
  <\/span><\/li>
• Responsible for providing operating system guidance along with EDW security expertise for the systems as well as advising the Agencies on disaster recovery planning strategies related to the EDW and their business applications.
  <\/span><\/li>
• Responsible for platform performance monitoring and resolving performance issues.
  <\/span><\/li>
• Provides direct technical expertise to department DBAs and specialists across the enterprise
  <\/span><\/li><\/ul>
  
  <\/div>

  
  <\/div>

  
  <\/div><\/span>
  

  Requirements<\/h3>

  8+ years:
  <\/div>

  
  <\/div>

  • Teradata database
    <\/span><\/li>
  • Upgrades, provisioning, software maintenance, scripting – BASH, Perl, Python, Glink
    <\/span><\/li>
  • Teradata ecosystem health monitoring
    <\/span><\/li>
  • Teradata node management
    <\/span><\/li>
  • Teradata Viewpoint administration
    <\/span><\/li>
  • Teradata Tools and Utilities (TTU)
    <\/span><\/li>
  • PSIM (Platform Service Intelligent Monitoring) administration
    <\/span><\/li>
  • Teradata vendor upgrades
    <\/span><\/li>
  • Teradata workload management
    <\/span><\/li>
  • Teradata backup & recovery
    <\/span><\/li>
  • Performance tuning and resource optimization
    <\/span><\/li>
  • Extract Transform Load (ETL)
    <\/span><\/li>
  • Unix/Linux knowledge
    <\/span><\/li>
  • Cloud computing fundamentals, resource allocation, networking, preferably MS Azure
    <\/span><\/li>
  • Statistics
    <\/span><\/li>
  • Audits & security plans
    <\/span><\/li>
  • Federal requirements – NIST 800 -53, IRS Pub 1075, SSA, Medicaid, etc<\/span>
    <\/li><\/ul>
    
    <\/div>

    Minimum Education
    <\/h2>

    • None<\/span>
      <\/li><\/ul>
      <\/span>
      <\/div>

      Location
      <\/h2>

      • Local candidates ONLY<\/b>. Candidates must be located in Michigan within 1 hour of Lansing, MI at time of submission.<\/span>
        <\/li>
      • Position is a hybrid schedule with NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. (Required onsite days are currently Tuesdays and Wednesdays but this is subject to change.)<\/span><\/span>
        <\/li>
      • Working hours Monday -Friday, approximately 8:00 a.m. to 4:30 p.m.<\/span><\/span><\/span>
        <\/li><\/ul>

        Additional Requirements
        <\/h2>

        • Must be authorized to work in the United States; We are unable to offer sponsorships at this time<\/b><\/span>
          <\/span><\/li>
        • Must undergo a background check and drug screening for employment.<\/span>
          <\/li><\/ul>
          
          <\/div>

          Employment Terms
          <\/h2>

          • This is a W2 position<\/span>
            <\/li>
          • 40 hrs per week<\/span>
            <\/li>
          • <\/span>HYBRID schedule - NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. (Required onsite days are currently Tuesdays and Wednesdays but this is subject to change.)
            <\/li><\/ul>
            
            <\/div>

            About Zenfreed
            <\/h2>

            
            <\/div>

            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.
            <\/div>

            
            <\/div>

            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.
            <\/div>

            
            <\/div><\/div><\/div>

            
            <\/div><\/span>
            

            Benefits<\/h3>

            We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverage options for all employees. 
            <\/div><\/span>