Senior Data Governance Analyst

P\\S\\L Group; Mexico; On-site; PHP 800,000 - 1,400,000; Full time

Job summary

P\S\L Group in the Philippines is seeking a Senior Data Analyst to join our data engineering efforts. You will work with engineering teams to maintain a high-quality data ecosystem and drive data integration innovations.

Responsibilities include implementing SQL for data quality, handling data discrepancies, collaborating with business units to meet data needs, and validating data transformation and testing.

Qualifications

• 5+ 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, cloud data warehouses, and data integration solutions
• Experience with relational SQL, including PostgreSQL Snowflake, and MSSQL
• Experience with data visualization tools such as Tableau or powerBI
• Advanced working SQL knowledge and experience working with relational databases - both operational DBs and data warehouses
• Strong analytic skills related to working with unstructured datasets
• Prior experience with ETL tools and Master Data Management concepts is a plus

Responsibilities

• Support Data Quality and data completeness by implementing SQL queries, store procedures and functions
• 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 to confirm data completeness, correctness, data transformation and data quality testing

Skills

Analytical thinking

Problem solving

Data profiling

Data cleansing

Data wrangling

Data quality

Transformations

Data integration

ETL concepts

MDM concepts

Tableau

Power BI

SQL

Python

AWS

Snowflake

Postgres

MSSQL

Education

Bachelor's or equivalent degree in IT/Math/Quantitative discipline

Tools

SQL

Python

AWS

Snowflake

Postgres

Tableau

Power BI

MSSQL

NoSQL

Job description

P\\S\\L Group is a global organization 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.

Our primary purpose is to help clients increase the effectiveness of activities pertaining to scientific communication, medical education and product/service marketing. To this end, we want our information services to contribute to the goals we share with our clients, namely: to accelerate the advancement of medicine and help people enjoy better, longer lives.

Position purpose

As a Senior 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 SQL queries, store procedures and functions
• 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 to confirm data completeness, correctness, data transformation and data quality testing

Who you are:

• Bachelor's or equivalent degree in IT/Math/Quantitative discipline
• 5+ 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, cloud data warehouses, and data integration solutions
• Experience with relational SQL, including PostgreSQL Snowflake, and MSSQL
• Experience with data visualization tools such as Tableau or powerBI
• Advanced working SQL knowledge and experience working with relational databases - both operational DBs and data warehouses
• Strong analytic skills related to working with unstructured datasets
• Prior experience with ETL tools and Master Data Management concepts is a plus