models and schemas for the data warehouse. Build and maintain ETL (Extract, Transform, Load) processes to integrate data from various sources. Develop complex SQL queries and scripts to ensure efficient data retrieval and manipulation. Responsible for the build and deployment of a data warehouse capability Integrate data from … implementing Data Warehouse solutions for managing data and information Proven experience in data warehousing, data modelling, and database design. Proficiency in SQL (SSMS) and experience with ETL tools (e.g., SSIS, SAS DI, Informatica, Talend). Experience with data warehouse platforms (e.g., MicrosoftSQLServer, Amazon Redshift, Google BigQuery, Snowflake). Familiarity with BI tools (e.g., Power BI, Tableau, etc.) Strong understanding of database management systems (DBMS). Knowledge of data warehousing concepts such as star schema, snowflake schema, and data marts. Experience with scripting languages (e.g., SQL, Python more »
Job summary This is a strategic, specialist role requiring expertise in Database Design and Management relating to the Trust's Data Warehouse environment. The role will provide technical authority, leadership, training support and management of the development of new and current information databases and information processing … from multiple data sources and transpose into meaningful statistical information for the customers Extensive experience of MicrosoftSQL and associated tooling eg: SSMS, SSIS, SSRS Ability to communicate highly complex information clearly and simply to information users in an NHS setting and understand and translate their information requirements. more »
reporting cubes. Main duties of the job You will be required to interpret complex requests then design implement new technical solutions, utilising the SQL stack and other technologies where appropriate. A logical thinker who can work using your own initiative, you will also be a confident communicator and … with experience in a software or information development role. The role requires experience of ETL and BI development using full SQL stack (SSMS, SSRS, SSIS, SSAS), NHS background, and preferably some experience of PowerBI and Microsoft Excel.We operate hybrid working and are based at the Civic Centre in …/Business Intelligence/Data Analyst/Software Developer role. Experience of working within an NHS environment. Awareness of data collection and data management procedures and patient administration procedures. Competent user in Microsoft Office products Experience of querying MicrosoftSQL Databases. Awareness of NHS strategic objectives more »