Junior BI Analyst ( Business Intelligence )

About Metergy Solutions, LLC. (“Metergy”)
As one of North America’s most experienced submetering providers, Metergy Solutions has brought turnkey solutions to clients for over 20 years. Metergy supplies, installs and remotely reads meters to measure individual suite consumption of electricity, water, gas, and thermal energy in multifamily and commercial buildings, and bills and collects the utility consumption. Our innovative Submetering as a Service (SaaS) model generates long-term recurring revenue and has been proven to reduce in-suite energy consumption by an impressive 40%, significantly advancing our clients' decarbonization efforts. This outstanding performance has enabled Metergy to issue green bonds and secure green financing, fueling our sustained growth and creating extraordinary career opportunities for our team. As the #1 submeter provider in the New York and Canadian markets, and one of the largest in North America, Metergy boasts over 850,000 contracted meters, issues more than 2 million utility invoices annually, and employs over 400 dedicated team members. Our successful acquisitions have consistently exceeded expectations, unlocking immense growth potential. Metergy is proudly a portfolio company of Brookfield Infrastructure Partners, one of the world’s largest investors, owners, and operators of infrastructure assets across the utilities, transport, energy, data, and sustainable resources sectors. This partnership provides Metergy with access to substantial capital, infrastructure investment expertise, and a global reach, positioning us for continued success and innovation.
Our Mission  Provide building owners and occupants with accurate and reliable utility consumption data through market-leading expertise in turnkey submetering and billing, while fostering a workplace with inspired team members empowered to do more good. 
Position Summary
The Business Intelligence Analyst will support the Strategy an Analytics team with the execution of detailed analysis and creation of reports, dashboards and visualizations that provide the business with critical information to make informed decisions. The individual will use various tools and techniques to identify trends, patterns, and insights, working with data from various sources,ensuring data quality and integrity, and collaborating with various groups and stakeholders across the business to understand information requirements.

Responsibilities

• Utilize business intelligence and reporting software, database tools, Microsoft Excel, and Office automation to design, build, assess, maintain, improve, and distribute dashboards and reports, combine data, and present accurate information.
• Navigate CRM and other systems to build reporting, ensure consistency and compliance across the departments.
• Develop management monthly KPI’s/reports and BI dashboards for stakeholders across all business functions: technology, operations, field, billing etc.
• Perform in-depth analysis to identify key business risks and opportunities and make recommendations to improve overall profitability.
• Distill complex data and relationships into clear, concise charts and visualizations, support ad hoc data requests and analysis.
• Design data models to extract data from operational databases and transform the data to easily understood business views.
• Gather and process raw data at scale (including writing scripts, web scraping, calling API’s, write SQL queries, etc.)
• Process unstructured data into a form suitable for analysis- then do the analysis.
• Automate manual processes.

Qualifications

• Bachelor’s degree in Comp Sci/ MIS/ Data Analytics/ Math or Statistics (or any analytical/data driven disciplin
• 0-2 years of experience working within business intelligence (Co-op/Internships included)
• Strong SQL experience is a must with knowledge of relational databases, and ability to build and maintain views
• Meticulous attention to detail and commitment to accuracy
• Data driven analytical skills, knowledge and/or experience related to financial analysis
• Excellent problem-solving skills, with a proactive approach to addressing challenges
• Ability to prioritize and adapt to changing demands and deadlines, are essential
• Excellent skills in Excel, MS Suite, JIRA, R/Python, SQL, C#
• Experienced with BI Tools such as Power BI / Tableau / SAP (Power BI Preferred)
• Creativity, relationship building skills and dedication are all highly desirable

Benefits & Perks
• Excellent health coverage and life insurance benefits – no waiting period!• Company-paid Long-Term Disability and Basic Life Coverage• Flexible Spending Account (FSA) options• 401K plan with immediate company match • Generous Paid Time Off Plan plus 10 paid holidays• Summer hours to enjoy the weather• Regular Social events - happy hours, summer & holiday parties, & more
Metergy is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other legally protected status. We strive to create an inclusive and diverse workplace for all.