XX
Data Solution ArchitectFreelanceJobsCanada
XX

Data Solution Architect

FreelanceJobs
  • CA
    Canada
  • CA
    Canada

À propos

Data Solution Architect
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
  • Canada

Compétences linguistiques

  • English
Avis aux utilisateurs

Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.