Data Warehouse Architect :: Lansing, MI (Hybrid)

Data Warehouse Architect

Location: Lansing, MI (Hybrid)

Duration: 3 months

Job Responsibilities:

• Manage Common Batch Framework and Scheduler for reliable data availability.
• Oversee Data Warehouse change management and code promotions.
• Handle Linux security model on DW ETL servers and Teradata security.
• Conduct data architecture reviews to align with enterprise standards.
• Create and maintain detailed documentation of data processes and solutions.
• Support escalated Data Warehouse issue resolution.
• Recommend new data technologies for improved performance.
• Ensure data quality and effective use of enterprise data assets.
• Manage data integration processes across multiple systems.
• Collaborate with external vendors and service providers.
• Support system upgrades, patch management, and maintenance.
• Monitor system performance and troubleshoot technical issues.
• Perform data profiling and implement data quality rules.
• Develop disaster recovery and backup strategies.
• Lead data warehouse process migrations to standardized frameworks.
• Conduct access reviews and user audits for compliance.
• Address audit findings related to data systems and security.

Required Qualifications:

• 8 years Teradata experience.
• Experience with data loading from multiple source systems.
• 5 years of Linux experience.
• Ability to provide training and technical guidance for troubleshooting.
• Proven independent and collaborative working ability.
• Strong decision-making and problem-solving skills.
• Effective communication skills for technical and non-technical stakeholders.

Preferred Qualifications:

• Federal/State/Government experience.
• Experience with cloud-based BI tools.