Bristol, Avon, South West, United Kingdom Hybrid / WFH Options
Anson Mccade
testing, reconciliation, and reporting visualisation (e.g. Power BI, Tableau) About You: Proven experience designing data architectures for large-scale platforms and diverse stakeholder groups Strong data modelling skills across OLTP and OLAP systems, with experience building datamarts and warehouses Proficiency with cloud-native tools (e.g. Snowflake, Databricks, Azure Data Services, etc.) High-level SQL skills and experience with tools like More ❯
the right things get delivered in the right way. What you'll bring to the team: We're looking for somebody with solid experience of building and running bespoke OLTP systems with a focus on high concurrency and reliability. You'll be familiar with a range of SQL and NoSQL databases such as Postgres, CockroachDB, MongoDB or DocumentDB, and know More ❯
solutions and end-to-end development life-cycle support and SDLC processes Excellent problem solving and data modelling skills (logical, physical, semantic and integration models) including normalisation, OLAP/OLTP principles and entity relationship analysis Experience of leading a team including architects and subject matter experts Excellent communication and presentational skills The ability to work in a team Why Pipedrive More ❯
Experience with Python with libraries such as Pandas In-depth knowledge of various database system technologies (relational, document, columnar, etc.) Understanding and experience with relational databases and implementation of OLTP and OLAP systems Professional experience in data modeling and database optimisation Nice to have: Experience in implementing version control for data artifacts Expertise in data migration strategies Familiarity with machine More ❯
London, South East, England, United Kingdom Hybrid / WFH Options
Salt Search
business functions. Essential Skills & Experience: Proven ability to reverse engineer data models from legacy systems. Strong experience in data modelling (dimensional, relational, data vault, etc.). Deep understanding of OLTP systems and transactional data environments. Experience with system/data integration, data lineage, and flow mapping. Comfortable translating complex technical detail into plain English. Strong stakeholder engagement skills, particularly with More ❯
differing levels Analysing and profiling large and complex datasets Managing a team backlog using tools like Jira or Azure DevOps Agile ways of working Familiar with OnlineTransactionProcessing (OLTP) and Online Analytical Processing (OLAP) systems Creating conceptual, logical and physical data models Creating mapping specifications for data migrations Coordinating User Acceptance Testing (UAT) with business stakeholders Knowledge of python More ❯
indexes, constraints, and PL/SQL based ETL routines in support of the implementation. Implement changes to objects and code to keep pace with the yearly changes in the OLTP system and ensure the ETL runs as efficiently as possible. Develop, implement, and maintain development and production environments. Develop Lambda functions, python code and ETL SQL procedures to retrieve data … Redshift Strong notion of security best practices (IAM, KMS, etc) Strong knowledge in PL/SQL code to perform ETL for both full loads and incremental loads from an OLTP system to a Dimensional Data Warehouse Understanding of core AWS services, uses, and AWS architecture best practices QA (testing and documentation) experience for PL/SQL development and peer reviews More ❯
Technologies: TSQL MS SQL OLTP OLAP Data Warehouse Database BI Business Intelligence Reverse Engineer Database Security Endeavour Recruitment has a fantastic opportunity for an experienced Database Developer. In-depth T-SQL knowledge is essential. This role is in a prime location close to Air/Rail/Road Networks. Candidates should have a minimum of 4 years' experience. Salary guide … to progress your career? If so, we would like to hear from you to discuss your experience. The ideal candidate will have wide experience of different database types, specifically OLTP and OLAP. Writing and Refactoring SQL and T-SQL OLTP, OLAP and Data Warehouse SQL/DB Best Practice Knowledge of Logical and Physical Design for Performance SQL Server Database More ❯