Associate Sql Data Engineer
Overview Associate SQL Data EngineerThe engines behind our threat-blocking tech.Mimecast are seeking an Associate Data Engineer with expertise in data integration, data manipulation and data presentation. In this role you will need to prove your ability to deliver on work items in a fast paced business environment. Outstanding technical skills should be paired with excellent communications skills as the role involves working closely with our business partners.You will be working as part of a dynamic team, delivering best-in-class data capabilities using variety of cloud based data platforms and tools. Our focus is primarily on delivering and supporting a scalable, performant and robust data platform that is utilised by our in house business partners. Given the nature of the role the main skills focus is on T-SQL, SSIS, AWS, Snowflake and Dell Boomi. Requirements You'll need: Some experience in SSIS development.Some recent development experience with SQL Server onward.The ability to work with the ensuring adherence to best practices and abiding by the coding standards.The ability to work effectively in a fast-paced environment with tight deadlines.Experience with Amazon Web Services (AWS) and or Snowflake is beneficial. A minimum of 2 years experience working with data integration and manipulation tools.Key Responsibilities: Collaborate with and support the development activities of both the Data Engineering and the Boomi teams and their internal customers.Design and create tables, views, partitions, stored procedures, functions and other database objects.Build SQL Server Integration Services (SSIS) packages and projects in Visual Studio to support the extraction, transformation and loading (ETL) of data.Build Boomi integrations to facilitate the flow of data between internal systems.Document processes and procedures for development and workflow needsEnsure that the data lifecycle is upheld for active, inactive, and restored DatabasesEvaluate technology and techniques to implement and maintain databases and database environment.Collaborate with the development team and leadership to assist and deliver on an array of projects.Support the transition from SQL Server to Snowflake and other adjacent cloud based technologies.