Senior Data Engineer

Summary

Join Version 1's Managed Services team as an experienced data engineer with a proven track record in implementing DWH/Data Visualization solutions. You will be responsible for data ingestion and transformation pipelines for large-scale operations, working within a blended team and contributing to continuous service improvements. The role requires expertise in the Microsoft BI stack, Azure resources, and SQL, along with experience in ETL solutions and Power BI. You will collaborate with clients, solve complex issues, and effectively communicate technical details. This position offers opportunities for skill development and career progression within a supportive and collaborative environment.

Requirements

• Have a high degree of experience across the entire Microsoft BI Stack including SQL Server, SSIS, SSAS, SSRS & Power BI
• Support, create and enhance ETL solutions using Azure Data Factory
• Know the Azure suite of resources that can enhance BI solutions such as Azure VM’s, Azure SQL Database, Log Analytics, Logic Apps, Azure Analysis Services, Azure Data Lake, Databricks, Azure Key Vault
• Write performant SQL queries and stored procedures
• Understand and reverse engineer issues back to the source and then apply a fix
• Design, build and reverse engineer reports in Power BI using various data sources with a demonstrated understanding of DAX and Power Query
• Have working knowledge of other BI Tools including Qlik, Tableau & AWS Quicksight
• Have some knowledge of other database engines such as Oracle, MySQL
• Have experience with disaster recovery methods and capacity planning for both on-premise and cloud-based solutions
• Accurately estimate pieces of work both small and large and successfully execute on these estimations
• Perform some DBA tasks such as performance tuning, optimisation sizing, backups, upgrading, migrating etc
• Know source control solutions such as Git and DevOps
• Work under pressure, handle complex change and prioritize key activities
• Implement full lifecycle activities including, but not limited to detailed analysis, design, development, test, user acceptance test support and production implementation
• Adhere to coding standards and best practices
• Have ITIL knowledge and the ability to understand and demonstrate service management best practices
• Be SC Cleared

Responsibilities

• Implement DWH/Data Visualization solutions
• Build data ingestion and transformation pipelines for large scale operations
• Work within a blended team of junior engineers to Principal Architects
• Develop skills across the Microsoft stack
• Share knowledge and identify gaps for training and personal progression
• Support and implement projects for many clients across several industry sectors
• Gain exposure and “hands on” experience to different technologies and platforms from on-premise solutions to Cloud
• Problem solve complex issues
• Move between clients, projects, technologies
• Collaborate with team members
• Develop understanding of clients business, applications and users
• Communicate technical issues to business users
• Identify, recommend and implement continuous service improvements
• Demonstrate client facing skills

Preferred Qualifications

• Have some knowledge of Amazon AWS
• Have some knowledge of Attunity replicate

Benefits

• Quarterly Performance-Related Profit Share Scheme
• Strong Career Progression & mentorship coaching through our Strength in Balance & Leadership schemes with a dedicated quarterly Pathways Career Development programme
• Flexible/remote working
• Pension
• Private Healthcare Cover
• Life Assurance
• Financial advice
• Employee Discount scheme
• Gym Discounts
• Bike to Work
• Fitness classes
• Mindfulness Workshops
• Employee Assistance Programme
• Generous holiday allowance
• Enhanced maternity/paternity leave
• Marriage/civil partnership leave
• Special leave policies
• Educational assistance
• Incentivised certifications, and accreditations, including AWS, Microsoft, Oracle, and Red Hat
• Version 1’s Annual Excellence Awards
• ���Call-Out’ platform
• Environment, Social and Community First initiatives