Deputy Manager - Operations (Data Engineer)
Job Summary:
We are seeking a highly skilled and motivated T-SQL and Azure Data Factory Developer with strong experience in business intelligence (BI) development, database management, and data modeling. This role requires proficiency in T-SQL development, Python, and tools such as Microsoft SQL Server, SSIS, SSAS, and Power BI. The ideal candidate will be responsible for designing, developing, and optimizing data processes and working collaboratively with business stakeholders to meet data analysis needs.
Key Responsibilities:
- Develop and optimize complex T-SQL queries, stored procedures, functions, and views to support application development and data analysis.
- Design, develop, and maintain ETL (Extract, Transform, Load) processes for data using Azure Data Factory (ADF), Synapse Notebooks, SSIS, or other relevant tools.
- Create and maintain data models, cubes, and dashboards using Microsoft SQL Server Analysis Services (SSAS) Tabular and Power BI.
- Collaborate with business stakeholders to understand their data requirements and translate them into technical specifications and BI solutions.
- Perform data analysis, troubleshooting, and performance tuning to resolve data inconsistencies and database-related issues.
- Ensure data integrity, security, and compliance with best practices and standards in database development and BI implementation.
- Stay updated with industry trends in T-SQL, BI tools, and technologies and recommend improvements to enhance system performance and data efficiency.
- Provide technical support and guidance to junior developers and team members.
- Work independently and manage multiple tasks effectively to meet deadlines in a fast-paced environment.
- Communicate clearly and effectively with team members, stakeholders, and management, both verbally and in writing.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Excellent communication skills in English, both verbal and written.
- Minimum of 4 years of experience in T-SQL development and business intelligence (BI) development.
- Proficiency in writing complex T-SQL queries, stored procedures, functions, and views.
- Experience with Python programming.
- Experience with Microsoft SQL Server, SSIS, SSAS, and Power BI data modeling.
- Experience with Azure Data Factory and Synapse Workspace.
- Strong understanding of database concepts, data modeling, and optimization techniques.
- Strong problem-solving skills and attention to detail.
- Ability to work independently and collaborate effectively in a team environment.
Preferred Skills:
- Experience working in a UK shift schedule.
Job Summary:
We are seeking a highly skilled and motivated T-SQL and Azure Data Factory Developer with strong experience in business intelligence (BI) development, database management, and data modeling. This role requires proficiency in T-SQL development, Python, and tools such as Microsoft SQL Server, SSIS, SSAS, and Power BI. The ideal candidate will be responsible for designing, developing, and optimizing data processes and working collaboratively with business stakeholders to meet data analysis needs.
Key Responsibilities:
- Develop and optimize complex T-SQL queries, stored procedures, functions, and views to support application development and data analysis.
- Design, develop, and maintain ETL (Extract, Transform, Load) processes for data using Azure Data Factory (ADF), Synapse Notebooks, SSIS, or other relevant tools.
- Create and maintain data models, cubes, and dashboards using Microsoft SQL Server Analysis Services (SSAS) Tabular and Power BI.
- Collaborate with business stakeholders to understand their data requirements and translate them into technical specifications and BI solutions.
- Perform data analysis, troubleshooting, and performance tuning to resolve data inconsistencies and database-related issues.
- Ensure data integrity, security, and compliance with best practices and standards in database development and BI implementation.
- Stay updated with industry trends in T-SQL, BI tools, and technologies and recommend improvements to enhance system performance and data efficiency.
- Provide technical support and guidance to junior developers and team members.
- Work independently and manage multiple tasks effectively to meet deadlines in a fast-paced environment.
- Communicate clearly and effectively with team members, stakeholders, and management, both verbally and in writing.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Excellent communication skills in English, both verbal and written.
- Minimum of 4 years of experience in T-SQL development and business intelligence (BI) development.
- Proficiency in writing complex T-SQL queries, stored procedures, functions, and views.
- Experience with Python programming.
- Experience with Microsoft SQL Server, SSIS, SSAS, and Power BI data modeling.
- Experience with Azure Data Factory and Synapse Workspace.
- Strong understanding of database concepts, data modeling, and optimization techniques.
- Strong problem-solving skills and attention to detail.
- Ability to work independently and collaborate effectively in a team environment.
Preferred Skills:
- Experience working in a UK shift schedule.