DB2 Consultant

DB2 Consultant

Full-Time 47250 - 57750 £ / year (est.) Remote
C

At a Glance

  • Tasks: Redesign and optimise critical reporting processes using Db2 and DataStage.
  • Company: Join a forward-thinking public sector organisation focused on impactful data solutions.
  • Benefits: Competitive day rate, remote work flexibility, and valuable experience in a dynamic environment.
  • Other info: Opportunity for knowledge transfer and collaboration with diverse teams.
  • Why this job: Make a difference in healthcare data management while enhancing your technical skills.
  • Qualifications: Experience with IBM Db2, SQL Server, and strong ETL skills required.

The predicted salary is between 47250 - 57750 £ per year.

We are seeking an experienced DB2 Consultant with strong expertise in IBM Db2/Db2 Warehouse, Microsoft SQL Server, and data migration/transformation projects within complex enterprise environments. The consultant will support the redesign and optimisation of critical reporting and metrics processes, ensuring compatibility between legacy and future systems while improving performance, maintainability, and scalability. The successful candidate will work closely with technical and business stakeholders to redesign existing processes, convert SQL Server logic to Db2-compatible solutions, and provide strategic guidance on integrating historical data with a new Electronic Patient Record (EPR) platform.

Essential Skills & Experience

  • Strong hands-on experience with IBM Db2 and Db2 Warehouse
  • Advanced knowledge of Microsoft SQL Server and T-SQL scripting
  • Experience converting SQL Server-based solutions to Db2 environments
  • Strong ETL and data integration experience, ideally with IBM DataStage
  • Experience designing scalable database and reporting solutions
  • Strong performance tuning and optimisation skills
  • Excellent documentation, stakeholder engagement, and knowledge transfer skills

Priority 1: Statistical Process Control (SPC) Process Redevelopment

The organisation currently operates an SPC process that pushes a large volume of metric data through a Microsoft SQL Server script originally developed. The existing solution contains extensive warning and annotation sections that are no longer required and requires modernisation to improve maintainability and performance. The consultant will review the current implementation and redesign the process using a modular approach, leveraging DataStage jobs and Db2-compatible functionality.

Key Responsibilities

  • Review and analyse SQL Server script
  • Identify and document the core business and technical logic
  • Design and develop a modular replacement solution using DataStage and Db2
  • Convert SQL Server-specific functions and processes into Db2-compatible equivalents
  • Create intermediate data structures and temporary tables where appropriate
  • Conduct testing and validation to ensure accuracy and performance
  • Produce technical documentation and operational procedures
  • Deliver knowledge transfer and handover sessions to internal teams

Priority 2: EPR (Rio) Metrics Transformation

The organisation is implementing a new Electronic Patient Record (EPR) system, which will significantly impact its existing reporting and metric processes. Many metrics will require redesign to account for changes in data structures and source systems. A key challenge will be maintaining three years of historical SPC reporting by combining data from both legacy and new EPR platforms while ensuring accuracy and performance.

Key Responsibilities

  • Assess existing and future EPR data structures, including Rio
  • Define the optimal strategy for integrating historical and future metric datasets
  • Design solutions for combining legacy and new EPR data sources
  • Evaluate impacts on existing reporting and SPC processes
  • Identify opportunities to improve data quality, reporting efficiency, and performance
  • Develop proof-of-concept solutions and representative implementations
  • Conduct testing, validation, and performance benchmarking
  • Produce detailed technical documentation
  • Deliver knowledge transfer and handover sessions to internal teams

Desirable Experience

  • Digital reporting methodologies
  • Healthcare data warehouse environments
  • Clinical and operational reporting systems
  • Data migration and platform transition programmes
  • Statistical Process Control (SPC) reporting frameworks
  • Information Server/DataStage

Deliverables

  • Redesigned SPC process within Db2/DataStage
  • Converted and optimised SQL logic
  • EPR integration strategy and recommendations
  • Proof of Concept (POC) implementation
  • Technical and support documentation
  • Knowledge transfer and operational handover to internal teams

DB2 Consultant employer: Consult

At Consult, we pride ourselves on being an exceptional employer that fosters a dynamic and inclusive work culture. Our North America team is dedicated to professional growth, offering robust training and development opportunities while working in a fast-paced, innovative environment. Join us to be part of a collaborative team that values your contributions and supports your career aspirations in the exciting MedTech sector.

C

Contact Details:

Consult Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land DB2 Consultant

✨Get Involved in Data Science Meetups

Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Consult!

✨Show Off Your Projects

Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like DB2 Consultant at Consult.

✨Leverage Professional Networks

Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Consult.

✨Apply Directly through Our Website

When you find a suitable opening like DB2 Consultant at Consult, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!

We think you need these skills to ace DB2 Consultant

IBM Db2
Db2 Warehouse
Microsoft SQL Server
T-SQL scripting
Data migration
Data transformation
ETL

Some tips for your application 🫡

Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!

Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!

Craft a Tailored Cover Letter:For a full-time role at Consult, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.

Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Consult. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!

How to prepare for a job interview at Consult

✨Brush Up on Your Statistics

For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!

✨Showcase Your Projects

Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!

✨Get Comfortable with Python and R

Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Consult!

✨Prepare for Case Studies

Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.