Job Description
Junior Financial Analyst Intern - Reporting & Consolidation IPEX is one of the North American leading providers of advanced plastic piping systems. Our mission is to shape a better tomorrow by connecting people with water and energy.We currently have an exciting opportunity as a Junior Financial Analyst Intern. This role is based in our Verdun, Quebec office and reports to the Senior Manager of Consolidation and Reporting.Do not miss the opportunity to join a diverse group of people-centric professionals, thought leaders and rapid thinkers, entrepreneurs in spirit and status quo-fighters!Job SummaryIPEX is currently looking to fill a position of Intern - Junior Financial Analyst - Reporting and Consolidation. Reporting to the Senior Manager of Consolidation and Reporting. This person will participate to Monthly, Quarterly and Annual Reporting, the preparation of individual statutory financial statements for all North America Group companies (multi currencies, multi countries), all within tight deadlines. The incumbent will be also actively supporting any acquisition and integration processes of new acquired companies.KEY RESPONSIBILITES:Assist in the Month-End closing process:Assist in the preparation of Journal Entries (infoflo, SAP and Cognos Controller)Assist in the Update and review Reporting Packages to Parent Company (input data, reconcile and submit) and acts as liaison for all related questionsAssist in the Update and review Working Capital, and ratios calculation (AR, AP, Inventory)Assist in the preparation of monthly analytical reviewHelp with preparation of the Financial statements:Assist in the preparation the individual statutory financial statements for all North America entities and collaborate with the assistance controller upon their completionAssist in research and analysis for in depth follow up of potential financial statement issues and deviations from standardsAcquisition and integration process:Help coordinate with other departments involved to cover key points related to the integrationHelp to ensure compliance to Global requirements and IFRS standardsHelp with the compilation of all required Journal entries and ensure data completeness for the new Reporting PackageParticipate in internal and external audits and ensure compliance with accounting standards and policiesCollaborate with other departments and stakeholders to provide financial information and analysisContribute to process improvement and automation initiatives within the accounting and finance functionsJob Requirements:Education & CertificatesCompleted or currently enrolled in an accounting program and registered in a COOP program at a recognized post-secondary institution pursuing a Bachelors degree in Commerce, Business Administration, Finance, Accounting, CPA and/or MBA or related fieldBilingualism (French and English)Dynamic, innovative thinker with excellent interpersonal and problem-solving skills.Excellent communication skills.A strong understanding of accounting principles and financial statementsProficiency in Microsoft Excel and other accounting softwareExcellent communication, analytical, and problem-solving skillsAttention to detail, accuracy, and timelinessAbility to work independently and as part of a teamTechnical Skills & ExperienceIntermediate/Advanced MS Excel skillsWorking with large data setsSQL (nice to have) - to connect to DatawarehouseCompetenciesProvide insightful reporting to enable effective decision making.Improve & Innovate - Seeking to continuously improve the way we work and looking for new and unique approaches and ideas to achieve better outcomes.Key Relationships:Frequent communication with internal customersCollaborates with peers on a regular basis.IPEX is committed to providing accommodations for people with disabilities throughout the recruitment process and, upon request, will work with qualified job applicants to provide suitable accommodation in a manner that takes into account the applicants accessibility needs due to disability. Accommodation requests are available to candidates taking part in all aspects of the selection process for IPEX jobs. To request an accommodation, please contact HR at HR@ipexna.com#LI-GK1