The SQL Data Analyst  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 expertise in 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 development of the IT Solutions technology stack.

• 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 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.
• 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.
• Awareness of, and support embedding and applying revised Data Governance and Information Security standards and best practices.
• Responsible for ensuring appropriate documentation is produced and maintained for the Data & Analytics platform.
• Work closely with the IT Project managers, where appropriate, to design, develop and oversee implementation of SQL related change, applying lighter IT Project principals when self-delivering.

Job Requirements

• 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