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.
Top Skills
Spark
Application Insights
Azure Data Factory
Azure Devops
Azure Monitor
Azure Sql
Delta Lake
Log Analytics
Powershell
Python
Snowflake
Synapse Analytics
Terraform
Similar Jobs
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
The Account Executive for Mid Market in India manages mid-sized customer portfolios, drives growth strategies, nurtures client relationships, and collaborates with internal teams.
Top Skills:
Crm Software
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
The Fund Accountant manages client-facing fund services for hedge, private equity, and debt funds, overseeing complex fund structures and accounting activities.
Top Skills:
Client ReportingDebt FundsFinancial ReportingFund AccountingHedge FundsPrivate Equity
Fintech • Financial Services
Lead software engineering initiatives, design and develop applications, mentor junior engineers, and collaborate on solutions in capital markets.
Top Skills:
AngularArtifactoryAzureCoherenceGCPGitIgniteJavaJavaScriptJenkinsKafkaMicroservicesMs Sql ServerNode.jsOcpOraclePcfReactRedisSolaceSonarSpring BootSpring Framework
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.
