You must be able to commute to the office 4 times a week and 1 day WFH.
Our Client is seeking a Sr. Data Analyst who can use data pulled from front-end and back-end platforms to provide meaningful insights that drive informed business decisions. This role requires working directly with the business function to understand its importance, pulling data, developing KPIs/Metrics, and delivering insights that drive business changes.
QUALIFICATIONS
General Knowledge and Skills:
- Bachelor’s degree in Data Analytics, Computer Science, or Business is preferred.
- 5+ years of experience in an analyst role. Industry experience in PPA/leases and/or loans is preferred.
- Strong written and oral communication skills.
- Comfortable working in a fast-paced environment.
- Business performance analysis and data analytics experience, including variance analysis of financial results, budgets, and operations; KPIs and servicing business.
- Skilled in managing large data sets and translating them into desired information & solutions.
- Review of periodic financial statements.
- Ability to independently manage multiple tasks and lead improvement projects/initiatives.
- Experience in distributed energy, solar, and/or retail power is preferred.
Technical Skills:
- Advanced working skill set with Power BI (DAX functions, table relationships, data types) – Required.
- Advanced working skill set with Power Query – Required.
- Advanced working skill set with MS Excel (xlookup, index, pivot tables, conditional functions) – Required.
- Proficiency with SQL, Data Warehouses, and other automated reporting – Required.
- Proficiency with Python (Anaconda, Matplotlib, Pandas, etc.) for big data cleansing, ETL process, automation, and analysis/visualization – Highly Preferred.
- Proficiency with Power Automate – Highly Preferred.
Key Responsibilities Include but are Not Limited to:
- Pull data from our Enterprise Data Warehouse using SQL.
- Create dashboards and prepare reports that deliver business insights utilizing Power BI.
- Develop analysis of operational and financial data from various data sources (spreadsheets, SQL database, .csv files, etc.).
- Prepare reports that support data-driven decisions across the organization.
- Ensure on-time reporting to our internal clients.
- Present reports to senior leadership.
- Work with cross-functional teams for system development/enhancements.
- Perform other duties as assigned.
Education
Bachelor’s degree in Data Analytics, Computer Science, or Business is preferred; or an equivalent combination of education and/or work experience is required.