Sql Dw Engineer

.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 DescriptionMust 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.QualificationsKey Qualifications and SkillsBackground as a Senior Developer specializing in Microsoft SQL Data Warehousing.Experienced in managing cloud-based database solutions (Azure, AWS, Google)