1

Data Analyst Python Sql Jobs in Ottawa, ON (NOW HIRING)

Data Analyst

Kanata, ON

CA$60K - CA$70K/yr

Familiarity with Python (data analysis, Pandas, scikit-learn, JSON) is an asset. Qualifications * Bachelor's degree in a related field is preferable, but relevant experience in lieu will be ...

Familiarity with Python (data analysis, Pandas, scikit-learn, JSON) is an asset. Qualifications * Bachelors degree in a related field is preferable, but relevant experience in lieu will be considered.

This is a new role and will require advanced analytical skills, proficiency in SQL and Python, business process insight, and the ability to work collaboratively with data stewards and other ...

Write, validate, troubleshoot, and optimize complex SQL and BigQuery/GCP solutions to support ... Apply automation, Python, JavaScript, AI, conversational analytics, and agent-based technologies ...

Senior SQL Developer

Ottawa, ON · Remote

$95K - $110K/yr

You Have: * 7+ years experience working with MS - SQL data development * Strong experience with ... Bonus points if you have experience with Python and Pyspark * A B.Sc. or equivalent work experience ...

Senior SQL Developer

Ottawa, ON · Remote

$95K - $110K/yr

You Have: * 7+ years experience working with MS - SQL data development * Strong experience with ... Bonus points if you have experience with Python and Pyspark * A B.Sc. or equivalent work experience ...

... using Python/Java/SQL etc. * Proficiencyin big data technologies and tools such as Spark/PySpark ... Factor Analysis, Git Version Control System, Image Recognition Algorithms, Inclusion ...

... using Python/Java/SQL etc. * Proficiencyin big data technologies and tools such as Spark/PySpark ... Factor Analysis, Git Version Control System, Image Recognition Algorithms, Inclusion ...

... Data Science, analytics, or AI/ML. Strong expertise in Data Science, including statistical ... Hands-on experience with modern Data Science tools and technologies, including Python, SQL, Spark ...

... Data Science, analytics, or AI/ML. Strong expertise in Data Science, including statistical ... Hands-on experience with modern Data Science tools and technologies, including Python, SQL, Spark ...

Physics, Computer Science, Stats) * 1-2 years' experience developing solutions and working with Python * Confident extracting and manipulating data from SQL and noSQL stores * Previous experience ...

Physics, Computer Science, Stats) * 1-2 years' experience developing solutions and working with Python * Confident extracting and manipulating data from SQL and noSQL stores * Previous experience ...

next page

Showing results 1-20

Data Analyst Python Sql information

Is Python and SQL enough for a data analyst?

For a data analyst, proficiency in Python and SQL is fundamental for data manipulation, analysis, and querying databases. However, additional skills such as data visualization, statistical knowledge, and familiarity with tools like Excel or BI platforms are often required to perform comprehensive analysis and communicate insights effectively.

What jobs can you get with SQL and Python?

Data analysts, data scientists, and business intelligence analysts commonly use SQL and Python to extract, analyze, and visualize data. These skills are essential for roles involving data management, reporting, and automation, often requiring knowledge of databases, statistical analysis, and data visualization tools.

How does a Data Analyst using Python and SQL typically collaborate with other departments within an organization?

Data Analysts proficient in Python and SQL frequently work alongside teams such as marketing, product development, finance, and operations. They gather requirements from stakeholders, translate business questions into data queries, and present actionable insights through dashboards or reports. Regular meetings and clear communication are essential to ensure that data solutions align with business goals, and Data Analysts often act as a bridge between technical data teams and non-technical decision makers. This collaborative environment helps drive data-informed decisions across the organization.

What are Data Analyst Python SQL jobs?

Data Analyst Python SQL jobs involve analyzing and interpreting data to help organizations make informed business decisions. These professionals use Python for data manipulation, automation, and visualization, and SQL for querying and managing data stored in relational databases. Typical tasks include data cleaning, building reports, extracting insights, and creating dashboards. Data Analysts often collaborate with other teams to understand data requirements and communicate findings through presentations or visualizations. Proficiency in both Python and SQL is essential for efficiently handling large data sets and solving complex analytical problems.

Is 40 too old to become a data analyst?

Age is not a barrier to becoming a data analyst; many professionals successfully transition into the field at various ages. Skills in Python, SQL, and data visualization tools are more important, and continuous learning can help overcome any age-related concerns. Employers value experience and analytical ability regardless of age.

What are the key skills and qualifications needed to thrive as a Data Analyst with Python and SQL, and why are they important?

To thrive as a Data Analyst specializing in Python and SQL, you need strong analytical skills, statistical knowledge, and proficiency in data manipulation, typically supported by a relevant degree or certification. Expertise in Python for data analysis, SQL for database querying, and experience with visualization tools like Tableau or Power BI are commonly expected. Attention to detail, problem-solving abilities, and effective communication are crucial soft skills for interpreting data and presenting actionable insights. These skills help ensure accurate analysis, impactful reporting, and informed decision-making within organizations.

Can Python and SQL work together?

Data analysts often use Python and SQL together to efficiently extract, manipulate, and analyze data. Python libraries like pandas and SQL connectors enable seamless integration, allowing analysts to automate workflows and perform complex data processing tasks within a single environment.

What is the difference between Data Analyst Python Sql vs Data Scientist?

AspectData Analyst Python SqlData Scientist
Required SkillsExcel, SQL, Python basics, data visualizationAdvanced Python, machine learning, statistical modeling
Work EnvironmentBusiness intelligence, reporting, dashboardsPredictive modeling, research, complex data analysis
Industry UsageFinance, marketing, retail, healthcareTech, finance, research institutions, startups

