To Apply for this Job Click Here
IDR is seeking a Database Warehouse Architect to join one of our top clients for a remote opportunity. In this role, you’ll lead the target-state data architecture supporting a major enterprise modernization, ensuring reporting and analytics remain reliable throughout a multi-year transformation. You’ll partner with technical teams and business stakeholders to define scalable data flows, governance, security, and long-term supportability in a complex, highly visible environment.
Position Overview for the Database Warehouse Architect:
- Define the target-state architecture connecting enterprise reporting, the institutional data warehouse, data lake services, legacy data sources, and downstream analytics.
- Establish standards for data governance, metadata management, data quality, security, access controls, and historical-data retention.
- Guide integration patterns and warehouse/data-lake design decisions to ensure priority operational and analytical reporting needs are met.
- Lead architecture discussions and alignment across technical teams, vendors, and business stakeholders, maintaining clear documentation and roadmaps.
- Support implementation success through design reviews, validation/testing guidance, deployment readiness, and knowledge transfer to support teams.
Requirements for the Database Warehouse Architect:
- 5+ years of experience designing enterprise data warehouse, data lake, or analytics architectures.
- 5+ years of experience with cloud data platforms, data integration patterns, and enterprise reporting environments.
- 5+ years of experience establishing data governance, metadata, security, and data access practices.
- Experience supporting Workday data/reporting, higher education environments, or large public-sector organizations.
- Strong ability to translate business reporting needs into scalable technical architectures, phased roadmaps, and clear technical documentation.
What’s in it for you?
- Competitive compensation package
- Full Benefits; Medical, Vision, Dental, and more!
- Opportunity to get in with an industry leading organization.
Why IDR?
- 25+ Years of Proven Industry Experience in 4 major markets
- Employee Stock Ownership Program
- Dedicated Engagement Manager who is committed to you and your success.
- Medical, Dental, Vision, and Life Insurance
- ClearlyRated’s Best of Staffing® Client and Talent Award winner 12 years in a row.
#LI-Remote
IDR is an equal opportunity employer. We provide reasonable accommodations for disabled employees and do not discriminate based on race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, criminal history, or any other protected category under applicable federal, state, or local laws. We consider all qualified applicants, including those with criminal histories, in compliance with applicable Fair Chance laws.
To comply with civil rights laws, we invite applicants to voluntarily self-identify their race, ethnicity, gender, and veteran status. This information is confidential, optional, and will not affect your application. You may access this form here.
Pursuant to pay transparency laws, salary ranges and benefits will be disclosed where required by law. Compensation is based on factors such as experience, skills, and qualifications.
If you require a reasonable accommodation during the application or interview process, please contact Human Resources at hr@idr-inc.com

