Data Warehouse Architect

About the Role

Our Client is seeking an experienced Data Warehouse Architect to design, build, and maintain robust data warehouse solutions that support critical child welfare and juvenile justice programs. In this role, you will collaborate with cross‑functional teams to translate business requirements into scalable data models, ETL processes, and insightful dashboards. You will play a pivotal role in ensuring data integrity, performance, and security across the organization’s analytics ecosystem. The position offers a hybrid work environment with mandatory on‑site days, allowing you to blend remote collaboration with face‑to‑face engagement with stakeholders. Your expertise will directly impact the effectiveness of data‑driven decision making in public service delivery.

Key Responsibilities

• Design and architect enterprise‑grade data warehouse solutions that meet the needs of child welfare and juvenile justice programs.
• Lead the development of ETL pipelines, data marts, and reporting layers using industry‑standard tools.
• Translate business requirements into logical and physical data models, ensuring scalability and maintainability.
• Collaborate with business analysts, data scientists, and IT teams to define data quality standards and governance policies.
• Optimize query performance and data storage to support real‑time analytics and reporting.
• Develop and maintain dashboards and BI reports that provide actionable insights to program managers.
• Document architecture designs, data flows, and system configurations for audit and compliance purposes.
• Provide technical guidance and mentorship to junior developers and analysts.
• Ensure compliance with data security, privacy, and regulatory requirements specific to our client data.
• Participate in on‑site meetings on Wednesdays and Thursdays to align with project milestones.

Required Skills & Experience

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field (or equivalent work experience).
• Minimum of 6 years of hands‑on experience designing and building data warehouse and BI solutions, including ETL development, data mart creation, and dashboard/report generation.
• At least 2 years of experience working within child welfare, juvenile justice, or related public‑sector programs.
• Strong proficiency in SQL and experience with Teradata Studio or equivalent database tools.
• Demonstrated ability to work independently with minimal supervision, managing multiple priorities in a fast‑paced environment.
• Experience with data modeling, dimensional design, and performance tuning.
• Familiarity with BI platforms such as Power BI, Tableau, or similar.
• Excellent communication skills, both written and verbal, to convey complex technical concepts to non‑technical stakeholders.

Tools & Technologies

• SQL (Teradata, SQL Server, Oracle)
• Teradata Studio
• ETL tools (Informatica, SSIS, Talend, or similar)
• Data modeling tools (ERwin, PowerDesigner, or equivalent)
• BI & dashboard platforms (Power BI, Tableau, QlikView)
• Version control (Git, SVN) and collaboration tools (Microsoft Teams, SharePoint)
• Operating systems: Windows, Linux (basic familiarity)

Work Schedule & Duration

• Contract length: 1 year+ (subject to business needs)
• Hybrid work arrangement: Remote most days with mandatory on‑site presence on Wednesdays and Thursdays each week.
• Location requirement: Candidate must reside within 90 miles of Lansing, Michigan.

Interview Process

The interview process consists of a single virtual round conducted via Microsoft Teams. It will include a mix of technical questions focused on data warehouse architecture, ETL design, and BI development, as well as behavioral questions to assess collaboration and independence. Participants will include the hiring manager, their direct supervisor, and a senior team member.

Position Details

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