Sql jobs in United Kingdom

Data Analyst page is loaded## Data Analystremote type: On-sitelocations: London, GBRtime type: Full timeposted on: Posted Todayjob requisition id: REQ479684**JLL empowers you to shape a brighter way**.Our people at JLL and JLL Technologies are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.**Data Analyst** – Residential ValuationsWe need a skilled data analyst to join our specialist data team that sits within JLL’s UK residential valuation business, and is based in our head office at 30 Warwick Street, London W1B 5NH.You will become part of a dynamic team of data analysts supporting a large group of residential and affordable housing experts, while contributing to a diverse range of complex and engaging instructions across the UK.This role is ideal for an individual with 2-3 years’ experience as a Data Analyst in a corporate environment, possessing strong technical, analytical and communication skills, paired with an interest in the residential sector. Adaptability and enthusiasm for achieving optimal client outcomes are essential.**Key Responsibilities****Data Analysis & Modelling*** Maintain and query large residential property datasets using advanced SQL techniques.* Design and develop complex relational SQL data models to support valuation processes.* Perform comprehensive data analysis to identify trends and insights in residential markets.**Data visualisation & Reporting*** Build and deploy interactive Power BI dashboards providing real-time insights to stakeholders.* Design compelling data visualisations that translate complex datasets into actionable intelligence* Develop executive-level reporting solutions for internal teams and client presentations.**Development & Automation*** Develop sophisticated automation scripts using Python and VBA to streamline valuation workflows.* Write API code to query AI systems at scale, enhancing our analytical capabilities.* Create and maintain robust data pipelines for continuous data processing.**Client & Stakeholder Engagement*** Present analytical findings and recommendations to clients and senior leadership* Collaborate with cross-functional teams to understand business requirements and deliver tailored solutions.* Support business development activities through data-driven insights and market analysis.**Requirements****Experience*** 2-3 years of experience as a Data Analyst in a corporate environment* Property industry experience highly preferred* Proven track record of working with large, complex datasets.**Technical Skills*** SQL: Advanced querying capabilities, complex joins, stored procedures, performance optimisation* Python: Strong programming skills including pandas, data manipulation libraries* VBA: Proficient in Excel automation and macro development* Power BI: Expert-level skills including: + Advanced DAX formula writing and optimisation. + Complex data modelling and relationships + Custom visualisations and dashboard design + Row-level security implementation. + Power Query for data transformation + Calculated columns and measures + Performance tuning and optimisation**Database & Development*** Experience designing and implementing relational data models.* API development and integration experience* Understanding of data governance principles**Analytical & Communication*** Strong analytical thinking and problem-solving abilities* Excellent presentation and communication skills* Ability to translate technical concepts for non-technical stakeholders.* Detail-oriented with strong quality assurance practices.**Location:**On-site –London, GBRIf this job description resonates with you, we encourage you to apply even if you don’t meet all of the requirements. We’re interested in getting to know you and what you bring to the table!At JLL, we harness the power of artificial intelligence (AI) to efficiently accelerate meaningful connections between candidates and opportunities. Using AI capabilities, we analyze your application for relevant skills, experiences, and qualifications to generate valuable insights about how your unique profile aligns with the specific requirements of the role you're pursuing.***JLL Privacy Notice***Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.For more information about how JLL processes your personal data, please view our .For additional details please see our career site pages for each country.For candidates in the United States, please see a full copy of our Equal Employment Opportunity policy .Jones Lang LaSalle (“JLL”) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process – including the online application and/or overall selection process – you may email us at HRSCLeaves@jll.com. This email is only to request an accommodation. Please direct any other general recruiting inquiries to our page > I want to work for JLL.At JLL, we give you the opportunity, knowledge and tools to own your success, because we value what makes each of us unique. We help our people thrive, grow meaningful careers and find a place where they belong. Together, we strive to be exceptional and shape a better world.For over 200 years, JLL (NYSE: JLL), a leading global commercial real estate and investment management company, has helped clients buy, build, occupy, manage and invest in a variety of commercial, industrial, hotel, residential and retail properties. A Fortune 500 company with operations in over 80 countries around the world, our employees bring the power of a global platform combined with local expertise. Driven by our purpose to shape the future of real estate for a better world, we help our clients, people and communities SEE A BRIGHTER WAYSM. JLL is the brand name, and a registered trademark, of Jones Lang LaSalle Incorporated. For further information, visit .