
Senior Data Analyst
- Mandaluyong City, Metro Manila
- Permanent
- Full-time
- Understand the business need, develop solutions, Support production systems and monitoring.
- Proficient in Microsoft BI tool stack and SQL server programming
- Perform root cause analysis on production issues, using data to diagnose bottlenecks and inefficiencies
- Refine and automate regular processes, track issues, and document changes.
- Requirements Gathering and Analysis for changes in ETL, support and performance improvements
- Configure and maintain database servers and processes, including monitoring daily schedule jobs, monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Responsible for handling tier 3 support tickets and providing resolution within defined service level agreements
- Writing ETL jobs to download different types of data from Oracle to SQL Server Data Marts to support newer or existing reports
- Implemented SSIS package configurations (Environment Variable and SQL Server)
- Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them. Extensively worked on cross-tabbed and Matrix reports using SSRS.
- Experience in working on Azure Services like Azure Data Factory, Azure Data Lake(Good to have)
- Must have skill sets in writing complex SQL and PLSQL programs and proficient in performance tuning
- Ontime Coordination and Status Reporting to the client.
- Good communication skills, with the ability to convey technical concepts to both technical and non-technical customers.
- Ability to work independently work within a team environment.
- Microsoft certifications in data-related fields are preferred.
- Work closely with partners from Business, IT, Users, admin, and functional managers, and other counterparts
- 6-7 years of experience working with Microsoft BI tool stack and SQL server programming
- 6-7 years of experience on SSDT tools specially into SSIS, SSAS, SSRS & SQL Server
- Strong analytical abilities with a proven track record of resolving complex data challenges.
- Proficient in database management, SQL query optimization, and data mapping.
- Understanding of Excel, including formulas, filters, macros, pivots, and related operations.
- Demonstrable experience leading and managing data-driven projects or teams.
- Strong proficiency with data visualization tools such as Power BI, or similar tools.
- Experience in strategic business analysis and collaborating with senior leadership.
- Good problem solving and analytical skills
- Flexible to work in 24x7 environment
- Bachelor's degree or equivalent in Science with a technical background (MIS, Computer Science, Engineering or any related field)
- Good interpersonal skills using English, both spoken and written, as will be working with overseas team