Data Architect - Greater London, United Kingdom - The JM Longbridge Group

    The JM Longbridge Group
    The JM Longbridge Group Greater London, United Kingdom

    1 week ago

    Default job background
    Description

    Job Description

    Global Analytics Firm is hiring for a Data Architect for their team based in London. This is a permanent role offering a salary of £80K - £110K + Bonus + Full Benefits. You will be responsible for the design, implementation, and documentation of data architecture and enterprise data modelling solutions, which include the use of relational, dimensional, and NoSQL databases. Hybrid pattern of working currently in place with 1 day in the office in London per week.

    Duties include:

    Understand and translate business needs into data models supporting long-term solutions.

    Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.

    Create and maintain conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy, along with corresponding metadata.

    Optimize and update logical and physical data models to support new and existing projects.

    Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.

    Perform reverse engineering of physical data models from databases and SQL scripts.

    Evaluate data models and physical databases for variances and discrepancies.

    Analyse data-related system integration challenges and propose appropriate solutions.

    Develop data models according to company standards.

    Skills Required:

    Experience in developing SQL queries for extracting data from test and production databases to perform data analysis and data quality checks

    Experience with tools such as TOAD for data analysis, SQL assistant, Tortoise SVN

    Experience of developing robust and efficient SQL procedures, views and functions

    Experience with developing and optimising database structures, stored procedures, dynamic management views, DDL triggers, etc.

    Implementation experience with one or more data modelling tools such as Erwin, ERStudio, PowerDesigner etc.

    Bachelor's degree or equivalent experience, Master's Degree Preferred

    Understanding of cloud (Azure, AWS, GCP, Snowflake preferred) and on premises architectures

    Strong data warehousing and OLTP systems from an integration perspective

    Experience with major database and big data platforms (e.g. RDS, Aurora, Redshift, Databricks, MySQL, Oracle, PostgresSQL, Hadoop, Snowflake, etc.)

    Please apply for immediate interview