Analytics Engineer

Analytics Engineer (Hybrid)

FLSA Classification: Exempt

Salary Range: $120,000 – $135,000 plus bonus and incentive stock options

Reports to: Sr. Manager, Data Analytics

Location: New York City (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

We are seeking an experienced Analytics Engineer to design, develop, and maintain large-scale data applications and pipelines, working closely with the Sr. Manager, Data Analytics and Data team to improve NineDot’s business through smarter use of data. This role will be highly technical and hands-on. Your role would involve managing and optimizing data related to various aspects of renewable energy generation, distribution, and consumption. You would be responsible for designing and implementing dashboards and other analytical tools, ensuring data quality, and utilizing appropriate technologies to extract valuable insights from the data.

Responsibilities

• Process and analyze internal data to meet business needs.
• Work closely with project development, operations, and finance groups within NineDot to understand our data pipelines and improve upon our data structures and processes.
• Build data models and ensure they are scalable and optimized for performance.
• Implement data quality checks and validation processes.
• Develop and maintain data documentation including data dictionaries, data lineage and metadata.
• Translate needs of the team into actionable analyses.
• Develop and maintain dashboards, reports, and visualizations within BI tooling to provide actionable insights using NineDot’s data.
• Build tooling that can support replicable internal analyses.
• Assist teams in conceptualizing and creating reports and visualizations.
• Assist in the Integration of data from outside platforms using APIs into NineDot’s internal data platforms.

Competencies for Success

• Problem Solving – Uses rigorous logic and methods to solve difficult problems with effective solutions; conducts excellent and honest analysis; looks beyond the obvious and doesn’t stop at the first answer.
• Interpersonal Savvy – Able to relate well to all individuals within and beyond the organization; builds appropriate rapport along with constructive and effective relationships; uses diplomacy and tact.
• Perseverance – Pursues everything with energy, drive, and a need to finish; seldom gives up before finishing, especially in the face of resistance or setbacks.
• Dealing With Ambiguity – Can effectively cope with change and shift gears comfortably; can decide and act without having the total picture.
• Creativity – Capable of coming up with new and unique ideas; easily makes connections among previously unrelated notions.
• Technical Learning – Picks up on technical things quickly, capable of learning new skills and knowledge, good at learning new industry, company, product, or technical knowledge.
• Intellectual Horsepower – Demonstrated ability to deal with concepts and complexity comfortably; described as intellectually sharp, capable, and agile.

Requirements

• Bachelor’s degree in Math, Statistics, Economics, Engineering, Computer Science or related field.
• 5+ years of data engineering, programming, or related experience.
• Demonstrated experience understanding user needs and delivering maintainable solutions
• Advanced experience with data visualization and analytics tools (e.g., Metabase, Tableau, Power BI, Looker).
• 5 years of experience writing queries and pipelines in SQL and/or dbt
• Coding experience in one or more of the following languages: Python, Java, Ruby, Javascript.
• Experience with cloud platforms like Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP).
• Experience with data integration, including using APIs, and ETL tools.
• Advanced knowledge of algorithms, data structures, and relational algebra
• Database management experience with PostgreSQL, RDS, Snowflake, Redshift, or BigQuery.
• Strong written and verbal communication skills.

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

Affirmative Action/EEO statement

We are proud to be an Equal Opportunity/Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate on the basis of race, color, national origin, religion, gender expression, gender identity, sex, age, ancestry, marital status, protected veteran and military status, disability, medical condition, sexual orientation, genetic information, or any other status of an individual or that individual’s associates or relatives that is protected under applicable federal, state, or local law.