Production Specialist (SQL)

IQVIA SOLUTIONS OPERATIONS CENTER PHILIPPINES, INC.; Taguig; Hybrid; PHP 400,000 - 600,000; Full time

Job summary

A leading analytics company in Taguig is looking for a qualified data analyst to execute ETL processes and perform database management. The ideal candidate holds a Bachelor's degree in IT and has 4+ years of experience, strong skills in SQL and Excel, as well as effective communication abilities. Flexibility for hybrid work and different shifts is necessary.

Qualifications

• Minimum of four years of relevant experience.
• Ability to write complex SQL queries.
• Proven skills in data analysis using Excel.
• Experience with Microsoft SQL Server Management Studio.

Responsibilities

• Execute dataset onboarding processes from various sources.
• Configure and execute ETL scripts to create database instances.
• Perform post-load analysis and compare row counts.
• Provision ETL databases across different environments.
• Manage permissions for datasets.

Skills

Proficient in SQL

Version Control Proficiency

Proficient in Microsoft Excel

Strong communication skills

Problem-solving ability

Education

Bachelor’s degree in IT or related field

Tools

Microsoft SQL Server Management Studio

Visual Studio 2022

Snowflake

Gitlab

JIRA

Job description

Job Responsibilities

• Executes dataset onboarding process where data assets are onboarded from various sources but primarily from CDD (Central Data Distribution)/ Data IQ.

• Configure and execute the ETL script using the specified database name and create a new ETL database instance.

• Perform post-load analysis by comparing row counts & etc. with previous releases using dataset documentation or ims-schemas & environment provisioning

• Provision ETL databases across Dev, Demo, and Live environments using the provisioning script.

• Assigning appropriate roles and permissions.

• Reference Database creation, configuration and loading, this includes running a specific SSIS package on the staging server via the Integration Services Catalog, ensuring it is configured with the correct parameters, especially the Snowflake database name.

• Backup and restore the reference database across dev, demo, and live environments using SQL Target parameters.

• Integration Configuration- request and insert required IDs via ID Gatekeeper for integration scripts, execute integration scripts in Snowflake (Dev) and SQL servers (Demo & Live).

• Permissions Management- applying new dataset permissions across all environments & run auto grant release permission script in Live and coordinating with HDE Support for broader access.

• Quality Assurance- conducting QA in Dev and Demo before proceeding to live and validating data integrity and ensure no significant drop in row counts compared to previous releases.

• Defines and updates documentation as necessary to maintain database quality.

• Serves as first escalation point for issue resolution and keeps track of said issues.

• Performs ongoing analysis and evaluation of existing processes with the objective of providing continuous improvements.

• Coordination and collaboration with various stakeholders globally.

Job Qualifications

• Bachelor’s degree in information technology, Information Systems, Software/Computer Engineering or equivalent with minimum of four (4) years of experience related to IQVIA production and development or experience with applications mentioned below.

• Proficient in SQL- ability to write queries to manipulate and retrieve data, understand basic to intermediate SQL syntax and structure.

• Knowledgeable to the following applications/tools/systems:

  • Must have-Microsoft SQL Server Management Studio (18), Visual Studio 2022, Snowflake, Gitlab, ID Gatekeeper and;

  • Nice to have - JIRA, ARA

• Version Control Proficiency- Manage changes in code, collaborate with others, and maintain a history of project development, understanding in basic Git terminology (commit, create branch, merge, clone, push, pull)

• Proficient in Microsoft Excel for data entry, analysis (eg, macro, functions, formula, etc.)

• Proficient in written and oral communication skills with a customer service focused approach and stakeholder management.

• Ability to proactively identify complex problems and needs and develop solutions/recommendations to solve problems.

• Amenable to work on Hybrid set up in Mckinley, Taguig

• Amenable to work on Mid shift as well as night shift if needed.