Analytics Engineer

Terra is a fast-scaling residential solar company seeking an Analytics Engineer to support their analytics and operations functions. The role focuses on delivering accurate reporting and managing data needs across the business, while also collaborating with various teams to ensure timely outputs and improvements in data management processes.

Responsibilities:

• Build and distribute recurring reports covering weekly, monthly, and quarterly metrics — including project throughput, volume, and velocity across regions, states, and municipalities
• Respond to ad hoc reporting requests from leadership and operations teams
• Support dashboard maintenance and updates in BI tools such as Metabase or Tableau using pre-built data models
• Identify manual or spreadsheet-based processes that are candidates for automation or BI tool replacement, and partner with data engineers to prioritize and execute the transition
• Maintain and improve existing Google Sheets and Excel workbooks for operational tracking, reporting, and analysis while actively working to migrate them to scalable, automated solutions
• Perform data entry, cleanup, and formatting tasks to ensure reports and trackers are accurate and up to date
• Assist in maintaining the sales commissions calculator, with a view toward transitioning it to a more automated, auditable process over time
• Partner with data engineers, operations, and sales teams to understand reporting needs and deliver timely outputs
• Coordinate with internal stakeholders to gather inputs, validate data, and distribute reports
• Flag data discrepancies and communicate them to the appropriate teams for resolution
• Assist with ad hoc operational and administrative data tasks as needed in a fast-paced startup environment
• Demonstrate flexibility in taking on assignments outside of core responsibilities as the business evolves

Requirements:

• Strong attention to detail with a track record of producing accurate, clean work
• Highly organized and able to manage multiple requests and deadlines simultaneously
• Comfortable operating with some ambiguity and proactively asking the right questions to move work forward
• A team player who communicates clearly and follows through
• Eager to grow in a fast-scaling company and take on more responsibility over time
• SQL (intermediate or higher)
• Python (intermediate or higher)
• BI tools (Metabase, Tableau, or equivalent)
• Google Sheets
• Excel
• strong attention to detail
• comfort with data and numbers
• Experience in residential solar, utilities, construction, permitting (municipal/HOA/AHJ), or related industries is a plus but not required
• Experience with project management tools (Teamwork, Jira, or similar)
• familiarity with CRM or ERP platforms