SQL DW Engineer

Company Description

Salary Range: PHP140,000/month

Annual Salary Type: 13 months

Employment Type: Full-Time, Permanent

XP Power is a global leader in providing essential power solutions to the Healthcare, Technology and Industrial markets. We are a fast-growing business, based in numerous locations across North America, Asia and Europe, and are listed as a FTSE 250 company on the London Stock Exchange. We are extremely proud and committed to our culture that values Customer Focus, Flexibility, Knowledge, Speed, and Integrity. We are looking for self-motivated professionals who thrive in dynamic environments. Joining our team means you will work in a high performing global company where employees collaborate and strive to make XP Power the first-choice power solutions provider delivering the ultimate experience for our customers and our people.

Job Description

In this newly created role, this is an exciting opportunity to create a framework for Self-Serve reporting. This role needs to create the appropriate business reporting cubes that will allow self-serve reporting across relevant business functions. This role must be conversant in ETL tools especially around Cloud tools (eg Data Factory and Databricks). Skills must include SQL Database Administration with large volumes of data in a Data Warehouse environment and strong technical knowledge of the Azure Framework.

KEY RESPONSIBILITIES:

• Must have a minimum of 5 years of experience in managing all facets of managing a SQL DW environment in Azure.
• 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.
• Strong Azure Framework technical knowledge
• You will be tasked with supporting and administering the SQL data warehouse and Azure Data Factory. A solid understanding of Azure Framework & 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.
• You will collaborate with BI Developers to provide strong raw data foundations for data models to be based on.
• You will provide oversight on database structure models in alignment with BI strategy and corporate KPIs.
• You should have experience developing 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.
• A background in working with SAP, Salesforce, and non-SAP ERP systems is also required.
• Knowledge of GDPR and confidential / personal data is required

Qualifications

• Background as a Senior Developer specializing in Microsoft SQL Data Warehousing.
• Experienced in managing cloud-based database solutions (Azure), with a strong framework knowledge.
• Proficient with tools such as Databricks, Data Factory, MS SQL, and various data analysis and integration platforms.
• Capable of developing SQL structures to support a Business Intelligence strategy.
• Hands on experience in utilising an ETL (Extract Transform & Load) toolset.
• Possesses an analytical mindset and strong problem-solving abilities.
• Excellent communication and collaboration skills.
• Experienced in managing third-party software and support organizations.
• Adept at simplifying complex issues for non-technical audiences.
• Ability to influence and collaborate with global colleagues at all levels, including directors.
• Able to communicate with developers and business alike

Additional Information

Location

• Based in The Philippines
• Home-based initially until facility established in Metro Manilla (expected Ortigas, Metro Manila area)