JOB OVERVIEW:

APTIM’s Energy Transition team is seeking an experienced Business Systems Analyst who will be responsible for managing and continuously improving data-driven reporting, conducting data analysis in support of strategic projects, and reporting across multiple programs in APTIM’s Energy Transition team. The successful candidate will collaborate with program management staff to identify areas for improvement and deliver work on committed timelines. The position may be up levelled to a Senior Business Systems Analyst, depending on the experience of the successful candidate.
APTIM’s Energy Transition team is a recognized leader in the marketplace. Our technical experts deliver highly innovative projects and complex client solutions providing the full breadth of energy solutions including energy management, carbon management, smart energy infrastructure, distributed energy resources (DER), and carbon-free mobility solutions. Our consultants proactively collaborate with clients to define and implement strategies and campaigns around key business drivers, with the primary focus of finding and delivering high-impact projects exceeding expectations and meeting the unique needs for our clients.

BASIC QUALIFICATIONS:

• Bachelor’s degree from an accredited college or university or equivalent work experience.
• High degree of proficiency with business intelligence tools and databases.
• 1+ year utilizing a Microsoft Dynamics-based software solution.Proficient in Microsoft Office software
• 
  
• Excel, Word, PowerPoint, Outlook, SharePoint, Power BI.

• Able to manage competing priorities and tight deadlines.
• Strong written and oral communication skills and experience with client engagement and coordination.
• Strong quantitative and analytic capabilities including memorandum writing and spreadsheet analysis.
• Proven experience developing and maintaining relationships with internal colleagues and external stakeholders.
• Must be a self-starter, organized and have an ability to manage competing priorities with established deadlines.
• Ability to work independently and within a team environment while interact with individuals at all levels of the organization.

DESIRED/PREFERRED QUALIFICATIONS:

• One or more years’ energy efficiency and DSM program experience
• Understanding of energy efficiency technologies and energy-saving solutions including, lighting, HVAC and mechanical systems

• In consultation with program staff, develop a vision and plan for long term improvement of program tracking and reporting system.
• Work with management to identify opportunities for efficiencies and improvements within Microsoft Dynamics and Power BI systems and reports.
• Management, continuous improvement, and optimization of program tracking system, databases, and program reporting/analysis in collaboration with program staff.
• Working with internal IT resources and external IT vendors, manage system improvement and program reporting/analysis in collaboration upgrade projects on behalf of program managers.
• Ongoing assurance of end-to-end data integrity, security and accessibility supporting energy programs.
• Regular and ad-hoc analysis on program data and KPIs.
• Regular and ad-hoc analysis of market, demographic and other industry data in support of program development, innovation, and sales.
• Development of dynamic program dashboards and regular, pre-defined reports.
• Regularly evaluate program data to find trends, insights, risks, and opportunities.
• Interface with software developers: communicate requirements and manage requests.
• Conduct QA/QC of program processes and protocols related to data and reporting, offering improvements and recommendations.
• Support business development efforts by specifying system requirements and costs for new work.
• Support new program startups buy configuring software for new scopes of work.
• Commitment to fostering a collaborative work environment within the team and broader organization.
• All other duties as assigned.
• Ensuring compliance with all APTIM quality and safety policies as well as all OSHA regulations.