Job Description

Radiant offers a complete range of industry-leading transportation and warehousing solutions to businesses around the globe by leveraging our extensive network of carrier partners across all modes. Radiant provides customized logistics solutions that create value and increase profitability for our customers.

Radiant Canada is a learning environment in which passion, dedication and a commitment to getting the job done are valued. That's what being on our team is all about. It's where you can gain valuable skills and experience, which also helps Radiant grow. If this sounds like the kind of company you are looking for, we would love to hear from you!

We are currently looking for a

Reporting and Business Intelligence Analyst

to join Radiant and be part of our dynamic team.

CONTRACT FOR 3 MONTHS

HYBRID WORK MODEL: Work in the office at 1280 Courtneypark Drive E, Mississauga every Monday and Wednesday. Work from home Tuesday, Thursday and Fridays.

What You'll Do:

Analyze and summarize customer reporting requirements. Collect, cleanse, and validate data to ensure accuracy. Develop, test, and deliver reports, presenting findings and recommendations to customers. Provide business insights and recommendations to internal and external clients. This includes diagnostic analyses, financial analyses, supply chain network assessments, and ad hoc analyses. Design and develop analytical dashboards and reports using BI tools such as SSRS, SSIS, SSAS, and Power BI. Use SQL Server Management Studio (SSMS) to perform data mining and extraction from corporate data warehouses. Collaborate with the IT department to define business logic for data integration and to support the development of data structures that enable effective reporting and analysis. Develop and maintain standard operating procedures, technical documentation, design specifications, and user manuals for Business Intelligence (BI) solutions. Assist in preparing customer presentations and participate in presentations and demos as required. Design, develop, and maintain invoice statement reports and perform monthly reporting for external customers. Other duties and assignments as required.

What You Bring to the Role:

Minimum 5 years' experience in a Business Intelligence role. Minimum 2 years' experience in business dashboard designs. Experience in Supply Chain Management (Transportation, Warehousing, etc.) is an asset. Understanding of APIs, Electronic Data Interchange (EDI), and integrations with WMS and TMS systems is an asset. Advanced skills in dashboard design tools, such as Microsoft Power BI, Tableau, etc. Experience working with custom visualizations from third-party sources, such as ZoomCharts. Advanced skills with SSRS, SSIS, and SSAS. Proficient in SQL, including writing T-SQL statements, procedures, triggers, and more. Strong knowledge and understanding of relational database concepts and data modelling. Intermediate Python skills to design, develop, and implement programs that automate business processes. Proficient in DAX, MDX, and M Query for creating calculated measures and KPIs in BI solutions. Intermediate proficiency in Excel, with experience using formulas, charts, and pivot tables. Experience with the Microsoft Power Platform (Power Apps, Power Automate) is an asset. Experience with machine learning and data analysis frameworks such as Scikit-learn, SciPy, pandas, XGBoost, LightGBM, and CatBoost, as well as visualization tools like Matplotlib and Seaborn, is considered an asset. Knowledge of Transportation Management Systems (TMS) or Warehouse Management Systems (WMS) is an asset. Experience with the Microsoft Fabric platform is an asset.

The Fine Print:

Radiant is committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Accommodations are available on request for candidates taking part in all aspects of the recruitment and selection process.

We thank all candidates for applying, however, only those candidates selected for an interview will be contacted.

Job Types: Full-time, Fixed term contract

Benefits:

Casual dress Dental care Disability insurance Employee assistance program Extended health care Life insurance Paid time off RRSP match Tuition reimbursement Vision care Wellness program
Application question(s):

You are good to work in the office at 1280 Courtneypark Drive E, Mississauga every Monday and Wednesday. Work from home Tuesday, Thursday and Fridays. Annual Salary Expectations (MUST ANSWER TO BE CONSIDERED)
Experience:

business dashboard designs: 2 years (required) Business Intelligence role: 3 years (required)
Work Location: Hybrid remote in Mississauga, ON L5T 1N6