PSL Group Logo

PSL Group

Data Analyst

Posted 15 Days Ago
Be an Early Applicant
Canada
Mid level
Canada
Mid level
The Data Engineer will develop and support data engineering efforts, build optimal data pipelines from various sources, and ensure quality governance of master and transactional data. They will leverage tools and technologies to enhance data integration and support data management initiatives.
The summary above was generated by AI

Our Vision

P\S\L Group is a global organisation dedicated to putting information at the service of medicine.  The companies and people of the P\S\L Group aim to improve medical care by serving those who need it, those who provide it and those who seek to improve it.

To this end, we want our information and education services to contribute to the goals we share with our clinicians, clients and supporters, namely: to accelerate the advancement of medicine and help people enjoy better, longer lives. 


Our Purpose

Our key contribution to society is to help clinicians and those who support them provide state-of-the-art medical care. 

Our primary business purpose is to help clients and supporters increase the effectiveness of activities pertaining to scientific communication, medical education and the maintenance of audience intimacy.


Position Summary 

As a Data Analyst, you will be a key resource for creating and supporting organizational data engineering efforts. This role will work closely with the engineering teams to proactively maintain and help create a high quality data ecosystem. This role will require technical expertise to drive innovation and evolve our data integration capabilities.


What you will do 

  • Support Data Quality and data completeness by implementing monitoring dashboards for business critical data
  • Identify problems in data assets and take appropriate corrective action to fix within defined SLA’s
  • Gather information from disparate systems to identify data discrepancies
  • Research and complete data requests or data changes requested by business
  • Work with Business counterparts to understand their data needs and implement changes in existing system or source new data for their new data needs
  • Write, execute and debug SQL queries/Stored procedures to confirm data completeness, correctness, data transformation and data quality testing

Who you are

  • Bachelor’s or equivalent degree in IT/Math/Quantitative discipline
  • Minimum 3 years of experience working with data and supporting data operations
  • Understanding of database models and design (both SQL and noSQL)
  • Knowledge and experience working with SQL,Python and AWS , Snowflake, Postgres
  • Excellent analytical and problem solving skills
  • Experience with data profiling, data cleansing, data wrangling, data quality, standardizations,  transformations etc
  • Exposure to testing data for data marts, data warehouses, and data integration solutions
  • Advanced SQL knowledge, including PostgreSQL Snowflake, and MSSQL
  • Strong analytic skills related to working with unstructured datasets
  • Prior experience with ETL tools (Knime) and Master Data Management concepts is a plus

Top Skills

AWS
Bitbucket
Cloudtrail
Cloudwatch
Elasticsearch
Git
Glue
Kinesis
Lambda
Postgres
Python
Redshift
Snowflake

Similar Jobs

4 Days Ago
Hybrid
Toronto, ON, CAN
Junior
Junior
Enterprise Web • Fintech • Financial Services
The Senior Marketing Data Analyst at Morningstar will analyze KPIs, create dashboards, and build forecasting models to enhance marketing strategies for the Individual Investor business. Responsibilities include implementing analytics solutions, performing cohort analysis, and collaborating with cross-functional teams to drive user engagement and growth.
Top Skills: A/B Testing ToolsAWSGoogle AdsGoogle AnalyticsGoogle Marketing PlatformGoogle Tag ManagerLooker StudioPythonQuicksightRSQLTableau
8 Days Ago
Hybrid
10 Locations
Senior level
Senior level
Fintech • HR Tech
As a Staff Data Analyst, you will leverage data to drive strategic decisions, work closely with various teams, and ensure data quality and integrity. Your responsibilities include data analysis, reporting, collaboration with stakeholders, and developing visualizations while maintaining dashboards to communicate insights effectively.
Top Skills: HexLookerOmniSQLTableau
6 Days Ago
Hybrid
Toronto, ON, CAN
Senior level
Senior level
Enterprise Web • Fintech • Financial Services
In this role, you will analyze feature requests and collaborate with development teams to understand user needs. You'll collect requirements, create test strategies, and document methodologies for data logic in ETL/ELT processes. You'll also communicate with clients to clarify requirements and lead data exploration and automation efforts.
Top Skills: Amazon Web ServicesJupyter NotebookMachine LearningPythonSQL

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account