
Closed
Posted
This project centers on building and refining our Snowflake-based data warehouse so that the business has a single, trusted source of truth ready for downstream analytics. I have the environment up and running; what’s missing is an expert who can design it properly, populate it efficiently, and keep it secure. Key workstreams include: • Data modeling – create and maintain star/snowflake schemas that align with business processes, applying best practices for clustering and partitioning. • Data integration – design robust ELT pipelines (SQL, Snowpipe, Streams & Tasks or the tools you prefer) to ingest data from multiple operational systems and land it in a clean, query-ready state. • Data security management – set up roles, masking policies, and governance controls so that sensitive data remains protected while still being accessible to authorized users. Success will be measured by schema quality, load performance, and passing security audits in our non-prod and prod environments. If you have solid experience delivering similar Snowflake data-warehouse projects, I’d like to hear how you approached them, the scale you worked with, and any tangible outcomes you achieved.
Project ID: 40244371
14 proposals
Remote project
Active 24 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs