What are the responsibilities and job description for the Data Warehouse Architect 5 - Lansing, MI (Locals Only) position at Shiro Technologies?
We are seeking a senior Data Warehouse Architect with extensive Teradata expertise to support a large enterprise Data Warehouse environment. The ideal candidate will be responsible for data warehouse architecture, ETL support, security, batch scheduling, change management, and overall platform stability while collaborating with development teams and stakeholders.
Key Responsibilities
Manage and support enterprise Data Warehouse architecture and operations.
Administer Common Batch Framework and Common Scheduler to ensure reliable data availability.
Oversee Data Warehouse change management, code promotions, and DDL deployments.
Manage Linux security models on ETL servers, including user access and security authorization.
Administer Teradata security and access controls.
Perform data architecture reviews, audits, and maintain technical documentation.
Troubleshoot and resolve complex Data Warehouse production issues.
Evaluate and recommend new data technologies to improve scalability and performance.
Ensure data quality, profiling, cleansing, and standardization across enterprise systems.
Support ETL processes and data integration from multiple source systems.
Monitor system performance, perform maintenance, upgrades, and disaster recovery planning.
Lead migration of Data Warehouse processes to standardized frameworks.
Conduct access reviews, security audits, and remediate audit findings.
Required Skills
8 years of Teradata experience (Must Have)
Experience loading data from multiple source systems.
Ability to provide technical guidance and production support to development teams.
Minimum 5 years of Linux experience.
Strong troubleshooting, analytical, and problem-solving skills.
Excellent communication and collaboration skills.
Ability to work independently as well as within cross-functional teams.
Preferred Skills
Government or State project experience.
Experience with cloud-based BI tools.
Experience with AWS, Azure, or Google Cloud Platform.
Additional Information
Established and collaborative team environment.
Opportunity to support a large-scale enterprise Data Warehouse serving multiple business domains.
Senior-level role requiring immediate contribution and leadership.