Data Scientist
Role details
Job location
Tech stack
Job description
This role is the firm's go-to person for office data and AI-driven tools. You'll manage our Google Sheets-based tracking systems, lead our applied-AI initiatives (including AI-assisted drafting workflows), and keep our data clean, organized, and reliable across the practice. You'll also help maintain our PostgreSQL database and support light automation of recurring office tasks. You'll work directly with attorneys and analysts, turning everyday business needs into simple, dependable tools. Deeper software engineering work (application development, cloud infrastructure, legacy system migration) is part of the role but is not the main day-to-day focus - strong candidates without that background are still encouraged to apply., * Google Sheets and office data management - Own and maintain the firm's Google Sheets-based tracking and reporting tools; keep data accurate, organized, and properly access-controlled.
- AI project ownership - Lead our applied-AI initiatives, including AI-assisted document drafting; manage prompting, review, and quality control of AI-generated output.
- Data management - Organize, clean, and maintain data across our systems; run recurring data refreshes and produce ad hoc reports and extracts for attorneys and operations.
- Light automation - Build simple scripts or tools to cut down on repetitive manual work (data entry, document generation, email tasks, and similar).
- Database support - Help maintain our PostgreSQL database: routine updates, data-quality checks, and basic troubleshooting.
- Stakeholder collaboration - Work with attorneys, analysts, and operations staff to understand what they need and deliver practical, easy-to-use solutions.
Requirements
- Experience managing Google Sheets (or similar spreadsheet systems) for a team or office, including data accuracy and access control.
- Hands-on experience using AI tools (e.g., ChatGPT, Claude, or similar) for real business or drafting tasks.
- Strong general data management skills - organizing, cleaning, and maintaining data so it stays reliable over time.
- Basic to intermediate Python and/or SQL skills for automating routine tasks.
- Comfort working in a Windows-based office environment.
- Ability to work independently, handle sensitive data responsibly, and communicate clearly with non-technical attorneys and staff.
- Strong attention to detail in deadline-sensitive work.
- Available to start immediately.
Preferred Qualifications
- Experience with PostgreSQL or a comparable relational database, including schema design, backups, and recovery.
- Experience building or maintaining web applications, internal tools, or APIs (e.g., Django or similar).
- Experience migrating legacy systems (e.g., FoxPro/dBase) to a modern database.
- Experience with cloud platforms (Azure, AWS, or similar), Docker, or CI/CD.
- Experience with more advanced AI/LLM work: prompt engineering, RAG, fine-tuning, or model evaluation.
- Experience with OCR, PDF processing, or Microsoft Office document automation.
- Experience with web scraping or working with NYC government or other public data sources.
- Background in data analysis or statistics (pandas, R, or similar).
- Exposure to property tax, real estate, legal, regulatory, or government workflows.
Benefits & conditions
Pulled from the full job description
- Health insurance
- Retirement plan
- Paid time off
- Vision insurance
- Health savings account
- Dental insurance
- Flexible spending account, * Dental insurance
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Retirement plan
- Vision insurance