As a Senior SQL Server Back-End Developer, you will play a pivotal role in shaping and extending our data infrastructure to meet evolving business needs. You will be responsible for maintaining and enhancing our existing MS SQL Server-based data warehouse by developing and integrating new features, while ensuring thorough documentation and scalable design.
In this role, you will lead the development and management of ETL (Extract, Transform, Load) processes using SSIS (SQL Server Integration Services), facilitating seamless integration between various enterprise platforms such as SAP, JIRA, and other key systems. A key aspect of your role will involve supporting and driving our migration to the cloud, with a particular focus on Microsoft Fabrics. This is an excellent opportunity to be at the forefront of cutting-edge technologies and cloud solutions.
Your key tasks
- Extend and optimize data models to support new business functionalities and processes, ensuring robust, scalable, and high-performance database solutions.
- Develop and maintain ETL processes using SSIS to integrate data from multiple sources including SAP, JIRA, and other business platforms.
- Design and implement database components using T-SQL, ensuring efficient query execution and database performance tuning.
- Monitor and support the daily operations of our Datawarehouse, resolving issues and providing technical support as necessary.
- Manage and maintain source code in BitBucket repositories, ensuring version control best practices and collaboration.
- Contribute to the cloud migration strategy, particularly around Microsoft Fabrics, leveraging your expertise in SQL Server and cloud technologies to ensure a smooth transition.