Data Analyst

Primus@Knowledge Specialists, Inc.; Rosario; On-site; PHP 600,000 - 900,000; Full time

Job summary

Primus@Knowledge Specialists, Inc. is seeking a Reporting Analyst to provide rapid data insights for the ASCO organization. You will develop and maintain data delivery through North America Data Warehouse platforms and collaborate on data architectures and agile analytics initiatives.

The role focuses on translating requirements into data pipelines, building visualizations in Tableau, and ensuring data quality across multiple sources while supporting governance and cloud migration efforts.

Qualifications

• Bachelor's or Master's degree in Information Systems, Data Analytics, CS or Engineering.
• 5+ years of experience in Reporting and Analytics.
• Advanced SQL queries and programming.
• Strong Tableau data visualization skills with advanced features.

Responsibilities

• Collaborate to design and deliver enterprise data solutions for BI and data warehousing.
• Translate business requirements into data pipelines and stores.
• Create visualizations using Tableau and ETL tools like Alteryx and SSIS.
• Define migration strategies from legacy systems to cloud architectures.
• Automate, standardize, optimize, and ensure data integrity and governance.
• Manage databases and ETL tools to extract data from multiple sources.
• Perform detailed data analysis to assess data quality.
• Develop data models with the Data Warehouse team for quick access.
• Gather and analyze requirements to support executive and team analytics.
• Collaborate with Business Analysts and data stewards to document KPIs.

Skills

SQL

Tableau

Alteryx

SSIS

SQL Server

MySQL

Oracle

Redshift

Data Warehousing

Education

Bachelor's/Master's degree, Information Systems or Data Analytics

Tools

Tableau

ETL Tools

Job description

About the role

The Reporting Analyst will provide rapid solutions to the ASCO organization giving them data insights through a process of continuous discovery and will work with a wide range of solutions and technologies applicable to the current environment using data visualizers, data transformational tools, native reporting tools within applications, Machine Learning etc. The analyst will develop, maintain, and improve data delivery through the North America Data Warehouse platforms. The right person in this role will support overall improvements in data architecture, metric definition and agile processes to support business data and analytical initiative and continuously monitor developments within the broad area of Analytics and look for opportunities to apply them to the company and department goals.

Key responsibilities

• Collaborate with team members with a flexible approach to conceptualize, design, and deliver enterprise and departmental data solutions to support business intelligence, data warehousing, reporting requirements

• Translate business requirements into data pipelines and data stores to support business needs

• Create visualizations using Business Intelligence tools like Tableau, in application reporting services and ETL Tools like Alteryx, SSIS

• Work with Data and Solution Architects to define and implement migration strategies from legacy systems to cloud architecture and technologies

• Automation, standardization, optimization and delivery of solutions with focus on data integrity and governance

• Manage various databases and ETL tools to extract and manipulate data from disparate sources e.g.: SQL Server, MySQL, Oracle, Redshift, Alteryx, and SSIS

• Perform detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples

• Operate with Data Warehouse team to develop data models and other structures to enable fast and easy business user access to data

• Gather and analyze requirements while working with business to develop executive, management, and team data analytics

• Work collaboratively with Business Systems Analysts, Business Data Stewards and key business users to ensure data quality, business requirements and dashboard KPIs are documented accurately and completely

About you

• Bachelor's/Master's degree, preferably with a concentration in Information Systems, Data Analytics, Computer Science, Engineering

• 5+ years relevant experience in Reporting and Analytics

• Command of advanced SQL queries and programming

• Strong Tableau data visualization skills (2-year experience preferred) with advanced-level skills with action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions, and table calculations

• Ability to work independently yet collaborates cross-functionally in a team environment

• Ability to adapt to rapidly changing priorities in a positive manner

• Strong customer service skills, and ability to remain calm and positive in a fast-paced environment

• Confident with learning new tools, technologies, and methodologies

• Excellent communication and follow up skills

• Strong analytical, quantitative, problem solving, and organizational skills with attention to detail