SQL Data Analyst

1 week ago


Warrington, Warrington, 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 - Warrington Or Leeds


Recently recognised as one of the best Big Company in the UK to work for by Best Companies this is a fantastic time to join J.

Murphy & Sons Take a look at the role outline and if you think you fit the bill, and want to work as a SQL Data Analyst withina team that rewards performance, drives personal development and offers a great place to work delivering exciting projects, then get in touch.


The SQL Data Analyst (Finance) role will be responsible for creating, developing, and maintaining Azure SQL databases and associated code, as they relate to finance systems and processes.

The role will work closely with the business to combine expertisein finance 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.
  • Large and complex datasets from Dynamics365 Finance and Operations and other key, finance related systems and data capture processes.
  • Creating SQL scripts, queries, and stored procedures to extract data
  • Create reusable, 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 the Finance & Finance Systems team 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 ETLlanguages 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.
  • Plan any work undertaken to meeting the agreed timelines, highlighting early any issues that may delay delivery.
  • Implement information security best practices businesswide in order to protect the confidentiality, integrity and availability of company data, systems and infrastructure.
  • Responsible for ensuring appropriate documentation is produced and maintained for the Data & Analytics platform, ensuring agreed Murphy best practices and standards are followed.

Who we are looking for

  • Previous experience of duties defined in "Key Responsibilities & Duties section"
  • Detailed knowledge of system and data structures in Dynamics365 Finance and Operations.
  • 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
  • Demonstrable experience with Visual Studio and Azure DevOps toolsets


  • Warrington, Warrington, United Kingdom Circle Recruitment Full time

    Data and Insights Analyst - RemoteA Data Analyst with excellent analytics experience in Power BI, SQL and ideally Online Analytics tools is required by a leading digital marketing agency.This role offers remote working, your birthdays off and an excellent benefit package including discounted gym memberships and your equipment paid for. You'd be joining a...


  • Warrington, Warrington, United Kingdom Informed Recruitment Full time

    Are you an experienced Data / Integration Analyst that can add value to an expanding function? Do you SQL Server and SSIS experience as well as exposure to Azure and Azure Data Factory? developments skills? Let Informed Recruitment help you to achieve your potential with an exciting opportunity for a Data / Integration Analyst to support a data function in...


  • Warrington, Warrington, United Kingdom Agility Resoucing Full time

    Looking for Data Analyst Graduate Job in Warrington? Want to work for a leading pharmaceutical firm who have been experiencing growth in headcount and revenue? Apply for this Graduate Data Analyst job in Warrington today. There is 3 open vacancies for bright graduates. You will work within a team full of data specialists and will analyse the behaviour of...


  • Warrington, Warrington, United Kingdom Page Personnel Secretarial & Business Support Full time

    Joining part of a retail giant, you will be a key hire for an amazing team who are looking for a Data Analyst who will be an instrumental part of their growth strategy in 2023 by using data to help the business make the right decisions to facilitate this.Optimising data will be your passion and adding value to an organisation and developing a successful...

  • Reporting Analyst

    1 week ago


    Warrington, Warrington, United Kingdom TW Full time £35,000

    My client is seeking a highly motivated Reporting Analyst with a strong background in SQL and Power BI to join their team in Warrington. In this role, you will be responsible for generating reports and dashboards that provide valuable insights into our business operations. Key Responsibilities Develop and maintain reports and dashboards using SQL and...

  • BI Analyst

    1 week ago


    Warrington, Warrington, United Kingdom ShortList Recruitment Limited Full time

    Technical Business AnalystShortList Recruitment are looking for an experienced Technical Business Analyst with experience working within a Software Development team, to join a software house based in Warrington.Key responsibilities for the Technical Business Analyst role:Understand core business drivers and ensure timely deliveryTake ownership of project...


  • Warrington, Warrington, United Kingdom ShortList Recruitment Limited Full time

    Job DescriptionJunior Application Support Analyst Warrington (2 days remote)Very competitive basic + on call bonusShortList Recruitment is looking for a Junior Application Support Analyst to join a software house based in Warrington. They require someone to provide 2nd and 3rd line support to external clients.The Junior Application Support Analyst will...

  • Business Analyst

    1 week ago


    Warrington, Warrington, United Kingdom Searchability Full time

    Business Analyst / Product OwnerSalary of £60kJoin a growing business with career progressionHybrid working - 2 days onsite in Warrington We are a fast-growing technology driven company, with market leading data products that service clients from a variety of industries. This is a fantastic opportunity to join a motivated and friendly team, who work...


  • Warrington, Warrington, United Kingdom Certas Energy Uk Ltd Full time

    We have an exciting opportunity to join us as a Junior Business Intelligence Analyst. This is a full-time permanent role based in our Birchwood HQ in Warrington.Responsible for assisting in the design, development, and maintenance of Business Intelligence solutions. The role involves crafting and executing queries upon request for data, and presenting...


  • Warrington, Warrington, United Kingdom ShortList Recruitment Limited Full time

    Technical Business AnalystWarringtonCompetitiveShortList Recruitment are looking for an experienced Technical Business Analyst with experience working within a Software Development team, to join a software house based in Warrington.This position would be well suited to someone with a strong understanding of application architecture and design. You will work...

  • Information Analyst

    1 week ago


    Warrington, Warrington, United Kingdom Warrington and Halton Teaching Hospitals NHSFT Full time

    Job summary The Corporate Information Team continues to transform and is seeking to appoint a confident, committed, skilled and motivated analyst to work as part of our Digital Analytics team, collaborating with the wider Digital teams and both internal and external partners, to deliver intelligence through the latest tools and techniques. You will have...

  • Data Engineer

    1 week ago


    Warrington, Warrington, United Kingdom Adele Carr Recruitment Full time

    A great opportunity for a Data Engineer to join an award-winning company who due to continual success now has over 250 sites nationwide.You will be rewarded with a huge variety of benefits including:Salary up to £48k Pension scheme- Employer contribution 7%25 days holiday + bank holidaysOpportunity to buy additional holidaysPrivate healthcareDeath in...


  • Warrington, Warrington, United Kingdom Agility Resoucing Full time

    If you enjoy sport and analytics, then I have the perfect role for you My Client is looking for a recent Graduate to Join the team in who loves sport and analytics. Working in a team of 5 in this will be the chance to develop your programming and analytical skills in a fun and fast paced environment. Key Responsibilities Identify trends from multiple...

  • SAP Analyst

    1 week ago


    Warrington, Warrington, United Kingdom Page Personnel Secretarial & Business Support Full time

    Page Personnel are thrilled to be working with a Global Manufacturing company to recruit for a SAP Analyst/ System Controller on a full time permanent basis. This is an exciting opportunity for someone who has a good understanding of the SCOOP Core Model.We are looking for a System Controller & Master Data Technician who has experience working in a...


  • Warrington, Warrington, United Kingdom Agility Resoucing Full time

    Job Title: Graduate Business Insight Analyst Location: Warrington Our client has a position for a Business Insight Analyst . This firm based in Warrington are looking for a high calibre individual who wants to apply their passion for mathematics and statistics in the role of a Business Analyst in a high growth industry. If you are a confident...


  • Warrington, Warrington, United Kingdom Stobart Full time

    Job DescriptionDue to continued growth, we are now seeking a HR Analyst to join our HR team at our Appleton Thorn site. Based within the Stobart HR Team, you will be a key player in the production and delivery of our people metrics and data reporting. This includes cyclical reports, ad hoc requests, and supporting on the continuous improvement projects...


  • Warrington, Warrington, United Kingdom Found Consultancy Full time

    Logistics Systems AnalystFull time permanent – Monday – Friday - 2-day WFH optionSalary: £35,000k - £38,000kLocation: North West – M6 – M62 – WarringtonLarge global organisation with UK fleetThis is an excellent opportunity to join a large European organisation in a Logistics Systems Analyst role.You will provide Logistics business analytics...


  • Warrington, Warrington, United Kingdom Stobart Full time

    Company DescriptionFollowing years of accelerated growth Culina Group is now a £2.2billion+ turnover business, employing over 22,000 staff, with a fleet of more than 5,000 vehicles. Culina Group operates from over 100+ depots across the UK and Ireland, serving more than 1,000 clients over its framework of chilled, ambient, contract packaging solutions and...


  • Warrington, Warrington, United Kingdom Robert Walters UK Full time

    Data Quality ManagerOur client is seeking a dedicated and experienced Data Quality Manager to become their in-house data expert. This role offers the opportunity to work closely with data and business processes, enabling business opportunities and enhancing customer experience. The successful candidate will define what first-class data quality and management...

  • Operations Analyst

    1 week ago


    Warrington, Warrington, United Kingdom Greencore Group Lts Full time

    Why Greencore? We're a leading manufacturer of convenience food in the UK and our purpose is to make every day.We're a vibrant, fast-paced leading food manufacturer. Employing around 13,600 colleagues across 16 manufacturing units and 17 distribution depots across the UK. We supply all the UK's food retailers with everything from Sandwiches, soups and sushi...