• Data Modeling: Designing a new schema optimized for analytical queries.
• ETL/ELT Pipeline: Building automated pipelines to ingest data from various sources (e.g., operational databases, APIs, logs).
• Data Warehouse Implementation: Setting up the data warehouse using a technology like Snowflake, BigQuery, or Redshift.
• Data Governance: Establishing clear data quality and security standards.

Required Experience:

At least 4+ years of experience in data engineering or data architecture. The freelancer must have a proven track record of designing and implementing production-ready data warehouse solutions.

Required Expertise:

• Expertise in data warehouse technologies (Snowflake, BigQuery, Redshift).
• Mastery of ETL/ELT tools and processes.
• Strong knowledge of SQL and data modeling techniques.
• Experience with cloud platforms (AWS, GCP, or Azure).

Sample Work Required:

Please provide documentation or a case study of a data warehouse project you have previously worked on, including details on the architecture, technologies used, and business impact.

Freelancer Proposal:

The freelancer should submit a comprehensive proposal detailing the proposed data warehouse architecture, the ETL/ELT pipeline design, and the overall project plan and timeline. The proposal must also include a risk assessment.