About the role
About the Role
We are looking for a Data Platform Support Analyst to join our team, supporting and maintaining our Azure Data Platform ecosystem. This role requires experience in Azure SQL, Azure Data Factory (ADF), and Synapse Analytics, along with exposure to Snowflake. You will work closely with data Architects, data engineers, and customer services team to ensure the reliability, performance, and security of our data platforms.
Key Responsibilities
- Handle incident management, root cause analysis, and implement preventive measures.
- Ensure adherence to Data Platform Support SLAs and KPIs, proactively monitoring and responding to incidents.
- Monitor and maintain Azure SQL databases, ensuring optimal performance and availability.
- Provide support for Azure Data Factory (ADF) pipelines, troubleshooting failures and optimizing workflows.
- Maintain and troubleshoot Azure Synapse Analytics, including serverless and dedicated SQL pools.
- Provide support for Spark Notebooks in Synapse, troubleshooting execution failures and optimizing Spark jobs.
- Provide support for Apache Spark and Delta Lake, troubleshooting issues and ensuring performance optimization.
- Support Snowflake workloads and assist in integrating it within our data ecosystem.
- Monitor and troubleshoot ETL/ELT processes, ensuring data integrity and reliability.
- Work closely with data engineers to optimize database queries, stored procedures, and indexing strategies.
- Manage data security, access control, and compliance within the Azure Data Platform.
- Automate routine support tasks using PowerShell, Python, or Terraform.
- Collaborate with DevOps teams for CI/CD pipeline management and infrastructure as code (IaC) deployments.
- Support data governance and metadata management using Azure Purview or other data cataloguing tools.
- Follow internal processes and security guidelines to maintain data platform integrity and compliance.
Required Skills & Experience
- 5+ years of experience in a data platform support or database administration role.
- Strong hands-on experience with Azure SQL, Data Factory, and Synapse Analytics.
- Experience with Azure Data Lake, Delta Lake, and storage management in a cloud environment.
- Experience with Spark Notebooks in Synapse and troubleshooting Spark-based workloads.
- Experience with Apache Spark and Delta Lake, troubleshooting performance issues and optimizing data pipelines.
- Exposure to Snowflake and experience in troubleshooting its queries and integrations.
- Understanding of ETL/ELT processes, data ingestion strategies, and performance tuning.
- Knowledge of PowerShell, Python, or SQL scripting for automation and support tasks.
- Experience with Azure Monitor, Log Analytics, and Application Insights for performance monitoring.
- Strong analytical and troubleshooting skills, with an ability to resolve complex issues.
- Experience with ITIL framework and incident management best practices.
Nice to Have
- Familiarity with Azure DevOps, Terraform, or Bicep for infrastructure deployment.
- Knowledge of Azure Purview for data governance.
- Certification in Azure Data Engineer or Azure SQL Admin is a plus.
- Exposure with Microsoft Fabric.
About Aiviq
Aiviq is growing UK-based FinTech, specialising in developing SaaS products for the world’s investment
Managers. We are backed by Alpha Financial Markets Consulting Plc, a global Asset & Wealth Management
Consultancy.