SQL Data Analyst

3 weeks ago

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 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 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 business-wide 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

  • Data Integration Analyst SQL SSIS Azure ADF

    4 weeks ago

    Warrington, United Kingdom Informed Recruitment Limited Full time

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

  • Data Integration Analyst, SQL, SSIS, Azure, ADF

    4 weeks ago

    Warrington, Cheshire, 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...

  • Data Analyst

    4 weeks ago

    Warrington, Cheshire, 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? Let Informed Recruitment help you to achieve your potential with an exciting opportunity for a Data / Integration Analyst to support a data function in the midst of digital...

  • Graduate Data Entry Analyst

    1 month ago

    Warrington, Cheshire, United Kingdom Agility Resoucing Full time

    Our Energy client based in Warrington promote and support progressive careers within their company and offer a fantastic benefits package as well as a unique, fun working environment. We have already placed a number of graduates into this role and the success of the business and candidates has meant they are looking to expand the team further and invest in...

  • SQL Developer

    1 month ago

    Warrington, United Kingdom Shortlist Recruitment Limited Full time

    **SQL Developer** **Competitive** **Warrington** ShortList Recruitment are working with a market-leading organisation based in Warrington who are looking for a new SQL Developer to join their growing team. Key Responsibilities: - Develop new and existing database solutions with performance and maintainability in mind at all times - Collaborate with our...

  • Junior Application Support Analyst

    4 days ago

    Warrington, United Kingdom ShortList Recruitment Limited Full time

    Junior Application Support AnalystWarrington (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 deliver a high level...

  • Junior Application Support Analyst

    2 days ago

    Warrington, United Kingdom ShortList Recruitment Limited Full time

    Junior Application Support AnalystApply now, read the job details by scrolling down Double check you have the necessary skills before sending an application.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...

  • Junior Application Support Analyst

    2 days ago

    Warrington, United Kingdom ShortList Recruitment Limited Full time

    Junior Application Support AnalystWarrington (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 deliver a high level...

  • Junior Application Support Analyst

    4 days ago

    Warrington, United Kingdom ShortList Recruitment Limited Full time

    Junior Application Support AnalystWarrington (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 deliver a high level...

  • Junior Application Support Analyst

    4 days ago

    Warrington, United Kingdom ShortList Recruitment Limited Full time

    Junior Application Support Analyst Warrington (2 days remote) Very competitive basic + on call bonus ShortList 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 deliver a high...

  • Junior Application Support Analyst

    3 days ago

    Warrington, United Kingdom ShortList Recruitment Limited Full time

    Junior Application Support AnalystApply now, read the job details by scrolling down Double check you have the necessary skills before sending an application.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...

  • Junior IT Application Support Analyst

    4 days ago

    Warrington, Cheshire, United Kingdom ShortList Recruitment Limited Full time

    Job Description Junior Application Support Analyst Warrington (2 days remote) Very competitive basic + on call bonus ShortList 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...

  • Junior IT Application Support Analyst

    2 days ago

    Warrington, Cheshire, United Kingdom ShortList Recruitment Limited Full time €250

    Junior Application Support Analyst Warrington (2 days remote) Very competitive basic + on call bonus ShortList 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 deliver a...

  • Business Systems Analyst

    4 weeks ago

    Warrington, United Kingdom Informed Recruitment Limited Full time

    Are you anexperienced Business Systems Analyst, Applications Analyst orSystems Administrator? Do you have specific experience of workingwith social housing management software? Let Informed Recruitmenthelp you to achieve your potential with an exciting opportunity fora Business Systems Analyst to take a key role in the implementationof new application...

  • Marketing Data Scientist

    1 month ago

    Warrington, Cheshire, United Kingdom Agility Resoucing Full time

    My Client is looking for a data science modelling analyst to work in a fast-paced dynamic company. You will assist the Lead Data Scientist and report to the Head of Insight & Analytics. You'll deliver Advanced Analytics/Machine Learning/Statistical/Predictive Models to support the wider business. This is an exciting opportunity for an individual who wants...

  • BI Analyst

    3 days ago

    Warrington, Cheshire, United Kingdom ShortList Recruitment Limited Full time

    Technical Business Analyst Warrington ShortList 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 delivery Take...

  • BI Analyst

    4 days ago

    Warrington, Cheshire, United Kingdom ShortList Recruitment Limited Full time

    Technical Business Analyst Warrington ShortList 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 delivery Take...

  • BI Analyst

    4 days ago

    Warrington, Cheshire, United Kingdom ShortList Recruitment Limited Full time

    Job Description Technical Business Analyst ShortList 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 delivery ...

  • Technical Business Analyst

    2 days ago

    Warrington, United Kingdom ShortList Recruitment Limited Full time

    Technical Business AnalystReady to make your application Please do read through the description at least once before clicking on Apply.WarringtonCompetitiveShortList 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...

  • Technical Business Analyst

    4 days ago

    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...