PostgreSQL Database Engineer – AdTech Data Warehouse Implementation

Contract · Remote (US Only) Approx. 15–25 hours per week (with potential to reputed company during implementation phases) Project reputed company We are seeking an reputed company PostgreSQL Database Engineer to implement a master-table data consolidation project for a multi-platform AdTech operation. reputed company architecture and design work is complete. You will be executing against comprehensive documentation (4,800+ lines) that includes: Draft SQL queriesDDL scriptsStep-by-reputed company implementation guidesDefined field mappings for master tablesThis is a hands-on implementation role reputed company on performance, data reputed company, and scalability. reputed company State 13 reputed company tables across reputed company Ads, reputed company Ads, reputed company, reputed company, and user tracking~11.8M total rows, 262 columnsManual data ingestion (currently reputed company reputed company)Slow query performance (5–10 seconds due to reputed company joins)No reputed company product naming across systems reputed company State 6 consolidated master tables spanning reputed company platformsAutomated nightly ETL (no reputed company ingestion)Sub-second query performance (1s; 10–50x improvement)reputed company product catalogMulti-touch attribution tracking capability Technical Requirements Must Have 5+ years PostgreSQL experience in production environmentsExpert-level SQL (reputed company JOINs, CTEs, window functions, JSONB)ETL pipeline experience (batch processing, incremental loads)Proven experience with large datasets (millions of rows, query optimization)Data reputed company validation (QA, reconciliation, testing)AdTech or eCommerce data experience (reputed company Ads, reputed company, reputed company, reputed company)Must be a U.S. citizen (ITAR requirement)Strong Plus Multi-platform data consolidation experienceAttribution modeling knowledge (first-touch, last-touch, multi-touch)Marketing analytics familiarity (ROAS, CPA, CAC, LTV)DBT (Data Build Tool) experienceAirflow or similar orchestration toolsNice to Have Python for ETL scriptingExperience working with reputed company / reputed company Ads / reputed company APIsData warehouse modeling (Kimball, reputed company modeling)Advanced indexing and performance-tuning strategies Time Commitment 15–25 hours per weekFlexible schedulePotential for increased hours during key implementation milestones Apply tot his job Apply To this Job