1 to 25 of 56 SQL Server Integration Services Jobs in the Midlands

Monitoring and tuning data loads and queries Administer all requirements and design various functional specifications for data Develop, maintain and monitor data pipelines to automate the collection and integration of data from diverse sources Implement data normalisation techniques to ensure data consistency and integrity across different datasets Design and develop reports, dashboards, and visualisations in our BI application … closely with cross-functional teams including business analysts, technical specialists and business stakeholders Skills & Experience Hands-on experience with data integration tools like Azure Data Factory or SSIS Developing reports and custom queries using T-SQL Experience with Azure SQL Database Experience designing, developing and implementing data warehouse solutions Solid understanding of data normalisation … years’ experience in data analysis, reporting, data warehousing and business intelligence Experience with programming languages like Python or R is a plus Previous work experience in the financial services sector An understanding of the mortgage, general insurance, and wealth processes. An understanding of point of sale/customer relationship management platform would be highly regarded 360 Lifecycle, Unit More ❯

Stakeholder Collaboration: Partner with business units and IT teams to capture reporting requirements and translate them into effective technical solutions. BI Capability Transition: Lead the transition of BI services from the shared IT function to an internal capability, ensuring the design, implementation, and ongoing management of a fully independent BI environment. Process Improvement, Automation & Innovation: Identify and drive … will have: Data Analysis & Insight: Strong analytical skills with the ability to identify trends, anomalies, and actionable insights from complex data sets. Technical Expertise: Proficient in BI reporting, SQL, data modelling, and data warehouse concepts, with a focus on accuracy and scalability. Problem Solving: Demonstrates initiative in resolving data issues and implementing data-led solutions to support continuous … in data analysis, reporting, or data warehousing. Sofico Miles, Salesforce, or Dataflow Clarity experience (or equivalent systems knowledge). Proficiency with SQL and ETL tools such as SSIS, with experience in data warehouse architecture, modelling, and optimisation. Familiarity with BI platforms including Business Objects, Pan Intelligence, or similar reporting/visualisation tools (e.g., Power BI, Tableau, Qlik). More ❯

