6 of 6 SQL Server Integration Services Jobs in Somerset

ETL/ELT processes to ingest data from the new ERP system into Snowflake. Architect and develop the Snowflake data warehouse to support reporting and analytics, incorporating existing SQL Server-based business logic, while optimizing for performance, scalability, and usability. Collaborate closely with business users to understand, qualify, design, build, test, and deliver their requirements. Coordinate … solutions, ensuring adherence to Service Level Agreements. Guide the organization in data movement, storage, and retrieval strategies to maximize technological efficiency. Design, implement, and manage BI infrastructure and services, delivering insights aligned with IT strategy and roadmap. Act as a subject matter expert in data analytics, modeling, warehousing, data mining, and presentation to support future projects. Ensure smooth … and business logic mapping Proven ability to convert business requirements into solutions Experience with Power BI Desirable: Experience with Business Systems reporting, including ERP Knowledge of MS BI stack (SSIS, SSAS) Familiarity with Microsoft Dynamics AX or IFS Manufacturing and supply chain experience Understanding of financial principles Experience with business KPI reporting The Successful Applicant Key Skills & Experience: Same as More ❯

processing • Proficient in structured mark-up languages, SGML, XML • Proficient in data manipulation languages, including XSL, XSLT, XSL-FO, • Proficient in relational database development: o To create advanced SQL queries, stored procedures and triggers o In improving and optimising … SQL queries and indexes o To carry out data migration within SSDT • Familiarity in data warehouse using the Microsoft stack: o Knowledge of ETL and usage of SSIS o Ability to create DMX queries and optimise current ones o Knowledge on creating/maintaining Cubes with usage of the Analysis Service o Knowledge of the Kimball method • Familiarity More ❯

learn in a fast-paced, supportive environment, this apprenticeship is the perfect place to grow and make a real impact. Role Design, develop and maintain SSRS reports and SQL queries … to support business operations. Optimise SQL views for Tableau, ensuring clear and structured data presentation. Manage and maintain SQL databases, including indexing, stored procedures and SSIS package management. Troubleshoot and resolve SQL performance issues and database errors. Develop and support API integrations between SQL databases and business systems. Collaborate with development team … to scope, test and deploy system integrations. Assist with website development testing where database integration is required. Training Your training will be delivered in blocks every 4-6 weeks; this will be in our online classrooms. You will be working with a specialist coach from Baltic Apprenticeships throughout the process. This apprenticeship provides the skills, qualification and experience More ❯

develop and maintain reports and dashboards. Benefits for the successful Junior Data Engineer 25 days holiday + bank holidays, rising over time Discretionary bonus Employee wellbeing programme (GP Services, eye tests, flu jabs etc) Enhanced maternity and paternity Personal & professional development Cycle to … work scheme Experience needed for the Junior Data Engineer SQL Server experience Design, develop and maintain reports and dashboards using SSRS & Power BI Experience with SSIS Data modelling and database management Excellent analytical experience Strong communications skills The ability to build rapport with stakeholders If you are interested in this role, please contact Alex MacDermott directly More ❯

providing 1st and 2nd line support, resolution of tickets and service requests within the defined Service Level Agreements, as well as direct involvement in the deployment, configuration and integration of the software. Responsibilities Providing direct Application Support and consulting on the implementation and usage of company software. Managing own workloads, ensuring support tickets are in adherence to SLAs. … diagnostic skills are essential. Hands on intermediate level technical knowledge of both hosted and remotely administered environments and infrastructure on Windows platforms. Administration, tuning and querying of Microsoft SQL Server 2005-2012, SSRS and SSIS. Troubleshooting of Windows Server Infrastructure and … application issues under tied SLAs. Basic knowledge of Microsoft Windows Active Directory Infrastructure integration, group permissions and security policies. To be able to write SSRS reports and SSIS packages. An understanding of LAN/WAN/TCP/IP/Ports and Protocols. An understanding of network protocols and in particular VOIPSIP technologies An understanding of hosted applications More ❯

providing 1st and 2nd line support, resolution of tickets and service requests within the defined Service Level Agreements, as well as direct involvement in the deployment, configuration and integration of the software. Responsibilities Providing direct Application Support and consulting on the implementation and usage of company software. Managing own workloads, ensuring support tickets are in adherence to SLAs. … diagnostic skills are essential. Hands on intermediate level technical knowledge of both hosted and remotely administered environments and infrastructure on Windows platforms. Administration, tuning and querying of Microsoft SQL Server 2005-2012, SSRS and SSIS. Troubleshooting of Windows Server Infrastructure and … application issues under tied SLAs. Basic knowledge of Microsoft Windows Active Directory Infrastructure integration, group permissions and security policies. To be able to write SSRS reports and SSIS packages. An understanding of LAN/WAN/TCP/IP/Ports and Protocols. An understanding of network protocols and in particular VOIP\SIP technologies An understanding of hosted More ❯