Data Analyst

Database Analyst | Trenton, New Jersey | Hybrid

We're working with CAI on this exciting opportunity.

Join CAI, a global technology services firm, as a Database Analyst to elevate their data architecture solutions! If you're passionate about leveraging strong SQL, Python, and AWS database expertise to drive impactful research and enforcement initiatives, this is your chance to make a difference.

The Role

• Develop robust ETL routines within the silver layer of the research data lake

• Collaborate with research scientists to align business use cases in the gold layer

• Integrate new data sources and ensure data hygiene across all layers

• Create pipelines for tracking wage theft violations and WALL implementation

• Implement validation protocols and develop predictive models and BI tools

What You'll Need

• 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

What's On Offer

• Opportunity to shape data architecture for research and enforcement initiatives

• Work with cutting-edge AWS technologies and develop innovative solutions

• Collaborative environment with a focus on impact and continuous improvement

• Be part of a global technology services firm with 40+ years of excellence

Apply via Haystack today!