Data Analyst - SC Cleared - AWS

Data Analyst – SC Cleared - AWSWe’re looking for a Data Analyst (SFIA Level 4) to join a high-profile government data transformation programme. The role will support an existing team, working across data modelling, analytics, and performance optimisation within the AWS Athena environment.This is not a data engineering or build role; it’s focused on understanding, analysing, and optimising existing data models and SQL scripts to improve efficiency, structure, and insight quality.Due to the nature of the role, active SC clearance is required.Key Responsibilities

• Analyse and interpret existing SQL / NoSQL scripts, optimising performance and accuracy.
• Review, document, and enhance data models in AWS Athena and related warehousing environments.
• Provide insight and recommendations on data modelling standards, table structures, and query logic.
• Support the wider MIDAS analytical and engineering team on data validation and reporting improvements.
• Contribute to the delivery of a robust data warehousing and analytics environment in AWS.
• Produce technical documentation and maintain clear audit trails of analysis work.

Essential Skills & Experience

• Proven experience as a Data Analyst or Data Modeller within large, data-driven organisations.
• Strong proficiency in SQL (writing, debugging, and optimising scripts).
• Experience with AWS Athena and related data warehousing / analytics tools (e.g. Redshift).
• Understanding of data modelling principles — normalisation, star/snowflake schemas, and metadata management.
• Knowledge of both SQL and NoSQL databases.
• Ability to review and enhance existing data pipelines without rebuilding them.
• Excellent communication and documentation skills, comfortable in a technical, fast-paced environment.