(SC cleared) Data Engineer

Methods Analytics (MA) is recruiting for a Data Engineer to join our team a permanent basis.This role will be mainly remote but require flexibility to travel to Bristol.What You\’ll Be Doing as a Data Engineer:Design and architect modern data solutions that align with business objectives and technical requirementsDesign and implement advanced ETL/ELT pipelines using Python, SQL, and Apache AirflowBuild highly scalable and performant data solutions leveraging cloud platforms and technologiesDevelop complex data models to handle enterprise-level analytical needsMake critical technical decisions on tools, frameworks, and approaches for complex data challengesOptimise large-scale data processing systems for performance and cost-efficiencyImplement robust data quality frameworks and monitoring solutionsEvaluate new technologies to enhance our data engineering capabilitiesCollaborate with stakeholders to translate business requirements into technical specificationsPresent technical solutions to leadership and non-technical stakeholdersContribute to the development of the Methods Analytics Engineering Practice by participating in our internal community of practiceYour Impact:Enable business leaders to make informed decisions with confidence through timely, accurate data insightsDrive adoption of modern data architectures and platformsDeliver seamless data solutions that enhance user experienceElevate the technical capabilities of the entire data engineering teamHelp cultivate a data-driven culture within the organisationEstablish technical standards and patterns that ensure quality and maintainabilityRequirementsExperience in SQL Server Integration Services (SSIS)Good experience with ETL – SSIS, SSRS, T-SQL (On-prem/Cloud)Strong proficiency in SQL and Python for handling complex data problemsHands-on experience with Apache Spark (PySpark or Spark SQL)Experience with the Azure data stackKnowledge of workflow orchestration tools like Apache AirflowExperience with containerisation technologies like DockerProficiency in dimensional modelling techniquesExperience with CI/CD pipelines for data solutionsExperience implementing and advocating for test-driven development methodologies in data pipeline workflows, including unit testing, integration testing, and data quality validation frameworksStrong communication skills for translating complex technical conceptsTrack record of successful project delivery in a technical leadership capacityYou may also have some of the desirable skills and experience:Experience designing and implementing data mesh or data fabric architecturesKnowledge of cost optimisation strategies for cloud data platformsExperience with data quality frameworks and implementationUnderstanding of data lineage and metadata managementExperience with technical project managementExperience with data visualisation tools like Power BI or Apache SupersetExperience with other cloud data platforms like AWS, GCP or OracleExperience with modern unified data platforms like Databricks or Microsoft FabricExperience with Kubernetes for container orchestrationUnderstanding of streaming technologies (Apache Kafka, event-based architectures)Software engineering background with SOLID principles understandingExperience with high-performance, large-scale data systemsKnowledge of recent innovations in AI/ML and GenAIDefence or Public Sector experienceConsultant experienceSecurity Clearance:UKSV (United Kingdom Security Vetting) clearance is required for this role, with Security Check (SC) as the minimum standard.Our Hiring ProcessAt Methods Analytics, we believe in a transparent hiring process. Here\’s what you can expect:1. Internal Application Review2. Initial Phone Screen3. Technical Interview4. Pair Programming Exercise5. Final Interview6. OfferBenefitsWorking at MAMethods Analytics (MA) exists to improve society by helping people make better decisions with data. Combining passionate people, sector-specific insight, and technical excellence to provide our customers an end-to-end data service.We use a collaborative, creative and user centric approach to data to do good and solve difficult problems. Ensuring that our outputs are transparent, robust, and transformative. We value discussion and debate as part of our approach. We will question assumptions, ambition, and process – but do so with respect and humility.We relish difficult problems, and overcome them with innovation, creativity, and technical freedom to help us design optimum solutions. Ethics, privacy, and quality are at the heart of our work, and we will not sacrifice these for outcomes.We treat data with respect and use it only for the right purpose. Our people are positive, dedicated, and relentless. Data is a vast topic, but we strive for interactions that are engaging, informative and fun in equal measure. But maintain a steely focus on outcomes and delivering quality products for our customers.We are passionate about our people; we want out colleagues to develop the things they are good at and enjoy.By joining us you can expectAutonomy to develop and grow your skills and experienceBe part of exciting project work that is making a difference in societyStrong, inspiring, and thought-provoking leadershipA supportive and collaborative environmentAs well as this, we offer:Development access to Pluralsight and LinkedIn LearningWellness 24/7 Confidential employee assistance programmeSocial – office parties, pizza Friday and commitment to charitable causesTime off – 25 days of annual leave a year, plus bank holidays, with the option to buy 5 extra days each yearVolunteering – 2 paid days per year to volunteer in our local communities or within a charity organisationPension Salary Exchange Scheme with 4% employer contribution and 5% employee contributionDiscretionary Company Bonus based on company and individual performanceLife Assurance of 4 times base salaryPrivate Medical Insurance which is non-contributory (spouse and dependants included)Worldwide Travel Insurance which is non-contributory (spouse and dependants included) #J-18808-Ljbffr