Developer, Business Intelligence

“Join us in building Careers and shaping Experiences Beyond the Box”

About Us

At Atlantic Packaging, every box tells a story and yours begins here. As a proudly Canadian-owned company with over 80 years of excellence in the corrugated packaging industry with operations within North America (Ontario, Quebec and United States), we’re committed to sustainability, customer excellence and community impact. Since 1945, we’ve supported local jobs and built a legacy of trust with our clients and team members. At Atlantic, your ideas matter, your growth is supported and your work makes a real impact.

The Opportunity

The Developer, Business Intelligence plays a vital role in Atlantic's Technical Services Group, bringing expertise in the Power platform (Power Bi, Power Automate, SharePoint etc.) and its tools. The successful candidate will be tasked with developing and managing BI tools, and transforming raw data into valuable insights presented through engaging dashboards and reports. This role will require frequent collaboration with the various teams across the company.

The incumbent will collaborate with various business users to comprehend their requirements, develop a data warehouse, and create reporting solutions tailored to their needs. The user must follow best practices in data visualization, aligning with the norms set within the larger IT team.

Location: Scarborough, Ontario (hybrid 3 days in office)

What You’ll Do

• Study, analyze and understand business requirements in context to business intelligence and convert them into technical specifications, and determine timeline to accomplish tasks.
• Design intuitive and visually appealing user interfaces for web and mobile applications right the first time.
• Design and map data models to shift raw data into meaningful insights.
• Design, develop, and deploy Power BI scripts and perform efficient detailed analysis.
• Utilize Power BI to build interactive and visually appealing dashboards and reports.
• Create charts and document data with algorithms, parameters, models, and explanations of relations.
• Train new team members.
• Demonstrate ability to prioritize tasks, manage deadlines, and work efficiently in a fast-paced environment, while maintaining a high level of attention to detail and quality in deliverables.
• Represent US businesses to ensure they are incorporated in overall data strategy.
• Identify KPIs with clear objectives and monitor them consistently.
• Analyze previous and current data through reports for better decision making.
• Conduct and maintain data warehouse development.
• Build multi-dimensional data models.
• Develop strong data documentation about algorithms, parameters, models and conduct knowledge sharing sessions as required within the Atlantic’s analytics team.
• Perform detailed analysis on tested and deployed Power BI scripts.
• Run DAX queries and functions in Power BI.
• Perform SQL querying for best results.
• Define and design new systems by analyzing current ETL processes.
• Make essential technical and strategic changes to improve present business intelligence systems and enhance their functioning.
• Identify the requirements and develop custom charts accordingly.

What You'll Bring

• University Degree in Computer Science or Statistics, or related major.
• 5+ years’ experience using Power BI tools and BI systems.
• Expert level skills to use Power Automate and other Power BI tools to build robust reporting.
• Skilled in building rich dashboards, writing DAX expressions, and implementing security.
• Ability to analyze existing tools and databases and provide software solution recommendations.
• Experience with big data architectures and data modeling to efficiently process large volumes of data.
• Comprehensive knowledge of data platform architecture, data modeling, database optimization, data management practices and processes.
• Experience in data governance, data governance tools, ingestion and extraction frameworks, data security, etc.
• Data warehousing experience with cloud platforms like Azure, AWS.
• Expertise in building ELT and ETL data processing on SQL Server and Azure.
• In-depth knowledge of Microsoft Business Intelligence stack like Power Platform (BI, Automate), SSRS, SSIS and SSAS.
• Well versed in programming languages like SAS, R, Python, VBA and Excel.
• Proficient in database management of SQL and NoSQL.
• Ability to work with stakeholders and to assess potential risks.
• Ability to communicate fluently in French would be an asset.
• Frequent travel to various US operations may be required.

What We Offer

• Comprehensive health, dental and vision coverage (dependents included).
• Teamwork-focused culture with sustainability initiatives and social events.
• A culture of appreciation through a point-based recognition.
• Opportunities for advancement and internal movement.
• Education assistance for continuous skill development.
• Academic scholarships for employees’ children.
• Safety equipment and PPE support program.
• Retirement savings and wellness initiatives.
• Employee Assistance Program (EAP).

Inclusion and Accessibility

Atlantic Packaging is committed to fostering an inclusive, accessible and respectful environment for all candidates. If you require accommodation during the hiring process, please contact our Talent Acquisition team—we’re here to support you.

We sincerely thank all applicants for their interest in joining Atlantic Packaging. While we appreciate the time and effort invested, only those selected for an interview will be contacted.

Please note

Candidates who are 18 years or older are required to complete a criminal and background check. Details will be provided through the application process.

Hiring Range

$90,300 - $112,900 per year. A candidate’s experience and knowledge may be factored into the pay a candidate receives for this position. This posting is for an existing vacancy.