Data Solutions Analyst

FLSA Classification: Exempt

Salary Range: $120,000 - $130,000 plus bonus and incentive stock options

Reports to: Director, Data & Technology

Location: Brooklyn, NY (Hybrid)

About The Company:

NineDot's name derives from the classic mathematical puzzle for sparking out-of-the-box solutions. As a leading community-scale, clean energy developer with a growing portfolio of projects across a range of technologies, NineDot Energy is creating innovative energy solutions that support a more resilient electric grid, deliver economic savings, address environmental justice and reduce carbon emissions. We plan to develop, build and operate more than 400 MW of clean energy systems by 2026 that will strengthen the local power grid infrastructure and provide clean, reliable and resilient power to tens of thousands of New York households and businesses. This is all in support of New York State’s mission to achieve 100% clean energy by 2040.

With the backing of Manulife Investment Management and The Carlyle Group - two of the world’s leading infrastructure investors - NineDot is continuing to expand its core battery energy storage pipeline, deliver enhanced products and services, explore new regions and consider potential acquisitions all to advance the decarbonization of New York’s grid. This is an exciting opportunity to build a platform from the ground-up with a world-class team of developers and innovators. NineDot is committed to building a company that exemplifies diversity, equity and inclusion values in its team culture, as well as business practices and community engagement.

Job Summary

Our Data & Technology team is looking to hire a Data Solutions Analyst to strengthen our team’s ability to design, structure, and optimize data across NineDot. This role bridges technical programming and user-centered solution design — combining database structuring and automation with the ability to build intuitive, scalable systems in Airtable and related tools.

The ideal candidate will have a solid foundation in SQL and Python, along with hands-on experience building data structures, automations, and scripts in Airtable. This role is highly collaborative, supporting internal teams by gathering requirements, creating efficient data models, and ensuring our systems seamlessly integrate with the data warehouse and business intelligence tools.

Responsibilities

• Partner with internal stakeholders to gather requirements, understand workflows, and translate business needs into structured, reliable data solutions.
• Design, build, and maintain Airtable bases and interfaces, ensuring they are scalable, intuitive, and optimized for cross-team use.
• Develop and refine Airtable automations and scripts to support business users’ daily work.
• Develop requirements for integrations with external systems (e.g., Procore, SAP, contracting tools).
• Write and maintain Python and SQL scripts to clean and , transform datasets into order to send marts-level data into a BI Tool.
• Identify opportunities to streamline processes and automate workflows, balancing front-end usability with backend reliability.
• Document data structures, logic, and workflows to ensure clarity and knowledge sharing across teams.
• Collaborate with technical teammates to review code, troubleshoot issues, and improve data integrations as needed.
• Perform other duties as assigned.

Core Competencies:

• Collaborates - Building partnerships and working collaboratively with others to meet shared objectives.
• Drives Results - Constantly achieving results, even under tough circumstances.
• Interpersonal Savvy - Relating openly and comfortably with diverse groups of people.
• Manages Ambiguity - Operating effectively, even when things are not certain or the way forward is not clear.
• Nimble Learning - Actively learning through experimentation when tackling new problems, using both success and failures as learning fodder
• Plans and Aligns - Planning and prioritizing work to meet commitments aligned with organizational goals.
• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.

Required Education and Experience

• 3+ years of experience in data structuring, solutions engineering, or related roles (e.g., data analyst, 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 (CS degree not required).
• 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.

Preferred Experience

• Broader experience with database systems and integrations beyond Airtable.
• Familiarity with workflow automation tools, APIs, and system integrations.
• Experience collaborating with data engineers or software developers to review and maintain code quality.
• Understanding of data architecture to support BI tools and analytics pipelines.

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

At NineDot Energy, we believe diverse perspectives drive innovation and are the foundation of our success. As such, we do not discriminate on the basis of race, color, national origin, religion, gender expression, gender identity, age, or any other status of an individual or that individual’s associates or relatives that is protected under applicable federal, state, or local law.

 If you're passionate about this role but don’t meet every qualification listed, we still encourage you to apply. You may be the right candidate for this or other opportunities with us. We’re committed to building a team that reflects a broad range of experiences, backgrounds, and skills.

NineDot Employee benefits include but are not limited to:

• Medical, dental and vision coverage
• 5% employer match on your 401k retirement account
• 20 paid vacation days off, plus 7 sick days, 9 federal holidays and 3 personal floating holidays
• 12 weeks of 100% paid parental leave for both the primary and secondary caregiver within the first year of birth or adoption
• Wellness initiatives including a $1,000 stipend
• 16 volunteer hours plus two planned company-wide volunteer outings per year