Job Description – Data Warehouse Architect
ONLY FOR THE LOCAL CANDIDATES - Athens, GA
Accelyst is an innovative AI Consultancy that leverages a unique catalog of industry specific Agents and leading-edge AI platforms to deliver tangible, integrated, secure and ROI-optimized solutions.
We combine deep industry and technical expertise to enable rapid deployment of innovative AI driven capabilities to augment and automate client workflows for employees, customers, prospects, and investors.
Why Accelyst?
Accelyst offers a unique opportunity to help build the next generation of an AI-first consulting organization. We value initiative, accountability, and innovation, providing team members with the freedom to contribute beyond their traditional roles. Our culture is built on respect, integrity, customer success, and teamwork, creating an environment where high performers can grow professionally while helping clients solve complex business challenges through technology and AI.
Data Warehouse Architect
Location: Athens, GA (Local Candidates Preferred)
Work Arrangement: Remote
Employment Type: Contract
Position Summary
We are seeking an experienced Data Warehouse Architect to lead the design and implementation of a future-state reporting and analytics architecture during a large-scale ERP transformation initiative. The successful candidate will define how cloud ERP reporting, enterprise data warehousing, data lake services, legacy data repositories, and downstream analytics platforms integrate to support operational and analytical reporting needs.
This role will partner closely with IT leadership, business stakeholders, reporting teams, and technical resources to establish architecture standards, governance frameworks, and a sustainable roadmap for enterprise data management.
Key Responsibilities
Architecture & Strategy (40%)
- Define enterprise reporting and data warehouse architecture strategy.
- Develop data flow designs, integration patterns, and data consumption models.
- Design the future-state enterprise data warehouse and data lake architecture.
- Create architecture standards, documentation, and implementation roadmaps.
- Establish scalable and maintainable reporting and analytics frameworks.
Data Governance & Legacy Data Planning (30%)
- Define data governance standards, policies, and best practices.
- Establish frameworks for:
- Data ownership
- Business definitions
- Data quality
- Metadata management
- Data security and access controls
- Design approaches for preserving and accessing historical and legacy data.
- Identify project risks, dependencies, assumptions, and architectural decisions.
Technical Design & Implementation Guidance (20%)
- Review and guide integration, reporting, and warehouse designs.
- Ensure solutions align with approved enterprise architecture standards.
- Collaborate with engineering and reporting teams to support business reporting requirements.
- Advise on:
- Data quality validation
- Testing strategies
- Deployment processes
- Production support models
Stakeholder Collaboration & Knowledge Transfer (10%)
- Lead architecture workshops with business and technical teams.
- Communicate technical recommendations to diverse stakeholders.
- Maintain architecture documentation and decision records.
- Transfer knowledge to operational support teams.
Required Skills & Qualifications
Technical Expertise
- Strong knowledge of Enterprise Data Architecture
- Strong knowledge of Data Warehousing Solutions
- Experience with Modern Data Lake Architectures
- Expertise in Data Governance, Data Quality, Metadata Management, Privacy, and Security
- Experience designing scalable data integration and reporting solutions
- Understanding of cloud-based enterprise application ecosystems
Professional Skills
- Strong analytical and problem-solving abilities
- Excellent documentation and technical writing skills
- Strong stakeholder management and facilitation skills
- Ability to work across business, technical, vendor, and leadership teams
- Ability to balance short-term delivery requirements with long-term architectural goals
Preferred Experience
- Experience supporting major ERP transformations
- Experience designing reporting and analytics architectures for cloud-based enterprise platforms
- Experience modernizing legacy reporting and data warehouse environments
- Higher Education industry experience preferred
Education
Bachelor’s Degree in Computer Science, Information Systems, Data Engineering, Information Technology, or a related field preferred.
Experience Required
- 8+ Years of experience in Data Warehousing, Data Architecture, Data Engineering, or Enterprise Reporting Architecture.
- 5+ Years of experience designing enterprise-scale data warehouse and analytics solutions.
- 3+ Years of experience working with cloud-based reporting, analytics, or ERP ecosystems.
Key Skills
- Data Warehouse Architecture
- Data Lake Architecture
- Data Governance
- Data Modeling
- Data Integration
- Enterprise Reporting
- Analytics Platforms
- Metadata Management
- Data Quality Management
- Cloud Data Platforms
- ERP Data Architecture
- Stakeholder Management
- Technical Roadmap Planning
- Legacy Data Modernization
- Enterprise Data Strategy