What are the responsibilities and job description for the Data Warehouse Architect in Lansing MI Hybrid position at Syntricate?
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 of Health and Human Services (MDHHS). 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.
Best Regards,
Salman Alam
IT Recruiter||Syntricate Technologies Inc.
Direct: 781-236-6328
Email: salman.a@syntricatetechnologies.com
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 of Health and Human Services (MDHHS). 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