Data Warehouse Architect in Lansing MI Hybrid

We are looking for Data Warehouse Architect in Lansing MI Hybrid. Please read the job description below and let me know if you are interested.

Position

Data Warehouse Architect (Teradata)

Location

Lansing, MI (Hybrid – Local Candidates Only)

Duration

Long Term Contract

Interview Process

Virtual

Req ID

163606

Job Description

We are seeking an experienced Data Warehouse Architect 5 to support the Michigan Department. The ideal candidate will have extensive experience with Teradata, Linux, ETL, and enterprise data warehouse environments. This role is responsible for managing data warehouse architecture, security, batch processing, code deployments, ETL workflows, troubleshooting, and ensuring the availability, reliability, and quality of enterprise data supporting critical business operations.

Key Responsibilities

• Design, maintain, and support enterprise Data Warehouse architecture and infrastructure.
• Manage Common Batch Framework and Common Scheduler to ensure reliable data availability.
• Support ETL processes and data loading from multiple source systems.
• Administer Data Warehouse change management, code promotions, and DDL deployments.
• Manage Teradata security, user access, and Linux security structures.
• Provide advanced troubleshooting and technical support for Data Warehouse production issues.
• Conduct data architecture reviews and ensure compliance with enterprise standards.
• Develop and maintain technical documentation for architecture, processes, and solutions.
• Monitor system performance and recommend improvements for scalability and reliability.
• Perform data profiling, validation, cleansing, and quality management activities.
• Support disaster recovery planning, backup strategies, system upgrades, and patch management.
• Collaborate with developers, business stakeholders, vendors, and technical teams.
• Conduct security audits, elevated access reviews, and remediate audit findings.
• Provide technical mentoring, training, and guidance to development teams.

Required Qualifications

• 8+ years of hands-on experience with Teradata (Required).
• Experience supporting data loading from multiple source systems.
• Strong experience with ETL processes and enterprise data integration.
• Minimum 5 years of Linux administration/support experience.
• Experience troubleshooting batch processing and enterprise data warehouse environments.
• Strong understanding of data architecture, security, and change management.
• Excellent analytical, problem-solving, and decision-making skills.
• Ability to work independently as well as collaboratively within cross-functional teams.
• Strong verbal and written communication skills.

Preferred Qualifications

• Previous State of Michigan or government experience.
• Experience with cloud-based BI tools.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Experience supporting enterprise-scale data warehouse modernization initiatives.

Best Regards,

Salman Alam

IT Recruiter||Syntricate Technologies Inc.

Direct

781-236-6328

Email

salman.a@syntricatetechnologies.com