SQL Data Analyst

3 weeks ago

London, United Kingdom J. Murphy & Sons Ltd Full time

Company description:
J. Murphy & Sons Limited is a leading global, specialist engineering and construction company founded in 1951 that improves lives by delivering world-class infrastructure.
Operating in the United Kingdom, Ireland and Canada, we provide better engineered solutions to infrastructure sectors including Transportation, Water, Power, Natural Resources, and Construction & Property.
Headquartered in London, we also have a number of related businesses - Ground Engineering; Utility Connections; Murphy Plant; Urban Infrastructure; Murphy Process Engineering; Pipeline Testing Services; Specialist Welding Services; and Electrical Services.We are specialists in delivering pipelines; design; marine; structural steel; tunnelling; fabrication; bridges and piling; and invest heavily in our substantial holding of plant; equipment and facilities.
Murphy employs around 3,500 engineers, professional managers and skilled operatives around the world. Together, we work as ‘One Murphy’ by directly delivering the people, plant and expertise needed to make projects a success.
There’s more to Murphy.

Job description:
**SQL Data Analyst - North**

The SQL Data Analyst role will be responsible for creating, developing, and maintaining Azure SQL databases and associated code, as they relate to construction. The role will work closely with the business to combine expertise in construction process andsystems to create data models and business views that present data in a secure, user-friendly, re-usable manner for Reporting Analysts to consume. They will also provide strategic advice on the business’s Data & Analytics roadmap and guidance on developmentof the IT Solutions technology stack.

**What you will be doing**
- Working closely with senior business stakeholders to understanding reporting and analytical requirements to acquire and present relevant datasets.
- Handle large and complex datasets from construction related systems and data capture processes (eg field data capture tools, planning and scheduling, estimating, labour and resourcing, design management)
- Support in handling large and complex datasets from Dynamics365 Finance and Operations
- Creating SQL scripts, queries, and stored procedures to extract data
- Create re-usable, data models in SQL through the standardisation of tables, structures, and schemas.
- Verify the integrity of extracted data, including schema, format, checksum/hashing.
- Work closely with business stakeholders to ensure the data extracted is formally reconciled and approved before being made available for use.
- Monitor and maintain the performance and stability of associated databases.
- Provide SQL incident management triage capability for existing database estate
- Work closely with the wider business and data team to support the ongoing acquisition and presentation of data, using common ETL languages e.g. data transformation via T/SQL, Python etc.
- Ensure the security of associated data is maintained (inc field, row and table), as determined by the Data Governance and Technical Design Authorities.
- Responsible for ensuring appropriate documentation is produced and maintained for the Data & Analytics platform, ensuring agreed Murphy best practices and standards are followed.
- When required, attend, and contribute towards the Technical Design Authority (TDA), ensuring best practices and standards are adhered to at all times.
- Drive knowledge and skills transfer across the IT team around Data & Analytics.
- Provide support to the IT Core Team were deemed critical by the IT Director or Head of IT Business Solutions.
- Ability to lead technical discussion and technical issue resolution.

