Description
You will develop, maintain, and optimize database features and ETL pipelines to meet business requirements.
Responsibilities
- Maintain existing features and resolve bugs or ad-hoc requests.
- Optimize complex SQL queries and stored procedures using execution plan tuning, indexed views, and partitioning.
- Design and maintain ETL pipelines within Azure Data Factory for cloud and hybrid environments.
- Manage CI/CD pipelines for SQL and Power BI artifacts using Azure DevOps and Git.
- Automate data refresh schedules and provide client support through data presentation and technical resolution.
Required Skills
- 5+ years of experience in SQL development.
- Advanced T-SQL proficiency including CTEs, CROSS APPLY, TRY/CATCH, MERGE, and window functions.
- Experience with Azure Data Factory for ETL processes.
- Proficiency with Azure and Git.
- Experience using DAX for custom measures and calculated columns.
- Ability to use Azure Boards and Agile tools for sprint management.
- Experience tuning performance to reduce report load times.
- Bachelor's degree or equivalent graduate qualification.