Data Engineer: Migrations

Data Engineer: MigrationsSalary: competitive depending upon experience benefitsWhere the job is based: (home-based working with Kerv office/customer site visits as required) UK HQ Seven House 18 High Street Longbridge B31 2UQWho we are:Dive into a world where technology meets innovation. At Kerv Digital were not just another tech company. Were the problem solvers the magicians who transform complex challenges into seamless digital experiences. Utilising a powerful blend of Power Platform DevSecOps Data experiences and Software Engineering we create business solutions that truly resonate with our clients driving extreme valueWith our roots planted in Birmingham and branches spreading across the globe from London to Bangalore were a proud member of the Kerv Group - a dynamic 112m revenue technology consultancy leader with a dedicated team of over 700 professionals partnering with 800 sector leaders.People come first always we are incredibly proud of our unparalleled work culture. Not just words on paper we wear our Great Place to Work certifications from the UK and India like badges of honour. Dive into an ocean of opportunities in an atmosphere that celebrates collaboration. Sharpen your prowess with a global multi-discipline team and be guided by the industrys most forward-thinking architects.Who we are looking for:You are excited by helping customers with data plumbing problems getting from A to B; but still an engineer at heart working to best practise in-mind. You learn fast and love to build. Cloud experience is essential hands-on skills in Azure preferred.All backgrounds will always be considered and experience here is far more important were after someone with a numerate background and proven experience working in a data engineering role in an Azure ecosystem.Required Experience: Creating mapping specifications between legacy and CRM ERP Finance applications Integration to D365 Dataverse solutions or other SaaS applications Data Quality Frameworks: Great Expectations DBT Creation of fault-tolerant data ingestion pipelines in SSIS/ KWS / Data Factory / data flows using Linked Services Integration Datasets Extracting data from a variety of sources including SQL databases document databases graph databases web APIs etc. Building dashboards to reconcile migrated dataDesirable experience: Azure data certifications Azure Synapse: Synapse-link on-demand SQL engine dedicated SQL pool Writing unit tests git Version control Awareness of reliability patterns in ETL pipelines Use of python in Jupyter notebooks for data processing Azure storage technologies and cost/performance characteristics Power BI DAX data flows Techniques and tools for sanitizing data prior to use Awareness of Kimball modelling techniquesWere also looking for people that fit how we work which is something like; happiest working under their own direction but fully supported when needed an obvious attention to detail we want you to obsess about the little things an escalation handler able to achieve win-win outcomes by utilising the skills across the team ability to work effectively with remote teams in India ability to work flexibly to deliver on-time to tight timescalesWhat we can do for you:Were a transparent honest and fiercely equal employer that believes completely in providing the best possible work experience for our employees: Real Flexibility were a family first organisation and if the work gets done you can work when and wherever you want. A healthy approach for most of our teams seems to be splitting three ways between home customer sites and the office. Awesome Environment all of our employees will tell you that we foster an easy going environment are experts at what we do and care deeply about what we work on and the company was started specifically to find a way for people to take more enjoyment from their work. Interesting Work these days most of our customers are household names and many of our projects have an important impact on the world around us. The kind of things we do regularly include working with not-for-profits to transform how they leverage technology working with public bodies to shape digital services and working with top tier private entities to bring genuinely new and meaningful products and services to market. Great Benefits all the usual suspects and then some. Some highlights include our choose-your-own tech approach to end-user devices well stocked cupboards with tasty goodies (were a food first company too) excellent professional development support including frequent in-house training for tech. you cant get trained on anywhere else and private healthcare. Full disclosure; some benefits can only be provided after probation. Recognition & Growth Recognized as a Great Place to Work in both the UK and India our commitment to excellence goes beyond our products and services. Our culture is a testament to the dedicated technologists who work tirelessly to drive our vision forward. Being a part of Kerv Digital means embracing a culture of innovation collaboration and mutual respect. Our teams in the UK and India thrive in an atmosphere that promotes continuous learning and growth.Join us at Kerv Digital where we dont just build groundbreaking technology - we build future.Dont take our word for it though check out our impartial Glass Door reviewsMore on equality:At Kerv were building something special and were building it to last. We want everybody to feel valued included and love working together. With an uncompromising pursuit of amazing employee experience we always strive to do the right thing. We believe and will relentlessly promote and support the power of diversity equality and belonging through collaboration and creating exceptional solutions together.*Please note: By submitting an application you agree to Kerv Digitals Trakstar Privacy Notice - Kerv Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Full-Time Experience: years Vacancy: 1