- Building, maintaining and troubleshooting issues with SQL pipelines- Build Data Dashboards with Quicksight, Python Streamlit and Python Plotly Dash- Creating SQL views and datacuts, joins, subqueries, cleaning and creating aggregations- Help users fix streamlit dashboards, pandas analysis problems.- Communicate technical information with developers around bugs and possible system improvements.

- Query SQL database, use SQL and Python to create summary statistics and charts.- Quality assure colleagues SQL and Python code including checking graphs and source information.- Produce written summaries of data analysis for senior stake holders and to be published for the public.

Albany Beck are a Management Consultancy headquartered in London, who operate primarily within the Financial Services. Our in-house Tech Academy has been set up to provide specialist technologists to our clients. We connect sought after graduates and Master's students with up to three years' experience with our clients, primarily within the financial services.

- Manage and maintain parliament wide web-based building management platform (Planon), responding to service failure, regression testing, gaining change approval for upgrades and server moves.- Design and build new areas of functionality as part of a project delivery team including liaising with project managers, business analysts and change and engagement professionals.- Shepperd any new configuration through the DTAP, including rigorous testing and user acceptance, ensuring safe implementation of new code.- Build Power BI reports- Writing custom HTML, CSS and JavaScript for fixes and improvements.- Delivering demonstrations, training and troubleshooting issues with any new functionality.- Maintain data quality, manage data integrations of both upstream and downstream systems, e.g. Azure, Active Directory, BIM.

- Write department newsletter.- Enforce Parliament wide compliance programmes such as the Register of Interests and Annual Essentials Training.

- Book, publicise and resource Valuing Everyone training.- Keep track of spending, completion rates and produce regular tracking reports for senior stakeholders.