Job description
Role : Data Analyst
rate : 300-350/day - Inside IR35
Contract Length - 6months
Location(s) : London - England - United Kingdom of Great Britain and Northern Ireland
The Real Estate market is undergoing a significant and exciting change – driven by data and technology. The skillful use of data and insights play a vital role in XYZ’s mission to create unmatched value for our clients. Our Enterprise Data Platform brings Master Data Management and Data Governance concepts, built on a modern tech platform, to transform XYZ into a fully data-enabled organization. Along the way, we are liberating data from silos across the region and building core platform functionality to provide disruptive innovation.
Key Responsibilities:
- Interpret and analyze data from various source systems to support data integration and data reporting needs within XYZ.
- Identify, analyze, and interpret trends or patterns in complex data sets
- Work with team leads to prioritize business and information needs
- Prepare high-level ETL mapping specifications.
- Develop complex code data scripts (Primarily SQL and Golang, some Python) for ETL
- Troubleshoot & determine best resolution for data issues and anomalies
- Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts
- Assist in development of software technical documentation
- Design, specify, implement, and maintain systems using Agile scrum methodology.
Person specification and skills required:
- Hands-on experience in Data Platform / Warehouse / Lake engineering: source integration, pipeline development and analytics.
- Significant recent experience of Postgres (RDS) and Golang or Python.
- Excellent SQL skills, ideally PostgreSQL, PL/pgSQL.
- Knowledge of Indexing strategies and query tuning for performance (e.g. Explain Plans).
- Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy
- Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences
- Deep understanding of data architecture & data modelling best practices and guidelines for different data and analytic platforms.
Desirable
- Experience with Master Data Management.
- Experience of Data Governance processes. E.g. Data Profiling, Data Quality, Reference Data Management.
- Experience with Elastic Search
- Experience of Spatial/GIS Database platforms and techniques.
- Understanding of the Commercial Real Estate industry.