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 using Airtable, SQL, and Python to support internal workflows, data integration, and business intelligence efforts 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 automations and scripts in Airtable to support daily business operations.
- Write and maintain Python and SQL scripts for data cleaning, transformation, and integration with BI tools.
- Identify opportunities to streamline processes and automate workflows while ensuring system reliability.
- Document data structures, logic, and workflows for clarity and knowledge sharing.
- Collaborate with technical team members to review code, troubleshoot issues, and improve data integrations.
Requirements
- A minimum of 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 both primary and secondary caregivers within the first year of birth or adoption
Wellness stipend of $1,000
16 volunteer hours annually plus two 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
Oct 25
General Application
NineDot Energy
Brooklyn
Internship
Dec 29
More jobs in Brooklyn, New York
FP A Manager - EnergyHub
EnergyHub
Brooklyn
Full Time
Nov 1
$150k-160k
Don t see the job you re looking for? Reach out anyway
Air Company
VISA
Brooklyn
Full Time
Dec 3
Don t see the job you re looking for? Reach out anyway
Air Company
VISA
Brooklyn
UNKNOWN
Dec 13