for a Mid-Level Database Architect is responsible for designing, developing, and maintaining scalable, high-performance databases and data models that support enterprise systems. The role includes data integration, performance optimization, and enforcing data governance and security policies. This position works closely with application developers, data analysts, and system architects to support mission-critical operations and business intelligence … data warehouses. Develop and maintain data models, ER diagrams, and metadata repositories. Create, tune, and monitor database objects such as tables, views, indexes, stored procedures, and triggers. Optimize SQL queries and database configurations to ensure high availability and performance. Collaborate with software development teams to ensure proper integration and normalization of data. Implement and maintain data … RDS, Azure SQL, or Google Cloud SQL). Solid understanding of data modeling techniques and normalization standards. Experience with data integration tools (e.g., SSIS, Informatica, or Talend) and scripting (e.g., Python, Shell). Understanding of database security best practices and regulatory requirements (e.g., Experience with NoSQL or big data technologies (e.g., MongoDB, Cassandra, Hadoop More ❯

SQL Server databases and our Data Warehouse, ensuring optimal performance and reliability. Maintain SQL Server Integration Services (SSIS) packages for ETL processes. Work with Azure Data Factory (ADF) for cloud-based data processing and transformation. Implement SQL replication strategies and maintain data consistency across distributed systems. … Develop and maintain Power BI and SSRS reports for data visualization and business intelligence needs. Work with Azure SQL and managed instances, optimizing for scalability and performance. Help Developers implement CI/CD pipelines for SQL development using Azure DevOps to automate database deployments. Collaborate with development and DevOps teams to ensure smooth database operations and … SQL, with a proven ability to write and optimize complex queries. Database schema design and performance tuning. Power BI and SSRS reporting tools for business intelligence solutions. SSIS for ETL processing and automation. Azure Data Factory (ADF) and cloud-based data solutions. SQL replication strategies and data synchronization techniques. Azure SQL and managed instances More ❯

dispersed data sets to be accessed, analysed and visualised through tools such as Power BI and Excel power query. The current technology stack is predominantly based on Microsoft SQL databases, and we are focussing our data strategy on the Microsoft Azure, Fabric and Power BI toolsets. What will you be doing? The Key Responsibilities of the role will … projects Experience building and maintaining ETL processes Experience producing data models and understanding where to use different types of data model Working knowledge of Microsoft SQL – including SSIS and SSRS Understanding of local government services Your knowledge and certifications: 2 years + working with Azure data engineering tools e.g: Azure Data factory Azure Synapse Azure SQL More ❯

using the Microsoft Fabric/Power BI tooling whilst also assisting during the migration from Qlik Sense and the DWH (based on SQL Server/SSIS). The role is primarily focused on ingesting data (ERPs, SQL Sharepoint etc) into MS Fabric and transforming this into governed data for use in other systems such … Microsoft Azure/Power BI. Experience of analysing and diagnosing complex data issues and then explain key findings in clear business language to end users Experience of ETL and SSIS development to read in data and apply data profiling and data validation techniques Designing and building the user facing Power BI reports/apps/dashboards including in-depth use … in a manufacturing environment ideally within the aerospace industry Experience of complex app/DWH development and support using Qlik Sense and SQL Server/SSIS Experience of KPI reporting Experience of managing finance concepts and terminology Experience of predictive analytics and machine learning Development using Python/R Experience of developing and supporting BI systems More ❯

SQL Analyst Up to £45K plus benefits Birmingham Role Summary We are seeking a skilled and motivated SQL Analyst. In this role, you will play a vital part in analysing, creating, implementing, and maintaining data infrastructure, ensuring the seamless operation of corporate IT systems. This is a unique opportunity to contribute to our journey of innovation … system interfaces and automation using APIs and web services. Experience Required In-depth knowledge of Microsoft SQL Server (2017 and above), including SSMS, SSRS, SSAS, SSIS, and SQL scripting. Expertise in database development, data cubes, and data marts. Proficiency with data visualisation tools like Power BI, Tableau, or SAP BusinessObjects. Familiarity with cloud data … services such as Azure SQL or AWS Redshift. Understanding of IT networking technologies (e.g., DNS, DHCP). Strong experience in IT, specifically in database administration and data solutions. More ❯

Company Description Version 1 has celebrated over 28 years in Technology Services and continues to be trusted by global brands to deliver solutions that drive customer success. Our expertise enables our customers to navigate the rapidly changing Digital-First world we live in. We foster strong partnerships with leading technology giants including Microsoft, AWS, Oracle, Red Hat, OutSystems … Dataverse. Experience configuring and deploying Dynamics 365 applications. Experience with Power Apps Test Studio or other Power Platform testing solutions. Experience in configuring and using other data stores (SQL/SharePoint/Lists). Experience developing and deploying Microsoft Teams Apps. Experience with Azure DevOps (or similar tools) for CI/CD and backlog/progress tracking. Experience … BI solutions would be a plus. Experience integrating Power Apps solutions with APIs or third-party solutions. Development experience using Microsoft stack (.NET/C#/TypeScript/SQL Server). Experience with Azure DevOps (or similar tools) for CI/CD and backlog/progress tracking. Experience with Microsoft Azure PaaS/Azure Integration More ❯

approach to challenges and ever-evolving projects Working in an Agile landscape - making technical decisions/recommendations where there is uncertainty Creation of fault-tolerant data ingestion pipelines in SSIS/KingswaySoft/Data Factory/data flows using Linked Services, Integration Datasets Requirements gathering expertise, including: Leading workshops Elaboration of user stories and refining these … to an Engineer-friendly technical approach Documentation of approach Creation of mapping specifications between legacy and CRM/ERP/Finance applications Integration to D365, Dataverse solutions or other SaaS applications Extraction of data from a variety of sources including SQL databases, document databases, graph databases, web APIs, etc. Build of dashboards to reconcile migrated data … 10+ years’ experience of Consulting, Nonprofit, Government or Financial Services 7+ years’ experience of D365 CRM and hands-on skills with ETL tools. Desirable Experience Migration of data from Salesforce, Care NG, Raisers Edge, Lotus Notes, dotdigital, Hubspot, Faststats, Enthuse, GoFundMe, Everyday Hero, Memory Giving, PayPal, World Pay, Gift Aid processors, JustGiving ETL/ELT best practice approaches More ❯

in a SQL Developer role. This role is home based – there may be some very occasional travel within the UK. Key skills: • T-SQL • SSRS • SSIS • Ideally some knowledge of .Net (C# OR VB). The position offers a great opportunity to develop within an established business. We believe in empowering our team to look after … questions as required. Attention to detail is key. A good team player is a must. Key responsibilities • T-SQL development • Report development in SSRS • ETL development using SSIS • Following development processes including keeping source control updated • Basic asp.net web development • Supporting system testing and resolving defects • Putting together test documentation, deployment plans • Resolving support incidents • Keep up-to … of MS SQL Server • Writing complex T-SQL • Report development (ideally in SSRS, or in a Business Intelligence Environment) • ETL development (ideally in SSIS) • Previous experience of using ASP.net (VB.net) - not essential. • Experience of Source control and DevOps would be a bonus • Any knowledge of Power BI would be useful. Your normal working hours More ❯

the latest Microsoft Fabric technology Essential Skills: DBT experience – (required) Strong Python programming skills Microsoft Azure/Synapse background (Data Factory, Azure SQL DB, Azure Data Lake, SSIS, SSAS, SSRS). Experience with Microsoft Fabric (preferred but not essential) Power BI or similar visualisation tools Willingness to work in a multi-cloud environment as they continue to expand More ❯

data environments (AWS, Azure), ensuring scalability and resilience. Collaborating on project planning, risk management, and technical documentation. Driving innovation by evaluating emerging tools, technologies, and methodologies. Supporting systems integration, data migration, and analytics solution development. The Person We're looking for a seasoned data engineering professional with proven leadership experience and strong technical capabilities in cloud environments. Essential … and a pragmatic, team-first approach. Excellent problem-solving and communication skills, including the ability to convey complex concepts to non-technical stakeholders. Desirable (but not essential): Experience with SSIS, AWS or Azure Data Factory. Familiarity with Hadoop, Jenkins, or DevOps practices including CI/CD. Cloud certifications (Azure or AWS). Knowledge of additional programming languages or ETL tools. More ❯

development team involved in the design, development, testing, documenting and deployment of D365-based solutions in accordance with agreed my client standards to support and maintain integrated IT services to the business. You will extend the capabilities of the CRM team by providing the business with functional and technical expertise specifically in Microsoft Dynamic 365 CE. You will … Customer Service Operations. Strong understanding of KingswaySoft for data integration. Demonstrable experience with SQL and SQL Server Integration Services (SSIS) Experience gained in and ability to debug plug-ins and workflows. Proficient in server-side and client side development languages to extend a Dynamics 365 implementation - C# (.NET More ❯

and driving continuous improvement of the service to ensure that our proposition is industry-leading. Creation of mapping specifications between legacy and CRM/ERP/Finance applications Integration to D365, Dataverse solutions or other SaaS applications As a guardian for Technical Excellence for Data Migration, you will assist in the growth of the team via the Recruitment … approach to challenges and ever-evolving projects Working in an Agile landscape - making technical decisions/recommendations where there is uncertainty Creation of fault-tolerant data ingestion pipelines in SSIS/KingswaySoft/Data Factory/data flows using Linked Services, Integration Datasets. Requirements gathering expertise, including: Leading Workshops Elaboration of "User Stories" and refining these … of reliability patterns in ETL pipelines Techniques and tools for sanitizing data prior to use Azure data certifications Azure Synapse/Fabric: Synapse-link, Fabric Link, on-demand SQL engine Use of python in Jupyter notebooks for data processing Azure storage technologies and cost/performance characteristics Power BI, DAX, data flows Data Governance tools (e.g. Microsoft Purview More ❯

extent - within DPS and Liberate (Classic & SE). Develop IT processes and workflows using Development toolkits. Develop integration and data transfers (including using SQL and SSIS) between client and internal systems. Identify development opportunities to improve IT processes and automation, developing reliable and innovative solutions. Gather, interpret, and translate business requirements into functional and technical specifications … and knowledge bases as required. Work through the entire product lifecycle; from initial requirements gathering, workshops, design, and construction. Collaborate with fee earners, managers, department heads and support services to identify opportunities for system improvement and automation. Provide regular and effective progress updates to ensure the management of delivery risks and alignment with IT standard governance. Mentor junior … assist with the provision of technical leadership within the Systems Development Team. Assist and with user training and support. Troubleshoot problems. Create and maintain reporting solutions using MS SQL reporting services and other reporting tools. Support the wider IT operations by collaborating with the wider expertise across the IT function to optimise delivery. Skills, Knowledge and More ❯

Senior BI Developer Location: West Midlands (1 day/week on-site) Salary: Up to £48,000 An established UK-based financial services provider is seeking a Senior BI Developer to join its Underwriting and Pricing Data Team. This role is central to a major data transformation initiative, offering a chance to shape high-impact solutions across pricing … and cleaning data, creating dashboards in Power BI and presenting insights back to stakeholders. YOUR SKILLS AND EXPERIENCE • Advanced SQL skills • ETL experience (Azure Data Factory or SSIS preferred) • Strong data visualisation skills (ideally Power BI) • Proven ability to interpret and communicate data insights • Experience managing workflows or mentoring peers • Agile mindset with critical and lateral thinking skills More ❯

Drive Innovation as a Cloud and Managed IT SQL Database Administrator! Intercity Technology is seeking an experienced and proactive Cloud and Managed IT SQL Database Administrator to join our dynamic Managed IT function on a 12 month Fixed Term Contract . This strategic and hands-on role is focused on stabilising, modernising, and optimising the internal … impact, this is your opportunity to shape the future of our data platforms. Key Responsibilities: Platform Discovery & Architecture Review Lead a structured review of our MOES and Affinity SQL Server environments. Identify and document risks, inefficiencies, and architectural issues. Collaborate with stakeholders to understand system history and pain points. Produce a detailed findings report with prioritised … security best practices. Excellent communication and stakeholder engagement skills. Desirable Skills Experience with business-critical platforms (e.g., CRM, ERP, Portals). Familiarity with MySQL or other RDBMS. Knowledge of SSIS, SSRS, ETL processes, or reporting platforms. Exposure to Azure SQL or cloud-based database hosting. Understanding of CI/CD and DevOps practices for databases. Certifications (Required or More ❯

will join a strong team who design, develop, deploy and maintain scalable data pipelines and analytics solutions. The Analytics Engineer is responsible for creating, enhancing and maintaining reporting services to meet requests for new functionality and support internal and external users. The Analytics Engineer will also be responsible for resolving support requests in a timely and accurate fashion … technical solutions. A very strong command of SQL, both Athena and MSSQL A good understanding of methods for data manipulation, analysis, and automation tasks. Experience with Microsoft SSIS ETL pipelines. Experience with AWS tools such as S3, Glue, Redshift, Lambda, and Athena for building scalable data pipelines and architectures. Experience in developing dashboards and reports using MicroStrategy and More ❯

and analytics workflows Evaluating new tools and technologies to improve the data analytics platform Architecting or reviewing advanced data analytics solutions Leading database management tasks Supporting data migration, integration, and transformation processes Contributing to project planning, risk identification, and mitigation activities The Person This role is ideal for … an experienced data engineer with a strong technical foundation and the ability to collaborate effectively in agile, cross-functional teams. Essential Experience Includes Proficiency with ETL platforms such as SSIS, AWS, or Azure Data Factory Experience configuring/administering AWS or Azure data platforms and analytics services like Power BI or Pentaho BA Strong working knowledge of Python More ❯

document data strategies. Preferably strong ERP skills, specifically SAP and/or Workday Strong SQL Server skills including SQL, stored procedures and functions. SSIS beneficial too. Strong logical understanding of relational data concepts. Good general development skills including windows permissions file shares and scheduled jobs. Familiarity with modern data platforms, cloud technologies, and data … integration tools. Excellent communication and stakeholder engagement skills. Strong analytical and problem solving skills with diligent attention to detail and quality of output Experience Proven experience leadinglarge-scale data migrationprojects in enterprise environments during all phases of the lifecycle of an ERP implementation. Experienced in working with both software vendors and system integrators. Experience managingcross-functional teams and More ❯

CRM journey logic Exceptional time management skills and the ability to juggle multiple priorities You’ll stand out if you’ve worked with: SQL (Stored Procedures, SSMS), SSIS Cloud technologies like Snowflake and AWS Glue REST APIs and data integration strategies Campaign platforms like Acoustic, DotDigital, Salesforce Marketing Cloud Analytics and automation platforms such as Apteco More ❯

CRM journey logic Exceptional time management skills and the ability to juggle multiple priorities You’ll stand out if you’ve worked with: SQL (Stored Procedures, SSMS), SSIS Cloud technologies like Snowflake and AWS Glue REST APIs and data integration strategies Campaign platforms like Acoustic, DotDigital, Salesforce Marketing Cloud Analytics and automation platforms such as Apteco More ❯

CRM journey logic Exceptional time management skills and the ability to juggle multiple priorities You’ll stand out if you’ve worked with: SQL (Stored Procedures, SSMS), SSIS Cloud technologies like Snowflake and AWS Glue REST APIs and data integration strategies Campaign platforms like Acoustic, DotDigital, Salesforce Marketing Cloud Analytics and automation platforms such as Apteco More ❯

CRM journey logic Exceptional time management skills and the ability to juggle multiple priorities You’ll stand out if you’ve worked with: SQL (Stored Procedures, SSMS), SSIS Cloud technologies like Snowflake and AWS Glue REST APIs and data integration strategies Campaign platforms like Acoustic, DotDigital, Salesforce Marketing Cloud Analytics and automation platforms such as Apteco More ❯

CRM journey logic Exceptional time management skills and the ability to juggle multiple priorities You’ll stand out if you’ve worked with: SQL (Stored Procedures, SSMS), SSIS Cloud technologies like Snowflake and AWS Glue REST APIs and data integration strategies Campaign platforms like Acoustic, DotDigital, Salesforce Marketing Cloud Analytics and automation platforms such as Apteco More ❯