About this role
Manage data analysis and management workflows within a large organization.
Responsibilities
• Design and maintain data warehouses using star and snowflake schemas.
• Perform multidimensional data modelling to support business requirements.
• Execute code migrations and release management across different environments.
• Optimize SQL queries and database performance using SSMS.
• Review own work to ensure high accuracy and minimize errors.
Required Skills
• 5+ years of experience in data management and data analysis.
• 5+ years of experience with SQL for RDBMS, specifically Azure SQL or MS SQL Server.
• 2+ years of experience using Databricks.
• 2+ years of experience with Power BI, including DAX and Power Query.
• Expertise in SQL optimization techniques and multidimensional database schemas.
• Proficiency with SQL Server Management Studio (SSMS).
• Experience with star and snowflake schema data warehouse design.
Preferred Skills
• Experience managing marketing data, including Google Analytics or marketing automation systems like SAP and Eloqua.
• Experience with GIT versioning.