
Data Analytics, Automation Development Intern
Mars
internship
Posted on:
Location Type: Hybrid
Location: Edmonton • Canada
Visit company websiteExplore more
Job Level
About the role
- Support Research & Innovation (RI) initiatives by developing and maintaining Python‑based data analytics tools that enhance the efficiency, accuracy, and reproducibility of laboratory and product‑development workflows.
- Analyze operational, laboratory, and formulation datasets using Python to generate actionable insights that help RI teams make informed scientific and technical decisions.
- Develop and present clear, visually compelling data visualizations and reports to support Analytical Lab trends, formulation outcomes, product performance evaluations, and cross‑functional project reviews.
- Improve data integrity and operational efficiency by managing datasets, standardizing data processes, and building workflow automations that help streamline RI tasks and reporting requirements.
- Use SQL within Databricks to extract, interrogate, and validate corporate master data objects, supporting RI’s analytical modeling, experiment tracking, and formulation‑related data needs.
- Perform advanced Excel‑based analytics—including dataset transformation, scenario analysis, and structured reporting—to support RI and adjacent functions with rapid, flexible insights.
- Work collaboratively with IT (Data Architecture) and RI stakeholders—including Analytical Lab, Formulation, Product Development & Innovation, QFS, and QA—to align on data requirements, integrate new data capabilities, and support cross‑functional technical initiatives.
- Other responsibilities as assigned to support RI’s data analytics, reporting, process optimization, or scientific decision‑support needs.
Requirements
- Educational background: 3rd or 4th year in a related program (Computer Science, Data Science, Statistics, Applied Math, Engineering etc.)
- Strong Python skills (Jupyter/Spyder, Pandas, NumPy, Seaborn, Matplotlib).
- SQL experience
- Proficient with Microsoft Office.
- Nice to have: Azure Databricks experience
- Dashboarding tools (Power BI, Plotly)
- Basic statistics knowledge
Benefits
- Competitive Wages
- Strong commitment to ensure all people are provided with a safe, healthy and respectful environment.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
PythonSQLExceldata analyticsdata visualizationdata managementworkflow automationstatisticsdata transformationdata interrogation
Soft Skills
collaborationcommunicationpresentationanalytical thinkingproblem-solving