Data Solutions Analyst
NineDot EnergyBrooklyn, New York
Full Time
Posted October 30, 2025
$120k - $130k
Apply Now
Application opens on company website
Job Description
A Data Solutions Analyst responsible for designing, building, and optimizing data systems and automations using Airtable, SQL, and Python to support internal teams and ensure seamless data integration and workflows within a clean energy company.
Key Responsibilities
- Gather requirements from internal stakeholders and translate business needs into structured data solutions.
- Design, build, and maintain Airtable bases, automations, and interfaces for cross-team use.
- Develop and refine Airtable automations and scripts to support daily business operations.
- Create requirements for system integrations with external tools such as Procore, SAP, and contracting platforms.
- Write and maintain Python and SQL scripts for data cleaning, transformation, and loading into BI tools.
- Identify opportunities to automate workflows and streamline data processes.
- Document data structures, logic, and workflows for team knowledge sharing.
- Collaborate with technical team members to review code, troubleshoot issues, and improve data integrations.
Requirements
- Three (3) years of experience in data structuring, solutions engineering, or related roles such as data analyst or product developer.
- Proven experience building and managing Airtable bases, including automations, table design, and scripting both within Airtable and via the Airtable API.
- Strong understanding of data structuring, modeling, and optimization principles.
- Proficiency in Python and SQL for building and maintaining data pipelines.
- Experience with data transformation tools such as dbt or SQLMesh.
- Ability to approach data problems analytically, with a background in Math, Data Science, Economics, Computer Science, or related fields.
- Demonstrated ability to translate complex data problems into practical solutions for non-technical users.
- Excellent communication and problem-solving skills, with a balance of technical and user-facing capabilities.
Benefits & Perks
Medical, dental and vision coverage
5% employer match on 401k retirement account
20 paid vacation days off
7 sick days
9 federal holidays
3 personal floating holidays
12 weeks of 100% paid parental leave for primary and secondary caregivers within the first year of birth or adoption
Wellness stipend of $1,000
16 volunteer hours annually
Two planned company-wide volunteer outings per year
Ready to Apply?
Join NineDot Energy and make an impact in renewable energy
Stay Updated on Sustainability Jobs
Get the latest renewable energy jobs and career tips delivered to your inbox.
Job Alerts
Get notified about new sustainability jobs
More at NineDot Energy
More jobs at NineDot Energy
Corporate Accounting Reporting Manager
NineDot Energy
Brooklyn
Full Time
Dec 26
$130k-160k
General Application
NineDot Energy
Brooklyn
Internship
Dec 29
Senior Accountant
NineDot Energy
Brooklyn
Full Time
Jan 1
$110k-120k
More jobs in Brooklyn, New York
Don t see the job you re looking for? Reach out anyway
Air Company
VISA
Brooklyn
UNKNOWN
Dec 13
Office Manager and Executive Assistant
EnergyHub
Brooklyn
Full Time
Jan 30
$70k-80k
Marketing Implementation Coordinator
EnergyHub
Brooklyn
Full Time
Feb 5
$50k-65k