Data Warehouse Architect

About the Role

This role is responsible for designing, building, and maintaining a robust data warehouse that supports critical business intelligence and reporting needs for Our Client. The architect will work in a collaborative, fast‑paced environment, partnering with data engineers, analysts, and business stakeholders to ensure data reliability and accessibility. By establishing best‑practice data models and change‑management processes, the incumbent will enable timely, data‑driven decision making across the organization. The position offers a hybrid work setting with a strong focus on delivering high‑quality data solutions that align with strategic objectives.

Key Responsibilities

• Design and implement scalable data warehouse architecture using Teradata to support enterprise‑wide analytics.
• Develop and maintain the Common Batch Framework and Common Scheduler to ensure timely data ingestion and processing.
• Lead change‑management processes for data warehouse code promotions, including version control, testing, and deployment.
• Collaborate with business users to translate complex data requirements into logical and physical data models.
• Optimize SQL queries and ETL workflows for performance, reliability, and cost efficiency.
• Monitor data quality, troubleshoot data anomalies, and resolve system issues proactively.
• Provide technical guidance and mentorship to junior team members and cross‑functional partners.
• Integrate cloud‑based BI tools (e.g., Power BI, Tableau) to deliver self‑service reporting capabilities.
• Document architecture standards, data lineage, and operational procedures for ongoing maintenance.

Required Skills & Experience

• Minimum 3 years of hands‑on experience with Teradata, including data modeling, SQL development, and performance tuning.
• Strong verbal and written communication skills in English, with the ability to explain technical concepts to both technical and non‑technical audiences.
• Proven ability to work both independently and as part of a collaborative team environment.
• Excellent problem‑solving and analytical skills, especially in diagnosing complex data and system issues.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent practical experience).
• Experience with cloud‑based BI platforms (e.g., Power BI, Tableau, Looker) is preferred.
• Prior experience in a our client or public‑sector environment is a plus but not required.

Tools & Technologies

• Teradata database and utilities for large‑scale data warehousing.
• SQL for data extraction, transformation, and loading (ETL) processes.
• Common Batch Framework and scheduling tools for automated data pipelines.
• Version control systems such as Git for code promotion and change management.
• Cloud‑based Business Intelligence tools (Power BI, Tableau, Looker) for reporting and visualization.
• Data modeling tools (e.g., Erwin, PowerDesigner) to create logical and physical schemas.
• Collaboration platforms (Microsoft Teams, Slack) for virtual coordination.

Work Schedule & Duration

• Contract length: Approximately 1 year (10/20/26 – 09/30/27) with potential extension based on business needs.
• Hybrid work arrangement: 2 on‑site days per week (Wednesday and Thursday) at the Lansing office; remaining days remote.
• Candidates must reside in the Lansing, MI area or be willing to relocate at their own expense from day one.
• Full‑time position with standard business hours.

Interview Process

The interview process consists of two stages. The first round is a virtual interview conducted via a video platform where candidates will share their screen to discuss technical solutions. The second round is an in‑person interview at the Lansing office. Candidates must provide a recent photo for identification, and a vendor representative will be present at the start of the virtual interview to validate the candidate’s identity.

Position Details

• Employment Type: Contract
• Duration: Approximately 12 months (with potential for extension)
• Work Authorization: Must be authorized to work in the United States