1

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

Analyze website and UX data using GA4 and Google Tag Manager and recommend ways to optimize the ... Proficiency in Python, SQL, Excel, and scripting languages,as well as business intelligence tools ...

Data Scientist

Ottawa, ON

CA$74K - CA$112K/yr

Write complex SQL queries and utilize Databricks to clean, aggregate, and structure raw data for ... Knowledge of Python for statistical analysis or scripting outside of Databricks. * Familiarity with ...

... SQL, data modeling, dashboard development, and report automation. Experience with Databricks and Power BI administration is highly preferred. Python experience for AI, analytics and automation is ...

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 ...

Azure Databricks, SQL Databases, Azure Data Lake Minimum 5 years of experience in systems ... Scala, Python, R, Azure Functions (asset) Compensation Hourly Rate Negotiable This is an existing ...

PHP, Javascript, Python, MySQL, VueJS, ElectronJS, Selenium, VMware, AWS. * Creative and motivated ... Data science training or experience with big data analysis and visualization. * Interest and ...

Lead Data Consultant, Manager

Ottawa, ON

CA$112.40K - CA$162.40K/yr

... 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 ...

Lead Data Consultant, Manager

Ottawa, ON

CA$112.40K - CA$162.40K/yr

... 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 ...

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 ...

Data Scientist

Ottawa, ON ยท On-site

$80K - $100K/yr

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 ...

The engineer works closely with IVR Engineers, Application Architects, DevOps, and Data Analytics ... Write, maintain, and optimize SQL for application logic, configuration changes, and investigations

... data exchange and interactions. * Investigate and resolve complex technical issues by analysing ... Familiarity with SQL and experience working with relational databases. * Experience integrating web ...

New

next page

Showing results 1-20

Data Analyst Python Sql information

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.

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.

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 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:
Infographic showing various Data Analyst Python Sql job openings in Ottawa, ON as of May 2026, with employment types broken down into 5% As Needed, 49% Full Time, 20% Part Time, 25% Contract, and 1% Nights. Highlights an 67% Physical, 11% Hybrid, and 22% Remote job distribution.

Data Analyst (Marketing)

CIRA

Ottawa, ON โ€ข On-site

Full-time

Posted yesterday


Job description

Join the .CA and Registry team at CIRA and help shape what it means to be Canadian in the digital world! Our .CA domain is more than a web address-it's a symbol of Canadian pride and a cornerstone of our national digital presence. By managing over 3 million .CA domains, CIRA's role is crucial in maintaining the .CA domain's integrity and ensuring it supports the diverse needs of Canadian businesses and individuals.


By working with the .CA brand, you'll play a part in enhancing the .CA domain's role in representing Canadian identity - ensuring that it continues to serve as a trusted and recognizable symbol online. Join us in celebrating Canada's digital landscape and make a meaningful impact on how Canadians connect,communicate and thrive online.


Who you are:


You are a strategic thinker with a passion for transforming data into stories that drive impact. Curious by nature and rigorous in your approach, you excel at finding patterns, uncovering opportunities, and translating complex analyses into clear recommendations that fuel marketing growth.


You thrive at the intersection of marketing and business intelligence, bringing both technical expertise and commercial awareness. Collaborative and solutions-oriented, you're comfortable leading data initiatives, guiding stakeholders through insights, and ensuring that every decision is grounded in evidence. Above all, you see data not just as numbers, but as a powerful tool to shape strategies, strengthen partnerships, and accelerate the success of our .CA business.


What you'll do:


  • Oversee data and research projects in support of marketing and business objectives by defining goals, requirements and methodologies, and working with outside vendors as required.
  • Drive data excellence by implementing and refining best practices for data reporting and accessibility, empowering our growth initiatives with clear, actionable insights.
  • Generate comprehensive business and campaign performance reports and dashboards that not only identify trends but also provide actionable feedback to optimize our strategies.
  • Build strong relationships with cross-functional teams and effectively present data insights to management and executives, influencing key business decisions.
  • Assess the effectiveness of our marketing campaigns using various techniques, including marketing mix models and third-party reporting systems, to measure and maximize ROI.
  • Analyze website and UX data using GA4 and Google Tag Manager and recommend ways to optimize the customer journey on our website.
  • Work closely with external vendors and internal teams to support forecasting and help set and measure KPIs, and maintain a robust analytics framework, ensuring all stakeholders have access to the data and insights they need.
  • Champion a data-driven culture by advocating for the use of data across the company, helping teams leverage tools, insights, and processes that enhance our performance.
  • Support A/B testing initiatives by providing pre-test analysis, test setup guidance, and post-test interpretation of results.


