Office Location: 14th Floor, 1Nito Tower, Archbishop Reyes Ave, Lahug, Cebu City Reports to: Vice President Special Projects BI DEVELOPER / BUSINESS INTELLIGENCE DEVELOPERThis role will collaborate with cross-functional teams to understand business requirements, design data models and develop processes necessary to build BI systems, and create reporting and analytical solutions that empower data-driven decision-making throughout the organization. Duties and responsibilities will include all those customarily attendant to such a position, and such other duties and responsibilities as may, from time to time, be assigned to you by the Business Intelligence Technology Lead or the Company.
JOB RESPONSIBILITIESCollaborate closely with stakeholders to gather and refine data requirements, ensuring efficient design and structure for BI systems.Create and maintain reporting and analytics solutions, including dashboards, visualizations, and interactive reports using Power BI.Develop and optimize data models, workflows, and processes to extract, transform, and load data from various sources.Conduct data profiling and data mapping to ensure accurate data extraction and transformation.Implement and deploy scalable and high-performance data solutions using industry-standard tools and technologies.Partner with cross-functional teams to streamline tools and processes for our data systems (automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.).Ensure best practice and standards for BI related solutions by utilizing quality/version control tools such as PowerOps or Github.Develop and maintain comprehensive technical documentation for BI tools and processes using Confluence and SharePoint.Monitor the health and performance of BI solutions and related systems, proactively addressing any issues.QUALIFICATIONS3+ years of experience as a BI Developer or in a similar role with demonstrated expertise in designing, building, and deploying BI solutions.Expertise with various BI tools (e.g. PowerBI, Tableau, PowerOps, etc.).Proficiency in data migration, data integration, and data governance practices.2+ years of data modeling experience for both OLTP and OLAP systems.Experience with data profiling, data cleansing, and normalization techniques using Star Schema Design.Proficient with M-language, PowerQuery, VBA.2+ years of experience writing technical documentation for training and audit purposes.2+ years of working in supply chain/logistics industry and respective Transportation Management Systems such as SAP TM or CargoWise.1+ years of experience with databases such as MS SQL Server, PostgreSQL, etc.Experience writing and executing SQL transactions in a production environment.The ideal candidate should be a strong team player who can also work independently, effectively prioritize tasks, operate with minimal supervision, and demonstrate the ability to effectively manage multiple tasks simultaneously.This individual should also have strong analytical, organizational, and time management skills, coupled with excellent verbal and written communication abilities.PREFERRED QUALIFICATIONSExperience using ETL tools (e.g. Apache Airflow, Kafka, Spark).Knowledgeable with cloud-based solutions and data integration tools (e.g. CData, AWS Redshift).Proficiency with scripting languages for data (e.g., Python, Node.js, etc.).Experience working in Agile or Scrum setting using Jira or Airtable.WORK SET UP & WORKING HOURS10:00pm-7:00am PHT Monday to Friday.On-Site.
#J-18808-Ljbffr