Associate Data Engineer

Associate Data Engineer 6+ Months Commercial Experience 2 Year Fixed Term Contract Edinburgh (Hybrid) Up to £36,000 DoE Storm ID is an award-winning Edinburgh-based digital transformation consultancy that helps organisations accelerate their use of digital, data and AI. We believe in tailored solutions, assembling expert teams to address each client's unique needs. Our services span strategy, design, technology and data & AI, ensuring seamless end-to-end delivery of platforms, products and services with real-world impact. What sets us apart is our commitment to long-lasting, data-driven, user-centred change. We enjoy close collaboration between our teams, ensuring projects move smoothly from discovery to design to delivery. We recognise the crucial link between digital and data, creating intelligent services that leverage both. We work with a range of clients across the Scottish and UK public and private sectors About the Role We’re looking for an entry-level Data Engineer to join our Technical team on a 2-year fixed term contract to help design and deliver data services and products for a wide range of clients and datasets. You’ll be supported by senior and lead data engineers who will mentor you as you build your skills across data integration, modelling and cloud technologies. This is a genuine opportunity to contribute to meaningful data work from day one — investigating real datasets, building real pipelines, and growing quickly in a team that takes learning seriously. Essential Skills • SQL — Can write queries to filter, join and aggregate data; understands how tables relate • Python or similar scripting — Has written scripts to process or transform data, even in a small capacity • Data awareness — Basic understanding of data pipelines, ETL/ELT concepts, or data modelling • Cloud exposure — Some hands-on experience with a cloud platform (Azure preferred) • Version control — Can branch, commit and raise a pull request; comfortable using Git day-to-day • Analytical thinking — Able to investigate a dataset, spot quality issues and ask the right questions • Problem solving — Willing to dig into unfamiliar problems; reads documentation and asks for help when stuck Desirable • Azure Data Factory, Databricks, Synapse or similar Azure data tooling • Experience with data formats and structures (JSON, Parquet, CSV, APIs) • Awareness of data modelling concepts (star schema, normalisation) • Automated testing — any exposure to unit or integration testing • CI/CD pipelines — has deployed code through an automated pipeline • Power BI or other data visualisation tools • Exposure to metadata management or data cataloguing concepts Will Learn on the Role These are not expected at hire but will be part of on-the-job development: • Designing and implementing scalable data integration services • Azure data platform tooling in depth (Data Factory, Databricks, Synapse, Purview) • Data modelling patterns and metadata repository design • Reverse engineering data models from live systems and data audits • Streaming and real-time data pipeline patterns • Continuous build and deployment pipelines for data workloads • Writing automated tests within CI/CD pipelines • 2nd and 3rd line support of data applications alongside WebOps colleagues • Using AI to augment data engineering work for improved efficiency and quality Soft Skills • Curious — Genuinely interested in data and keen to understand how datasets work and what they reveal • Willing to Learn — Engages proactively with new tools, technologies and domains • Collaborative — Comfortable working across disciplines and sharing knowledge with the wider team • Communicative — Asks questions when unsure; contributes clearly in team discussions and reviews • Ownership — Takes responsibility for tasks and follows through to completion Our Values • Go above and beyond — We have each other’s back, no matter what. • Battle complacency — We choose change and continuous improvement. • Expand your zone of genius — We believe knowledge is power and never stop learning. • Keep hold of the buck — We take responsibility for our work, choices and actions. • Be genuine — An open-minded place where everyone is free to be themselves.