What you bring:


  • A Bachelor's Degree in Data Science, Computer Science, Statistics, Mathematics, Business Administration, or a related field
  • 7+ years of hands-on experience in an analytics role, demonstrating your ability to turn data into insights.
  • Proficiency in Python, SQL, Excel, and scripting languages,as well as business intelligence tools such as Qlik Sense or Power BI is preferred. Experience in data visualization tools like Looker Studio, and project management tools like Jira is also desired.
  • Knowledge of website architecture and experience using web analytics tools including GA4, Google Tag Manager.
  • Strong communications skills. Able to effectively translate complex technical information into plain language.
  • A track record of thriving in dynamic, fast-paced environments while maintaining a laser focus on delivering results.
  • Experience designing marketing dashboards and reports and using data for storytelling.
  • Familiarity with cloud data platforms and machine learning applications/platforms is a definite plus.
  • A solid understanding of digital marketing channels and their respective KPIs and attribution models.
  • Experience in B2B or channel-based environments, with a proven history of developing insights that lead to successful growth strategies, is an asset.
  • Experience in Marketing Mix Modeling (MMM), including data collection, cleaning, analysis and reporting, is an asset.

Who we are:


At CIRA, we're driven by a passion to make a positive impact on Canada's digital future. We're not just asking, 'What more can we do?'-we're actively exploring new frontiers to enhance and secure the internet for all Canadians. Our recognition as one of the National Capital Region's Top Employers for ten years is a testament to our vibrant culture. We believe in fostering an environment where collaboration and candour are second nature and where diverse perspectives are integral to our success, because we know that great ideas come from everywhere. If you're passionate about innovation and ready to make a difference in a dynamic field, join us and help shape the future of the internet!


CIRA embraces a blend of remote and IRL in-office work to keep our team connected and engaged. Our Ottawa headquarters is a hub for regular events and social activities that bring our team together, encouraging a strong sense of community within our organization. No matter where you work from, you'll always feel part of our vibrant team and our shared mission.


At CIRA, people remain at the centre of our recruitment process. While CIRA uses recruitment platforms that include artificial intelligence-enabled features, which may be used to support administrative processes or skills-based assessments, these features are intended to assist our recruitment activities and do not replace human judgment. All applicant screenings, interviews, evaluations and selection decisions are conducted by our staff. Artificial intelligence is not used to make autonomous or final hiring decisions.


This posting is for an existing vacancy. For any accommodations during the recruitment process, please contact us atpeopleandculture@cira.ca.


----------


Joignez-vous a l'equipe du domaine.CA et du registre de CIRA et aidez a faconner l'identite des Canadiennes dans le monde numerique! Notre domaine.CA est plus qu'une simple adresse Web: c'est un symbole de la fierte canadienne et une pierre angulaire de notre presence numerique nationale. En gerant plus de 3millions de domaines.CA, CIRA joue un role crucial dans le maintien de l'integrite du domaine.CA et veille a ce que celui-ci reponde aux divers besoins des entreprises et des particuliers canadiennes.


En travaillant avec la marque.CA, vous contribuerez a renforcer le role du domaine.CA dans la representation de l'identite canadienne, en veillant a ce qu'il continue d'etre un symbole fiable et reconnaissable en ligne. Joignez-vous a nous afin de celebrer le paysage numerique du Canada et d'avoir un impact significatif sur la facon dont les Canadiennes s'engagent, communiquent et prosperent en ligne.


Qui vous etes:


Vous etes une stratege passionnee par la transformation des donnees en recits qui ont un impact. De nature curieuse et rigoureuse dans votre approche, vous vous distinguez dans la recherche de modeles, la decouverte d'occasions de croissance et l'adaptation d'analyses complexes en recommandations claires qui favorisent la croissance du marketing.


Vous excellez a la croisee du marketing et de la veille strategique, alliant expertise technique et savoir-faire commercial. De nature collaborative et mettant l'accent sur les solutions, vous etes a l'aise pour diriger des initiatives de donnees, guider les parties prenantes grace a vos connaissances et veiller a ce que chaque decision soit fondee sur des preuves. Par-dessus tout, vous envisagez les donnees non seulement comme des chiffres, mais comme un outil puissant pour elaborer des strategies, renforcer les partenariats et accelerer la reussite du secteur des domaines .CA.


