BI Developer | OLAP | SQL | ETL
Asia Select Inc.
- Taguig, PhilippinesFort Bonifacio, Taguig, Metro Manila, PhilippinesTaguigMetro ManilaPhilippinesPhilippines
- Toàn thời gianFULL_TIME
Công việc đã đóng.
Miêu Tả Về Công Việc
- Build a thorough understanding of the Advertising sales and planning business.
- Gain a strong understanding of the company's advertising logs, impressions, and metrics data.
- Analyze downstream data warehouse and reporting requirements and determine appropriate data sources to use and best way to model the mart and presentation layers.
- Be the technical product owner of an OLAP solutio supporting Advertising sales and planning team for Ads campagin and sales reporting.
- Work with business and product owners to define requirements and implement features to the existing cubes including ETL for star schema loading.
- Work across the data warehousing team to ensure QA with both design and implementation.
- Manage business relationships with users of the OLAP product.
- Work with technical and non-technical owners of the source systems to ensure correct understanding of the data.
- Contribute to the team's data quality initiatives, system stability, and best practices around implementation, testing, and documentation.
Trình độ tối thiểu
Essential:
- 3-6 years overall experience.
- Strong SQL to write ETL scripts/jobs.
- Data Modeling (Kimball, Inmon).
- Strong working experience in Microsoft Multidimensional and Tabular OLAP (with MDX and DAX) using SQL Server Analysis Services (SSAS).
- Experience with big datasets i.e. millions/billions of rows.
Desirable:
- Experience of Advertisement systems/data i.e. Google DFP, DT, DSM, Krux etc. (preferable)
- Experience with reporting and visualisation tools e.g. Chartio, Tableu (optional).
- Media sector experience (optional).
- Java/Python programming (optional).
Kỹ năng cần thiết
- ETL
- SQL
Tóm tắt công việc
- Trình Độ Công Việc
- Trình độ nhân viên cấp trung bình / cấp quản lý
- Ngành Nghề
- IT and Software
- Yêu cầu học vấn
- Tốt nghiệp Cử nhân
- Nhà tuyển dụng trả lời hồ sơ
- Sometimes
- Địa chỉ văn phòng
- Fort Bonifacio, Taguig, Metro Manila, Philippines
- Ngành nghề
- Management Consulting
- Vị trí đang tuyển
- 3 vị trí tuyển dụng mới
- Trang web
- https://asiaselect.ph/
Về Asia Select Inc.
Asia Select Inc. is a premiere Human Capital Solutions company supporting local and global companies in the Philippines.
With two decades of delivering with excellence, we have forged many long-term partnerships with diverse industry clients who require creative recruitment solutions such as Aspire (Executive Search), Accelerate (Contingency Search), and Architect (Recruitment Process Outsourcing).
We also offer our clients Assess (HR Consultancy) through AI-enabled recruitment and gamified solutions. In addition, we promote HR learning and executive education through Ascend (Learning and Development), making us the trusted educational partner of SHRM, IESE Business School, and Aden University.
Our services, tech solutions, and partnerships positions Asia Select as one of the leading organizations for candidates, clients, and partners.