About
Job Description
We are seeking an experienced Data Solution Architect to design and implement scalable, secure, and high-performing enterprise data architectures. The candidate will be responsible for translating business requirements into technical solutions that support analytics, reporting, and advanced data initiatives.
• Key Responsibilities:
• Define enterprise data architecture strategy and roadmap.
• Design conceptual, logical, and physical data models.
• Architect data lake, warehouse, or lakehouse solutions.
• Establish governance, security, and compliance frameworks.
• Collaborate with stakeholders and technical teams.
• Ensure performance optimization and scalability.
• Required Skills:
• Strong experience in data architecture and modeling.
• Expertise in ETL/ELT and data integration.
• Experience with cloud platforms (Azure/AWS/GCP).
• Knowledge of data governance and security best practices.
• Strong SQL and analytical skills.
Technical Assessment – Project Assignment (No Solution Required)
Business Scenario:
A mid-sized financial services organization operates across multiple regions. Data currently resides in the following systems:
•
• CRM system (Customer data)
•
• ERP system (Financial transactions)
•
• Excel-based operational reports
•
• Third-party Market Data API
The organization requires a centralized data platform to enable unified reporting, historical analysis (5+ years), executive dashboards, and AI/ML readiness.
Assignment Objectives
1. Design a complete end-to-end enterprise data architecture.
2. Define data ingestion, storage, transformation, and semantic layers.
3. Propose governance, security, and compliance mechanisms.
4. Provide performance optimization and scalability strategy.
5. Design a dimensional data model (Fact & Dimension tables).
Expected Deliverables
• High-level architecture diagram.
• Detailed explanation document (3–5 pages).
• Data model diagram (Conceptual & Dimensional).
• Governance & security framework document.
Evaluation Criteria
• Scalability and future-readiness of architecture.
• Clarity of design and documentation.
• Best practices in data modeling.
• Governance and compliance understanding.
• Practical implementation feasibility.
Contract duration of less than 1 month.
Mandatory skills: ETL Pipeline, Amazon Web Services, SQL, Microsoft Azure, gcp
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.