Vos taches:


  • Superviser les projets en matiere de donnees et de recherche afin d'appuyer les objectifs commerciaux et de marketing en definissant les objectifs, les exigences et les methodologies, et en collaborant avec des fournisseurs externes au besoin.
  • Favoriser l'excellence des donnees en mettant en uvre et en affinant les meilleures pratiques en matiere de production de rapports et d'accessibilite des donnees, afin de permettre a nos initiatives de croissance de s'appuyer sur des informations claires et exploitables.
  • Produire des rapports et des tableaux de bord complets sur les realisations financieres et le rendement des campagnes qui non seulement identifient les tendances, mais fournissent egalement des commentaires exploitables afin d'optimiser nos strategies.
  • Etablir de solides relations avec des equipes interfonctionnelles et presenter efficacement les donnees a la direction et aux cadres superieurs, en influencant les decisions d'affaires cles.
  • Evaluer l'efficacite de nos campagnes marketing a l'aide de diverses techniques, notamment des modeles de logistique commerciale et des systemes de compte-rendu par des tiers, afin d'evaluer et de maximiser la rentabilite des investissements.
  • Analyser les donnees relatives au site Web et a l'experience utilisateurrice a l'aide de GA4 et de Google Tag Manager et recommander des moyens d'optimiser le parcours cliente sur notre site Web.
  • Travailler en etroite collaboration avec les fournisseurs externes et les equipes internes pour soutenir les previsions, aider a definir et a evaluer les indicateurs cles de performance (ICP) et maintenir un cadre analytique solide, en veillant a ce que toutes les parties prenantes aient acces aux donnees et aux renseignements dont elles ont besoin.
  • Promouvoir une culture axee sur les donnees en defendant l'utilisation des donnees dans l'ensemble de l'entreprise, en aidant les equipes a tirer parti des outils, des connaissances et des processus qui ameliorent notre rendement.
  • Soutenir les initiatives de tests A/B en fournissant une analyse prealable aux tests, des conseils pour la mise en place des tests et une interpretation des resultats apres les tests.


Vos antecedents :


  • Un baccalaureat en sciences des donnees, en informatique, en statistiques, en mathematiques, en administration des affaires ou dans un domaine connexe.
  • Au moins septans d'experience pratique dans un role d'analyste, demontrant votre capacite a transformer les donnees en informations.
  • La maitrise de Python, SQL, Excel et des langages de script, ainsi que des outils de veille strategique comme Qlik Sense ou Power BI est preferable. Une experience des outils de visualisation de donnees comme Looker Studio et des outils de gestion de projet comme Jira est egalement souhaitable.
  • Connaissance de l'architecture des sites Web et experience dans l'utilisation d'outils d'analyse Web, notamment GA4 et Google Tag Manager.
  • Solides competences en communication. Capable de vulgariser efficacement des renseignements techniques complexes en langage clair.
  • L'habitude de vous epanouir dans des environnements dynamiques et rapides, tout en vous concentrant sur l'obtention de resultats.
  • Experience dans la conception de tableaux de bord et de rapports marketing et dans l'utilisation des donnees a des fins narratives.
  • Bonne connaissance des plateformes de donnees en nuage et des applications/plateformes d'apprentissage automatique, un atout.
  • Solide comprehension des canaux de marketing numerique, de leurs indicateurs cles de performance et de leurs modeles d'attribution respectifs.
  • Experience dans des environnements de commerce electronique interentreprises ou de canaux de distribution, avec une experience averee dans le developpement d'idees qui menent a des strategies de croissance fructueuses, un atout.
  • Experience en modelisation du mix marketing (MMM), y compris la collecte, le nettoyage, l'analyse et la communication des donnees, un atout.

A propos de nous:


Chez CIRA, nous sommes motivees par la passion d'avoir un impact positif sur l'avenir numerique du Canada. Nous ne nous contentons pas de demander : Que pouvons-nous faire de plus? . Nous explorons activement de nouvelles frontieres afin d'ameliorer et de securiser Internet pour la population canadienne. CIRA est reconnue comme l'un des meilleurs employeurs de la region de la capitale nationale depuis dix ans, ce qui temoigne de notre culture dynamique. Nous croyons qu'il est important de favoriser un environnement ou la collaboration et la franchise sont une seconde nature et ou la diversite des points de vue fait partie integrante de notre succes, car nous savons que les grandes idees viennent de partout. Si vous etes passionnee par l'innovation et prete a faire une difference dans un domaine dynamique, joignez-vous a nous et contribuez a faconner l'avenir d'Internet!


CIRA favorise un melange de travail a distance et de travail au bureau pour que notre equipe reste connectee et engagee. Situe a Ottawa, notre siege social est un carrefour pour les evenements reguliers et les activites sociales qui rassemblent les membres de notre equipe, favorisant un fort sentiment d'appartenance au sein de notre entreprise. Peu importe ou vous travaillez, vous aurez toujours le sentiment de faire partie de notre equipe dynamique et de partager notre mission commune.


Chez CIRA, les personnes restent au cur de notre processus de recrutement. Bien que CIRA utilise des plateformes de recrutement dotees de fonctionnalites basees sur l'intelligence artificielle, qui peuvent etre utilisees pour faciliter les processus administratifs ou les evaluations basees sur les competences, ces fonctionnalites ont pour but d'aider nos activites de recrutement et ne remplacent pas le jugement humain. Toutes les preselections, les entrevues, les evaluations et les decisions de selection sont effectuees par notre personnel. L'intelligence artificielle n'est pas utilisee pour prendre des de...