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
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
The role involves developing manufacturing processes, supporting robotic simulation, and improving equipment for high-quality part production.
Top Skills:
Body Robotic SimulationEquipment/Tooling AlternativesManufacturing ProcessesProcess Simulate
Fintech • Financial Services
The role involves ensuring quality through UAT and Test Automation, collaborating with various teams to validate requirements, execute test plans, and support production implementations.
Top Skills:
AlmCore JavaJIRAPower BISeleniumSQLTableau
Fintech • Financial Services
The role involves leading software engineering initiatives, resolving technical challenges, and collaborating on digital marketing solutions using Adobe Experience Platform and related products.
Top Skills:
Adobe AnalyticsAdobe CampaignAdobe Experience CloudAdobe Experience PlatformAPIsAudience ManagerCustomer Journey AnalyticsData Science WorkspaceJSONRtcdp
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.
