Compliance Intern
Calgary, AB · On-site +1
We are currently seeking a Compliance Intern to join our Market & Trading Compliance team for a ... Experience with Power BI, Python, or SQL is an asset. * Ability to conduct regulatory research and ...
Compliance Intern
Calgary, AB · On-site +1
We are currently seeking a Compliance Intern to join our Market & Trading Compliance team for a ... Experience with Power BI, Python, or SQL is an asset. * Ability to conduct regulatory research and ...
... op/intern term. * Duration: This role is an 8-month position (September 2026 to April 2027) WHAT ... Relational databases, SQL queries. * Python development for process automation. * Project ...
... op/intern term. * Duration: This role is an 8-month position (September 2026 to April 2027) WHAT ... Relational databases, SQL queries. * Python development for process automation. * Project ...
Sql Python Intern information
Is Python and SQL enough to get a job?
For an SQL Python Intern position, proficiency in both Python and SQL is essential, but employers often look for additional skills such as data analysis, problem-solving, and familiarity with tools like databases and version control. Gaining experience through projects, certifications, or coursework can improve job prospects, as these skills are foundational but typically not sufficient alone for many roles.
What are SQL Python Interns?
SQL Python Interns are entry-level professionals or students who assist with database management and data analysis tasks using SQL (Structured Query Language) and Python programming. They typically work under the supervision of experienced data engineers or analysts to help retrieve, process, and analyze data. Their responsibilities may include writing SQL queries, cleaning datasets, automating data workflows with Python, and generating reports. This internship provides hands-on experience in data manipulation, programming, and problem-solving, which are valuable skills for careers in data science and analytics.
What are the big 4 internships?
The 'Big 4' internships typically refer to internship programs offered by the four largest professional services firms: Deloitte, PricewaterhouseCoopers (PwC), Ernst & Young (EY), and KPMG. These firms offer internships in areas such as audit, consulting, tax, and advisory, providing valuable experience for students pursuing careers in finance, accounting, and consulting. For a SQL Python intern, gaining experience at these firms can provide exposure to large-scale data analysis and business solutions.
What jobs can you get with SQL and Python?
Jobs that require SQL and Python include data analyst, data scientist, database administrator, backend developer, and business intelligence analyst. These roles involve data management, analysis, automation, and software development, often requiring proficiency in both programming languages and related tools like SQL databases and Python libraries.
What kinds of projects and tasks can a SQL Python Intern expect to work on during their internship?
As a SQL Python Intern, you can expect to work on tasks such as data cleaning, database querying, and developing scripts to automate data processing. Interns often assist in building and maintaining data pipelines, generating reports, and supporting data analysis for ongoing projects. You'll typically collaborate with data analysts, engineers, and sometimes business stakeholders to ensure data integrity and provide insights that drive decision-making. This role provides hands-on experience with real datasets and gives you the opportunity to learn best practices in both SQL and Python within a collaborative, supportive team environment.
What is the difference between Sql Python Intern vs Data Analyst Intern?
| Aspect | Sql Python Intern | Data Analyst Intern |
|---|---|---|
| Required Skills | Basic SQL, Python scripting, data manipulation | SQL, Python, data visualization, statistical analysis |
| Work Environment | Tech companies, startups, data-driven teams | Business, finance, marketing departments |
| Common Usage | Supporting data projects, database management | Interpreting data, creating reports, insights |
The Sql Python Intern role focuses on supporting data projects through basic SQL and Python scripting, often within tech environments. In contrast, Data Analyst Interns typically perform data interpretation, visualization, and reporting tasks. While both roles require SQL and Python skills, Data Analyst Interns usually have additional knowledge of data visualization tools and statistical methods. Understanding these differences helps candidates choose the role that best aligns with their skills and career goals.
What are the key skills and qualifications needed to thrive as an SQL Python Intern, and why are they important?
To thrive as an SQL Python Intern, you need a solid understanding of relational databases, SQL queries, and foundational programming skills in Python, often supported by coursework or certifications in computer science or related fields. Familiarity with tools like MySQL, PostgreSQL, Jupyter Notebooks, and version control systems such as Git is typically expected. Strong analytical thinking, problem-solving abilities, and effective communication help interns excel in collaborative, data-driven environments. These skills are crucial for efficiently extracting insights from data, contributing to team projects, and supporting business decision-making processes.
What is the salary of Python intern?
The salary of a Python intern varies depending on location, company, and experience, but typically ranges from $15 to $25 per hour or $30,000 to $50,000 annually for full-time positions. Internships often include opportunities to develop skills in Python programming, data analysis, and related tools. Compensation may also depend on whether the internship is paid or unpaid and the duration of the program.
What are the most commonly searched types of Sql Python jobs in Calgary, AB? The most popular types of Sql Python jobs in Calgary, AB are:
What are popular job titles related to Sql Python Intern jobs in Calgary, AB? For Sql Python Intern jobs in Calgary, AB, the most frequently searched job titles are:
What job categories do people searching Sql Python Intern jobs in Calgary, AB look for? The top searched job categories for Sql Python Intern jobs in Calgary, AB are:
Full-time
Posted 10 days ago
Job description
A little about Capital Power
Capital Power (TSX: CPX) is dedicated toPowering Change by Changing Power. This north star guides our ambitions, focus, and actions as we transform our energy system. We're a growth-oriented North American energy company headquartered in Edmonton, Alberta. Our team safely delivers, builds, and creates balanced energy solutions for customers across North America.
Our people are at the core of our journey to deliver reliable, affordable, and lower-carbon power solutions. We provide purpose-driven work in a safe and inclusive environment, and we live by our North Star. With us, your contributions matter - we want you to be empowered to innovate, collaborate, and ultimately drive results. We're here to partner with you so you can learn, grow, and forge a career that's meaningful to you. Join us in powering North America!
Your Opportunity
OneTemporaryFull TimePosition.
We are currently seeking a Compliance Intern to join our Market & Trading Compliance team for a full-time 12-month term. This roleprovides a unique opportunity for a recent graduateto gain hands-on experience supporting compliance activities in wholesale power markets across North America.
Working alongside experienced compliance professionals, traders, and cross-functional teams, the intern will develop a practical understanding of regulatory frameworks governing energy trading, including market conduct rules, reporting obligations, and internal compliance programs.
You will contribute to our team by:
Supporting the monitoring of trading activities andassistinginidentifyingpotential compliance risks across physical and financial power markets.
Supporting special projects and initiatives related to the development of the internal compliance program.
Assistingwith regulatory research and communicating the developments from key regulatory bodies.
Contributing to the development, maintenance, and continuous improvement of compliance policies, procedures, and controls.
Assistingin the preparation of internal reports, documentation, and audit materials.
Supporting compliance training efforts, including preparing materials and coordinating learning sessions.
Collaborating with stakeholders across Trading, Risk, Legal, and Operations.
Assistingin data analysis and validation to support trade surveillance and reporting activities.
What you will bring to the role:
Education:
Bachelor'sDegree inBusiness, Commerce, Finance, Economics, Energy Management, Law, Public Policy, or Regulatory Studies.
Recent graduate or graduating within the last year.
Education equivalency may be considered.
Experience:
Prior internship, co-op, or academic experience in compliance, risk management, energy markets, finance, or regulatory environments is an asset.
Exposure to wholesale electricity or natural gas markets is considered an advantage.
Experience with data analysis, research, or policy development is beneficial.
Technical Skills:
Strong analytical and problem-solving skills.
Proficiencyin Microsoft Office Suite (Excel, PowerPoint, Word, SharePoint).
Experience with Power BI, Python, or SQL is an asset.
Ability to conduct regulatory research and synthesize complex information.
High attention to detail and accuracy.
Social & Interpersonal Skills:
Strong written and verbal communication skills.
Demonstrated integrity and sound judgment.
Collaborative mindset.
Curiosity and eagerness to learn.
Strong organizational skills and ability to manage priorities.
Working Conditions:
Hybrid Office/Work from home positionlocatedin Calgary, with possible very minimal travel to meet business users at Capital Power facilities or other offices.
Standard business hours with some flexibility.
This position will remain open until a suitable candidate is found.
In order tobe considered for this role you must be legally eligible to work inCanada.
The successful candidate for this position will undergo an education verification, referencechecksand criminal recordcheck.
Capital Power employeesthatrefer toa successful candidate for this positionare eligible for a$500Referral Reward!
How To Apply and Next Steps
Capital Power only accepts resumes via online application atwww.capitalpower.com/careers. If you choose to submit your resume by any other means, we cannot guarantee that your application will be considered for vacancies.
Applicants with disabilities who require a reasonable accommodation to complete their application can request accessible formats, communication support, or other accessibility assistance by contactingcareers@capitalpower.com.
Capital Power is committed to providing a fair and transparent hiring process. We recognize and embrace the value of diversity and hire employees with the appropriate skills, experience and knowledge for each position.
Thank you for taking the time to apply and expressing interest in powering a sustainable future with Capital Power! We wish that we could personally respond to everyone who applies; however, it is our practice to contact only those individuals selected for interviews.