THE POSITION: Sr. Data Analyst

Responsible for performing analysis and generating actionable recommendations for improving performance in a leading residential solar energy services company.

Reports to the Business Intelligence Manager and conducts advanced analysis of data to arrive at insights that drive tactical and strategic efforts. The analyst is expected to work closely with the solar asset operations team and the external data service provider to proactively monitor and detect/diagnosis underperforming solar systems.  He/she is also expected to create/automate weekly, monthly and ad hoc reports as well as perform analysis to guide data-driven business decisions.

The ability to dive deep into data to arrive at insights that inform tactical and strategic efforts is required. The role also requires an attention to detail and the aptitude to tell a complete, compelling and actionable story through data and analysis.

Key responsibilities include:

• Generate and maintain reports to track solar system performance on a weekly, monthly, and quarterly basis
• Extract, parse and translate large production data sets into meaningful reports
• Work closely with various data service providers, maintain data quality and maintain/improve automated dispatch system
• Escalate technical support issues to internal and external resources
• Utilize advanced analytics to drive new insights from various data sets and help generate actionable steps for improving solar system performance
• Define, document and calculate Key Performance Indicators (KPIs) and methods for tracking these KPIs for internal and external stakeholders
• Generate and publish reports and visualizations with Power BI and/or other applications to be used by management for informed decision making and tracking performance
• Create and present analysis to upper management and other key internal and external stakeholders
• Assist in identifying and advancing Business Intelligence and Analytical capabilities and functionality thought out the organization
• Performs other duties as assigned

QUALIFICATIONS

• Deep experience with Power BI software
• Proven focus on and experience with generating actionable recommendations through data-driven analysis
• Ability to understand how data maps to business processes and to make recommendations on how to adjust procedures to gain efficiencies, increase quality or improve service
• Ability to communicate clearly and succinctly
• Proven experience with a combination of SQL, SSRS, SSAS, Power BI, Excel
• Ability to write complex SQL queries and work with Sql Server relational databases
• Strong Power Point presentation skills
• Experience with programming languages including Python and R are preferred, but not required
• Experience in data management and data quality concepts, practices and services
• Experience with various file formats (XML, CSV, etc.)
• Outstanding organizational, analytical and facilitation skills.
• Experience with Microsoft Office Suite…Excel, Word and PowerPoint
• Familiarity with Azure Cloud is preferred, but not required
• Experienced with Data Warehouse concepts and practices
• Familiar with ETL and data transfer concepts and capabilities
• Authorized to work in the United States
• Experience in solar industries a plus

EDUCATION

• Minimum of a Bachelor's degree or equivalent in computer science or STEM field

EQUAL OPPORTUNITY EMPLOYER

We value a diverse work environment. Spruce Power is an equal opportunity employer and hires without consideration to race, religion, national origin, age, gender, sexual orientation, marital status, veteran status or disability.