x
Get our mobile app
Fast & easy access to Jobstore
Use App
Congratulations!
You just received a job recommendation!
check it out now
Browse Jobs
Companies
Campus Hiring
Download App
Jobs in Philippines   »   Jobs in Pasig   »   Engineering Job   »   SQL DW Engineer
 banner picture 1  banner picture 2  banner picture 3

SQL DW Engineer

XP Power

XP Power company logo
  • Must have at least 3-5 years of experience in managing all facets of managing a SWL DW environment in Azure. 

  • You will be responsible for designing and modelling a snowflake and star schema environment to create reporting cubes across various business functions, enabling self-service reporting for the organization. 

  • Your role includes designing a multidimensional data warehouse using the SQL Server BI stack. A strong background in SQL development, particularly in creating data warehouse solutions, is essential. 

  • You must understand advanced SQL techniques such as looping logic, indexing temporary tables, and other sophisticated database strategies. The ability to write optimized and performant SQL code is crucial. 

  • Familiarity with additional programming languages like Python is required. Experience in developing reporting solutions using Power BI in a self-service environment is also necessary.  

  • You will be tasked with supporting and administering the SQL data warehouse and Azure Data Factory. A solid understanding of Azure tools, including Data Factory and Databricks, is important for this role. 

  • You will be responsible for debugging, monitoring, and troubleshooting BI solutions. 

  • You should have a strong understanding of leading extract, transform, and load (ETL) tools. 

  • You will develop techniques for quality data collection to ensure data adequacy, accuracy, and legitimacy.  

  • Recognizing business requirements within the BI context, you will create data models to transform raw data into meaningful insights. 

  • You will provide oversight on database structure models in alignment with BI strategy and corporate KPIs. 

  • You should have experience developing models, queries, and views within project timelines, with a focus on meeting deadlines. 

  • Strong knowledge of implementing security in a SQL Data Warehouse environment, spanning data such as row level security and applying security to individuals access such as active directory or role level security. 

  • A background in working with SAP, Salesforce, and non-SAP ERP systems is also required. 

Sharing is Caring

Know others who would be interested in this job?