remote
Database Analyst Co op/Internship - BMO Financial Group
Software Engineer
Co‑op Database Analyst role focused on designing, maintaining, and optimizing data solutions using SQL, ETL processes, and Python. Ideal for students eager to build data pipelines, model relational databases, and support business intelligence initiatives.
About the role
Key Responsibilities
- Design, develop, and maintain SQL databases and data models to support business reporting and analytics.
- Build and optimize ETL pipelines to ingest, transform, and load data from multiple source systems.
- Collaborate with data engineers and business stakeholders to define data requirements and deliver actionable insights.
- Write efficient SQL queries and scripts to extract, cleanse, and analyze data for reporting purposes.
- Assist in performance tuning, indexing, and query optimization to ensure high availability and scalability.
Requirements
- Current enrollment in a Computer Science, Information Systems, or related program.
- Strong knowledge of SQL and relational database concepts.
- Experience with ETL tools or scripting (Python, PowerShell, or similar).
- Familiarity with data modeling techniques and best practices.
- Excellent problem‑solving skills and a collaborative mindset.
Skills
sqldata analysispython