While Data Analysts with Python and SQL focus on interpreting data, creating reports, and visualizations, Data Scientists build predictive models and perform advanced statistical analysis. Both roles require Python and SQL skills, but Data Scientists typically have a stronger background in statistics and machine learning, making their work more research-oriented.

What are popular job titles related to Data Analyst Python Sql jobs in Ottawa, ON? For Data Analyst Python Sql jobs in Ottawa, ON, the most frequently searched job titles are:
What cities near Ottawa, ON are hiring for Data Analyst Python Sql jobs? Cities near Ottawa, ON with the most Data Analyst Python Sql job openings:

127 EN - EDC - Data Analyst/ Senior Data Analyst

Export Development Canada | Exportation et développement Canada

Ottawa, ON • On-site

CA$84K - CA$112K/yr

Full-time

PTO

Posted 12 days ago


Job description

Application deadline: July 7th, 2026

Join the EDC Team!

At EDC, we support Canadian businesses to succeed globally. We provide the financial tools and expertise they need to explore new markets, reduce risks, all towards the goal of making Canada and the world better through trade. #LI-Hybrid

Position: Data Analyst/ Senior Data Analyst

Employment Type: Permanent

Compensation Details:

  • Data & Analytics 16: Salaries typically range from $74,297 to $99,063 annually, based on qualifications and experiences, plus a performance-based incentive.
  • Data & Analytics 17: Salaries typically range from $84,698 to $112,931 annually, based on qualifications and experiences, plus a performance-based incentive.

Location:

  • Export Development Canada operates in a hybrid work environment, with a current requirement of two in-office days per week, increasing to three days per week in September 2026 (subject to change).
  • This role will be performed from EDC’s headquarters in Ottawa.
  • Relocation assistance is available for candidates who meet the eligibility criteria.

About EDC:

At Export Development Canada (EDC), we empower Canadian businesses to succeed globally. As a financial Crown corporation, we offer innovative financial solutions and expert insights to help businesses explore new markets, mitigate risks, and achieve growth.

Why Join EDC?

  • Comprehensive Benefits: EDC offers a competitive compensation & benefits package, work-life balance, & the opportunity to help make Canada and the world better through trade.
  • Work-Life Balance: EDC offers a competitive compensation package & work-life balance. We have hybrid work options, 3 to 4 weeks paid vacation, a corporate closure period, summer early Friday’s & no meeting Fridays.
  • Professional Development: Take advantage of our continuous learning opportunities, including training programs, workshops and language training.
  • Inclusive Culture: Be part of a diverse and inclusive workplace that champions employment equity & values diversity of ideas, strengths, & backgrounds to succeed.
  • Wellness Programs: Access to wellness initiatives, mental health support, and fitness programs to keep you healthy and happy.
  • Community Engagement: Participate in volunteer opportunities and give back to the community through our various social responsibility programs.

Team Overview:

The Data and Insights team is seeking two individual contributors to strengthen its corporate and risk data assets. In this role, you will help enable faster, smarter, and better-informed decision-making across the corporation.

What you will be doing:

  • Identify the best information sources to meet user needs, and develop the queries and reports required.
  • Create standardized and curated datasets using data platforms such as Microsoft Fabric and Databricks to support data analytics and dashboards.
  • Analyze query and report outputs, conduct statistical analysis as needed, interpret results, and prepare clear reports that explain findings.
  • Identify data integrity issues, recommend practical solutions, and maintain related documentation, templates, procedures, processes, and standards.
  • Support all aspects of data lifecycle management, including business consultation, solution design, testing, and deployment.

What we are looking for:

  • Undergraduate degree in Business Analytics, Mathematics, Statistics, Computer Science, Management Information Systems, or a related discipline.
  • Minimum of 2 years (Level 16) of experience in business intelligence, reporting principles, and reporting practices and 5+ years of experience for level 17.
  • Minimum of 2 years (Level 16) of experience in data analytics with large, complex datasets and 5+ years for level 17.
  • Experience using SQL or Python for data transformation.

What will make you stand out:

  • Experience with data transformation tools such as Microsoft Fabric, Databricks, SSIS, or DataStage.
  • Experience using business intelligence tools such as Power BI, Cognos Analytics, or Tableau.
  • Experience building complex semantic models for analytical reporting.
  • Experience with data virtualization software such as Denodo.
  • Bilingualism in English and French.

Eligibility:

  • Eligibility: EDC is committed to Fair Employment Practices and preference will be given to a candidate who is able to work legally in Canada at the time of application (Canadian Citizens or Permanent Residents). Candidates must meet the requisite government security screening requirements. The position is open to those who meet all of the essential requirements stated above and whose applications are received by the closing date.

This position is open to individuals who meet all the essential criteria outlined above and submit their applications by the closing date. Ready to make a difference? This is your chance to join a dynamic, growing team and leave your mark on our organization, development finance, and the world.

Apply today!

Want to learn more about EDC? Check our website here https://www.edc.ca

EDC's Commitment to Employment Equity

Export Development Canada (EDC) is dedicated to fostering employment equity and building a diverse workforce. We are committed to creating a safe and inclusive environment that respects people from all cultures, backgrounds, and abilities. At EDC, we nurture a culture of inclusion and belonging where everyone has equal opportunity to grow, develop, succeed, and be their truest selves.

We actively encourage applications from women, Indigenous peoples, visible minorities, persons with disabilities, and members of the 2SLGBTQI+ community.

Your application must clearly demonstrate how you meet all the requirements. We thank all applicants' interest in a career at EDC; however, only those selected for an interview will be contacted. Please note that qualified candidates may be considered for similar roles at this level within EDC.

Should you require any accommodation during the recruitment and selection process, please contact the Recruitment team at accessibility@edc.ca.