Database Developer
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+30 more
Job description
As a Database Developer, you will design, develop and maintain the CIPDβs core databases and data pipelines as part of the Development Team, upholding high coding standards and data quality. Youβll be enhancing business operations, insight, revenue and services by delivering reliable, well-governed and performant data. What youβll be doing
- Design, build and maintain database schemas, tables, views, functions and stored procedures using T-SQL and PL/SQL
- Optimise queries, indexes and stored procedures for performance and scalability
- Develop and monitor ETL/ELT pipelines to transform, migrate and integrate data using SSIS, Python and Microsoft Fabric
- Contribute to data warehouse models and data engineering solutions in line with best practice
- Develop and support master data management (MDM) processes, including matching, merging and data stewardship, using tools such as Semarchy XDM
- Work with the Data team and stakeholders to agree data quality baselines and improve data across core systems
- Write, test and deploy SQL changes and fixes through Azure DevOps source control and release processes
- Automate routine data tasks using SQL Agent, Python and pipeline orchestration tools
- Support and maintain integrations with other core systems, including web services and APIs
- Plan and execute changes to live data, applying sound change and risk management
- Take part in code reviews, share knowledge with colleagues and proactively recommend improvements
- Provide technical support for BAU and project activities, working to release cycles and incident SLAs
- Create and maintain technical documentation, including data dictionaries and data lineage
Requirements
- Proven experience in database development
- Excellent T-SQL skills, with experience of SQL Server and Azure SQL
- Working knowledge of PL/SQL (Oracle)
- Experience building ETL processes using SSIS or similar tools
- Python for data processing and automation
- Understanding of data warehousing concepts, such as dimensional modelling
- Good understanding of database design, indexing and performance tuning
- Experience with data migration and data cleansing
- Experience with source control and CI/CD (Git, Azure DevOps)
- Experience of planning and executing database changes, including risk and change management
- Understanding of IT service management and experience working to SLAs
- Analytical, proactive approach to problem solving, with strong attention to detail
- Microsoft Fabric (Lakehouse, Warehouse, Data Factory pipelines, notebooks)
- Experience with Semarchy xDM or other MDM tools
- Knowledge of MDM concepts, such as golden records, matching and reference data
- Data engineering experience, such as ELT patterns and pipeline orchestration
- Experience with Azure data services and reporting tools such as Power BI or SSRS
- Experience integrating data with CRM platforms, such as Salesforce, and with APIs
- Knowledge of ITIL or a similar service management framework
- Familiarity with membership, qualifications, events and/or financial processes
- Experience with data quality management
About the company
We help organisations thrive by focusing on their people, supporting our economies and societies. Weβre the professional body for HR, L&D, OD and all people professionals - experts in people, work and change. With over 160,000 members globally - and a growing community using our research, insights and learning - we give trusted advice and offer independent thought leadership. And we are a leading voice in the call for good work that creates value for everyone. We offer an inclusive and collaborative working environment, a wide range of development opportunities and a competitive benefits package, including 28 daysβ annual leave (with the option to buy and sell), a personal development allowance, access to an award-winning pension scheme and a strong focus on wellbeing, including a private health insurance. We also support colleagues at different life stages, with enhanced parental leave, fertility and family-forming support, and support for those who are full-time carers for their loved ones. We value everyone as an individual and are committed to creating a diverse and inclusive workplace where different perspectives are welcomed, ensuring fair opportunities for all and strengthening how we work and deliver impact together.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