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.