CAI is looking to implement and maintain cutting-edge data architecture solutions, including working with PostgreSQL and AWS databases, to support impactful research and enforcement initiatives.
Requirements
- 5+ years of experience with SQL and relational DBMS
- Strong experience in ETL and data warehousing
- Proficiency in Python for data manipulation and automation
- Experience with AWS database ecosystem (Glue, Lambda, S3, Athena, Redshift)
- Working knowledge of BI tools and dashboard creation
- PostgreSQL and AWS QuickSight experience
Responsibilities
- Develop ETL routines within the silver layer of the research data lake
- Collaborate with research scientists to align business use cases in the gold layer
- Ensure data hygiene across all layers and document data flows
- Integrate new data sources and maintain transparency in data transformations
- Support business compliance tools and strategic enforcement initiatives
- Create pipelines for tracking wage theft violations and WALL implementation
Other
- Medical, dental, and vision insurance
- 401k retirement account access
- Paid sick leave and/or other paid time off as provided by applicable law
