Database Architect
Job description
Job Title: Database Architect
Job Location: Athens, GA 30602 (Remote) || Local Candidates strongly preferred.Job Type: Contract (Long Term Contract)
Pay Range: $65/hr - $70/hr
Must Have Skills:
Experience designing enterprise data warehouse, data lake, or analytics architectures: 5+ YearsExperience with cloud data platforms, data integration patterns, and enterprise reporting environments: 5+ Years
Experience establishing data governance, metadata, security, and data access practices: 5+ Years
Experience with Workday data and reporting, higher education, or large public-sector environments: 5+ Years
Ability to translate business reporting needs into scalable technical architecture and roadmaps: 5+ Years
Position Summary The Data Warehouse Architect will establish the future-state reporting and analytics architecture for client’s transition to Workday. The role will define how Workday reporting, the institutional data warehouse, data lake services, legacy data, and downstream analytics fit together. Working with information technology and project stakeholders, the Architect will set design standards and document a practical roadmap that supports report redevelopment, reliable data access, and long-term institutional use.
Knowledge, Skills, and Abilities
- Knowledge of enterprise data architecture, data warehousing, and modern data lake patterns
- Knowledge of data governance, data quality, metadata, privacy, and access control principles
- Ability to evaluate integration and data consumption approaches for reliability, scalability, and maintainability
- Strong analytical, documentation, facilitation, and communication skills
- Ability to work across technical teams, reporting teams, vendors, and campus stakeholders
- Ability to balance immediate transition needs with sustainable future-state design
Duties/Responsibilities
Architecture and Strategy (40%)
- Develop the Workday reporting and data warehouse architecture strategy, including data flows, integration patterns, and data consumption approaches.
- Define the target-state data warehouse design and the role of data lake services in supporting reporting and analytics.
- Create architecture documentation, design standards, and a phased technical roadmap for implementation.
- Recommend data governance standards covering ownership, definitions, quality, metadata, access, and appropriate use.
- Develop an approach for retaining and accessing legacy data needed for historical, operational, and analytical reporting.
- Assess architectural options and document assumptions, dependencies, risks, and decisions for project leadership.
- Guide integration and warehouse design decisions and review technical solutions for alignment with the approved architecture.
- Partner with the Feed Engineer and report development team to ensure data structures and feeds support prioritized reporting needs.
- Advise on data quality validation, testing, deployment, and production support approaches.
- Facilitate architecture discussions with business and technical stakeholders and communicate design recommendations clearly.
- Maintain architecture records and transfer knowledge to staff responsible for ongoing operations.
Interested in this role?