Senior Business Analyst, Domestic Asset Data Foundation
PTTEP Services Limited
Job Purpose
Senior Business Analyst, Domestic Asset Data Foundation carries out critical role to gather business requirement from users and co-develop data models, including but not limited to data mapping, data lineage, back-end support tool design (job scheduling and monitoring, data retrieving platform, data access request, etc.), with IT corporate, and 3rd party vendors, to serve business-as-usual work and data analytics as well as digital solutions under domestic asset production function group.
Key Accountabilities
- Act as a liaison between business stakeholders (Product Owners and Business Users) and IT data modeling team. Proactively engage with users to understand their analytical needs, business questions, and reporting requirements, translating these into clear, actionable technical specifications for data models and transformations.
- Develop detailed workflows and process maps to illustrate current business operations and identify areas for improvement or automation
- Design, develop, and maintain robust and scalable data models within the data warehouse, ensuring data quality, consistency, and usability for analytical purposes. This includes transforming raw data into clean, structured datasets.
- Build and optimize data pipelines (ETL/ELT) to integrate data from various sources into the data warehouse, collaborating with Data Engineers as needed
- Implement rigorous testing procedures (unit, integration, and efficiency tests) to ensure the reliability and accuracy of data transformations and models.
- Create and maintain comprehensive documentation for data models, transformations, and data lineage to ensure transparency and reproducibility. Support data quality improvement and develop standards for data transformation.
- Optimize data models and queries for performance and efficiency within the data warehouse environment.
- Provide technical support and training to end-users on how to effectively utilize data and insights from information systems.
Professional Knowledge & Experiences
- 5+ years’ experience of data management in the E&P business.
- Strong knowledge in E&P business (Petroleum development, Production Operations, Drilling and Completion, etc.)
- Ability to design, develop, and maintain data models e.g. SQL, ETL tool, store-procedure, data warehousing, datalake etc.is a plus.
- Familiarity with visualization tools e.g. Power BI, Spotfire, etc.
- Excellent analytical, documentation, and communication skills.
- Excellent written and verbal communication skills both in English and Thai