Deep Sync aims to develop and maintain data-first technologies that power marketing, measurement, AI, and business intelligence for agencies and brands using a fully deterministic identity graph and privacy-first audiences.
Requirements
- 3+ years experience in SQL Query Design, SQL Performance Tuning and Query Optimization.
- 3+ years of relevant experience in Data Warehouse Design, Data Warehouse Technical Architectures, Development and Implementation.
- 3+ years of relevant experience in ETL Development, ETL Implementation, Unit Testing, Troubleshooting and Support of ETL Processes.
- Proficiency in SQL Query Design and Implementation.
- Strong Experience with Relational Data Warehouse Systems.
- Data Warehouse Management Systems.
- Optimization by Indexing, Partitioning and Denormalization.
Responsibilities
- Design, implement, and maintain scalable data pipelines to collect, process, and store data from various sources.
- Ensure data quality, accuracy, and consistency throughout the pipeline.
- Work closely with cross-functional teams to integrate data from diverse sources, including databases, APIs, and external data providers.
- Develop and maintain ETL processes to transform and enrich raw data into actionable insights.
- Monitor and optimize the performance of data pipelines and databases to meet business requirements.
- Identify and resolve bottlenecks and performance issues.
- Build and optimize data sets, ‘big data’ data pipelines and architecture.
Other
- In-office presence for the first six months.
- Hybrid schedule available after six months: typically remote on Mondays and Fridays, with in-office presence Tuesday through Thursday.
- Candidates must reside in one of the following states: California, Colorado, Florida, Georgia, Missouri, New York, Oregon, South Carolina, Tennessee, Texas, and Washington.
- Not accepting relocation candidates at this time.
- Commuting from an unregistered state is not permitted.
