The role involves supporting and maintaining the Azure Data Platform by managing incidents, monitoring performance, and optimizing database operations. Responsibilities include troubleshooting ADF, Synapse Analytics, and ensuring data security compliance.
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.
Similar Jobs
Artificial Intelligence • Productivity • Software • Automation
The Senior Engineering Manager will lead two engineering teams focused on integrations, drive AI-powered productivity, and enhance team performance while managing local engineering culture in India.
Top Skills:
Ai ToolsCoding AssistantsLlms
Cloud • Information Technology • Productivity • Software • Automation
The Cloud Security Engineer will secure Boomi's multi-cloud environment by designing and implementing security controls, managing CSPM tools, and ensuring compliance with regulations.
Top Skills:
AWSAzureCspmGCPTerraformWaf
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Manage IT infrastructure, provide support, and oversee server and network operations while ensuring compliance with IT audits and controls.
Top Skills:
It Service ManagementNetwork AdministrationServer AdministrationSystems AdministrationVirtualization
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