**Who we are looking for**
- Detailed knowledge and practical experience managing Microsoft SQL instances.
- Demonstrable T/SQL analysis experience, including the development of store procedure functions and the ability to create and modify complex code.
- Demonstrable experience with SQL Server Integration Services (SSIS).
- Working knowledge of ETL and data ingestion concepts.
- Good working knowledge of Cyber/Information Security
- Knowledge and practical experience working with Azure Integration services (eg LogicApps)
- Knowledge and practical experience with Microsoft Azure Data Factories, Data Lake and Databricks
- Experience working with Microsoft Azure Synapse and Purview
- Knowledge of system and data structures in Dynamics365 Finance and Operations.
- Report development experience with Microsoft Power PowerBI
- Data engineering experience with Python and C#, Web service / API development and Messaging Frameworks
- Demonstrable experience with Visual Studio and Azure DevOps toolsets.
- Experience of working with Agile project delivery
- ITIL Foundation.

  • Data analyst

    2 weeks ago

    London, United Kingdom Data Idols Full time

    Data Analyst Location: London (Hybrid) Data Idols is collaborating with a large, worldwide publishing company that is continuously expanding its range of products and services. This company publishes significant research that has the potential to enhance society. With the aim of improving people's lives through books and journals at the heart of their...

  • Data analyst

    2 weeks ago

    London, United Kingdom Data Idols Full time

    Data Analyst Location: London (Hybrid) Data Idols is collaborating with a large, worldwide publishing company that is continuously expanding its range of products and services. This company publishes significant research that has the potential to enhance society. With the aim of improving people's lives through books and journals at the heart of their...

  • Data Engineer

    4 weeks ago

    London, United Kingdom Abs Data Full time

    Data Engineer/Analyst Risk & Margin We’re looking for a software engineer to: provide technology solutions that will solve business problems in the Risk and Margin space work with risk managers to translate business needs using Behavior Driven Development (BDD) into functional requirements. Key to success will be the ability to understand the data...

  • SQL Data Analyst

    6 days ago

    London, United Kingdom Salt Search Full time

    **SQL Data Analyst | 12 month contract | Inside IR35 | £500 per day** **General Role Description** My client require an experienced SQL Developer who can work with limited supervision to support Senior Data Engineer on various data projects of small to medium size and scope. This will be a largely technical role with primary responsibility to develop SQL...

  • SQL Data Analyst

    6 days ago

    London, United Kingdom J&C Associates Full time

    We are Global IT Recruitment specialist that provides support to the clients across UK, Europe and Australia. We have an excellent job opportunity for you. **Job Title: SQL Data Analyst - Sales Analytics** **Location: Shoreditch (Hybrid)** **Duration: 12 months contract** **General Role Description**: - Require an experienced SQL Developer who can work...

  • Data Analyst

    6 days ago

    London, United Kingdom Harnham - Data & Analytics Recruitment Full time

    DATA ANALYST £40,000 - £50,000 LONDON An FMCG giant is looking to bring in a Data Analyst to join their growing analytics function! THE COMPANY This company is a multinational FMCG giant, with many well-known brands loved by millions of customers. The company is incredibly innovative and has a real focus on sustainability. THE ROLE As a Data Analyst...

  • Data Analyst with VBA and SQL

    4 weeks ago

    London, United Kingdom Nexus Jobs Limited Full time

    Job Description Data Analyst with VBA programming and PL/SQL Our Client a financial institution with offices in Canary Wharf London - are looking to recruit a Data Analyst with VBA and PL/SQL development experience. You must have at least 5+ years of experience as a Business Analyst in the Financial sector. Excellent ability to profile data and come to...

  • Data Analyst with VBA and SQL

    4 weeks ago

    London, United Kingdom Jas Gujral Full time

    Data Analyst with VBA programming and PL/SQL Our Client a financial institution with offices in Canary Wharf London – are looking to recruit a Data Analyst with VBA and PL/SQL development experience. You must have at least 5+ years of experience as a Business Analyst in the Financial sector. Excellent ability to profile data and come to substantive...

  • Data Analyst

    5 days ago

    London, United Kingdom CINQ PARTNERSHIP LTD Full time

    **Data Analyst - SQL - Data Transformation** Our client, a Global Organisation are looking for a strong Data Analyst who will be responsible for understanding in depth EMMA data model, becoming a Subject Matter Expert in this data. Then, working closely to the Product Manager and Business Stakeholders,this Data Analyst is accountable for understanding the...

  • Business Data Analysts

    4 weeks ago

    London, United Kingdom Jas Gujral Full time

    Business Data Analyst with Actimize – Canary Wharf Docklands London We are currently seeking an experienced contracting Data Analyst to join our dynamic and growing Professional Analysis team based in central London.  You will primarily gather, understand and document detailed business requirements using appropriate tools and techniques and manipulate,...

  • Data Analyst Contract

    5 days ago

    London, United Kingdom Harnham - Data & Analytics Recruitment Full time

    **DATA ANALYST (CONTRACT) £100-150 PER DAY, 3 MONTHS REMOTE** An entry level Data Analyst position to support an Iconic London Brand's Advanced Analytics programme. Your role will be to work across multiple Excel Spreadsheets to homogenise & bring together customer & marketing spend data. **THE COMPANY**: This client is an Iconic part of London's culture,...

  • Data Analyst SQL Python Tableau

    4 weeks ago

    London, United Kingdom Mana Holdings Ltd. Full time

    Data Reporting and Analytics Analyst | London MIDDLE Looking for a Data Reporting and Analytics Analyst with significant experience and understanding of regulatory reporting methods and knowledge of SQL, Tableau, and Excel. Bonus: 20% Pension scheme: Flexible working: Holiday allowance: Private Private BA in Business/Finance or other...

  • IT Operations Analyst SQL Data

    3 weeks ago

    London, United Kingdom Cornwallis Elt Ltd Full time

    A global investment management firm operating in a multitude of different markets are looking for an Azure Data Operations Analyst to join their IT Production team. The company has quickly grown and really invested in their IT over the past few years, moving to the cloud and looking at how they can truly leverage their data. Although a financial...

  • Data Analyst

    4 weeks ago

    London, United Kingdom The Consultancy Group (London) Full time

    A data-driven insurance company adopting a culture of small highly skilled teams is looking for a Data and Process Analyst - Change. Full Life Cycle - End to End projects. Have a passion for using data and technology to drive decision-making. Demonstrate the ability to work with stakeholders from across business functions, understand business...

  • Data Analyst

    4 weeks ago

    London, United Kingdom Open Data Science Conferenc Full time

    Data Analyst | PowerBI | Specialty Insurance Firm Increase your chances of reaching the interview stage by reading the complete job description and applying promptly. City of London Are you an exceptional Data Analyst with a strong command of PowerBI? Are you passionate about turning data into actionable insights that drive business success? If so, we...

  • Data Analyst

    5 days ago

    London, United Kingdom Australasian Recruitment Company Full time

    Data Analyst **Salary**: £28.00 per hour This is a temporary opportunity to work as a Data Analyst for one of the world's leading tech companies. In the role as Data Analyst the successful applicant will be supporting across 21 countries in the EMEA region and is required to be an experienced userof SQL. Data Analyst Responsibilities: - Engaging with...

  • Lead Data Analyst Python SQL

    2 weeks ago

    London, United Kingdom Harnham Full time

    LEAD DATA ANALYST LONDON – HYBRID A company focused on providing technological and data-related insight into the education industry, growing the educational perspective across the country This role will be responsible for leading the BI function as a stand-alone role, taking full ownership of the BI capabilities understanding of the business’s...

  • Lead Data Analyst Python SQL

    2 weeks ago

    London, United Kingdom Harnham Full time

    LEAD DATA ANALYST LONDON – HYBRID A company focused on providing technological and data-related insight into the education industry, growing the educational perspective across the country This role will be responsible for leading the BI function as a stand-alone role, taking full ownership of the BI capabilities understanding of the business’s...

  • Data analyst

    19 hours ago

    London, United Kingdom Burns Sheehan Full time

    I am partnered with one of the UK's most exciting e-commerce organisations who are looking for a contract Data Analyst with deep experience with Product Analytics to deliver critical insights to the business and various senior stakeholders. SQL AWS Contract Data Analyst £SQL, dbt, Product Analytics Hybrid from London or remote

  • Data analyst

    2 weeks ago

    London, United Kingdom Tiro Partners Limited Full time

    Senior Data Analyst / Data Modelling / SQL / Tableau / Python / Databicks Role: Senior Data Analyst Renewable Energy Location: London (Hybrid, 1 day a week in office) A world leader in renewable and sustainability energy are currently in search of a seasoned Senior Data Analyst to join their growing Data team. As the Senior Data Analyst, you will...