Database Architect


StoneGate-Technologies LLC
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Access Control
- SaaS
- Scalability
- Technical Drafting
- Testing
- Public Sector
- Records Management
- Roadmaps
- Warehouse
- Privacy
- Production Support
- Project Management
- Knowledge Transfer
- Legacy Systems
- Meta-data Management
- Higher Education
- IT Architecture
- Information Technology
- Enterprise Resource Planning
- HR Management
- Database
- Database Design
- Documentation
- Data Structure
- Data Warehouse
- Data Warehouse Architecture
- Data Governance
- Data Integration
- Data Lake
- Collaboration
- Communication
- Data Architecture
- Data Flow
- Analytical Skill
- Analytics
- Business Data
- Cloud Computing
- Data Quality
- Facilitation
- Reporting
- Workday
Summary
Position Title Database Architect
Job Location Remote, RM, USA
Estimated Duration (In Months) 6 Work Model Remote
Must have Skills/Attributes Data Warehouse, Database, Design, Security
Shift 8:30 AM - 5:00 PM
Required Skills:
• Experience designing enterprise data warehouse, data lake, or analytics architectures (5 Years)
• Experience 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)
• 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
The client Unified ERP Program is replacing legacy systems for human capital management, financials, and student information with a unified Software as a Service (SaaS) solution. The transition requires to sustain operational and analytical reporting while establishing a future-state data warehouse and integration foundation. The Data Warehouse Architect will provide dedicated expertise for this work, reducing reporting disruption and supporting reliable access to institutional data during and after implementation. The Data Warehouse Architect will establish the future-state reporting and analytics architecture for 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.
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.
Data Governance and Legacy Data Planning (30%)
• 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.
Technical Design and Implementation Guidance (20%)
• 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.
• Stakeholder Collaboration and Knowledge Transfer (10%)
• 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.
Physical Demands
• Work is primarily performed in an office setting, involving extended periods of sitting and computer use. The position may require occasional in-person meetings with project and campus stakeholders.
Impact and Influence
• The position will influence technical decisions across reporting, data integration, and analytics workstreams. It will work closely with project leadership, IT staff, business data owners, vendors, and report developers to establish a coherent architecture and guide implementation choices.
- Dice Id: 91093695
- Position Id: 9146415
- Posted 49 minutes ago
Company Info
About StoneGate-Technologies LLC
With more than 100+ IT Professionals, we have transactions with 30+ clients. We placed professionals, with expertise in fields such as information systems, and IT infrastructure, enabling us to deliver one-stop solutions addressing virtually the full spectrum of technical needs in the industry in the USA.
In terms of the number of IT professionals and the extensiveness of the fields covered, Stone gate Technologies LLC is one of the USA's best providers of technical human resources services.
Intensifying global competition means that power relationships in IT/ITES circles are shifting rapidly. Along with this, USA's IT structure is faced with the need to transform significantly. Our role is to keep up with USA’s ever-changing industry and capture client needs so as to be the fastest in our industry at providing clients with the human resources and best technical services.
The vision of the SGT is to help engineers realize their dreams, provide clients with high-quality services that surpass their expectations, and consequently contribute to a better society for our clients.


