8 of 8 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 ❯

in alignment with the business’s vision. Day-to-day of the role: Achieve individual objectives and key performance indicators as set and agreed. Continually expand knowledge of SQL Server and its related tools. Create and modify DWH objects, such as tables and views. Develop and maintain ETL processes to update the data within the DWH. … Perform tuning of the DWH, such as indexing, for both updating and consumption of data. Monitor automated tasks failed on the SQL Server estate, and review or escalate within the team as necessary. Maintain technical competence with in-depth knowledge sufficient to fulfil the role. Required Skills & Qualifications: Demonstrated alignment with our values of Fun … Supportive, Professional, Working in Partnership, and Ambitious. Strong knowledge of data warehouse development and SQL Server, including the T-SQL dialect. Understanding of SSIS development and deployment. Inquisitive nature, prepared to challenge and investigate anomalies in data. Organised, resourceful, and deadline-driven, supportive of the wider team. Highly communicative with a focus on quality More ❯

Client implementations Support product managers in working with clients to elicit requirements for tailored configurations of the product Create requirements/project documentation and implementation estimates Produce custom integration documentation and example code to enable clients to integrate the product with their systems Produce SQL scripts for implementation of requirements Support clients throughout their onboarding as … as a Business Analyst, Product Owner or Product Specialist Inquisitive, like to try stuff out, problem solver with a technical mind Strong business analysis skills Strong knowledge of SQL & XML Ability to articulate complex scenarios to clients and colleagues effectively - written and verbally Thorough, with keen attention to detail Experience of working closely with development & test teams, understanding … transfers or pension payroll - technical or operational Experience in change and transformation Experience dealing directly with clients Understanding of data modelling techniques Software engineering/coding experience SSRS/SSIS experience Equisoft is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race 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 ❯

Testing (Software Development Engineer in Test) Ideally Developer-tester hybrid. Write testing frameworks and also contribute to production code. Strong coding background (Java, Python, C#, etc.). Build integration and end-to-end automation pipelines. Performance/Load Testing Simulates real-world load and stress on systems. Ensures system performance, scalability, and reliability. Tools: JMeter, LoadRunner, Gatling, Neoload. … Functional Testing Verify that software functions as per business requirements. Integration Testing Focus on ensuring different modules/components interact correctly. Test APIs, databases, and service flows. Security Testing & Penetration Testing (Ethical Hacking) Simulate attacks to find vulnerabilities. Tools: Burp Suite, OWASP ZAP, Metasploit. CEH, OSCP, CISSP certifications an advantage Vulnerability Testing Scan systems for known vulnerabilities. Collaborate … Manual and automation testing using Appium, XCUITest, TestFairy. Data/ETL Testing Ensures accurate data flow, transformation, and validation in data pipelines. Works with SQL, Informatica, Talend, SSIS, Snowflake. AI/ML Model Testing Test models for accuracy, bias, and performance. Involves validating model predictions, fairness, and ethical AI compliance. Seniority Level Associate Industry IT Services More ❯