Data Engineer - Leading Travel Company - Bristol
(Tech Stack: Data Engineer, Databricks, Python, Power BI, AWS QuickSight, Azure, AWS, TSQL, ETL, Agile Methodologies)
About the Company: Our client, a leading company in the travel industry, is seeking a talented Data Engineer to join their dynamic team in Bristol. This is a hybrid role, offering a blend of remote and in-office work, providing flexibility while maintaining a collaborative team environment.
Key Responsibilities:
- Maintain and optimise on-premises SQL Server data warehouses with a focus on stored procedures, indexing, partitioning, and load performance.
- Utilise Azure cloud tools including Azure Synapse Analytics, Azure Data Lake, Azure Data Factory, and Logic Apps for effective data management.
- Leverage hands-on experience with Microsoft Fabric or similar modern cloud platforms, emphasising data migration strategies and ETL development.
- Develop advanced SQL queries, stored procedures, and Python scripts for data manipulation, pipeline development, and automation.
- Design and optimise ETL processes and data pipelines using both on-premise tools like SSIS and cloud-based solutions like Azure Data Factory.
- Create and manage Power BI Premium reports, including data modeling, DAX, performance tuning, and advanced features such as composite models and incremental refresh.
- Implement data governance and security best practices, ensuring compliance with GDPR and other relevant regulations.
- Collaborate within an Agile framework, contributing to sprint planning, reviews, and retrospectives.
- Communicate effectively with stakeholders, translating complex data concepts into actionable insights and recommendations.
Essential Knowledge, Skills, and Experience:
- Extensive Data Warehouse Experience: Proven expertise in maintaining and optimizing SQL Server data warehouses, with a strong focus on stored procedures, indexing, partitioning, and load performance.
- Proficiency in Azure Cloud Tools: In-depth knowledge of Azure Synapse Analytics, Azure Data Lake, Azure Data Factory, and Logic Apps.
- Experience with Microsoft Fabric: Hands-on experience with Microsoft Fabric or similar platforms, particularly in data migration and ETL development.
- Advanced SQL and Python Skills: High-level proficiency in writing advanced SQL queries, stored procedures, and Python scripts for data manipulation and automation.
- ETL and Data Pipeline Expertise: Strong experience in designing and managing ETL processes using both on-premises tools like SSIS and cloud-based solutions like Azure Data Factory.
- Power BI Premium Expertise: Advanced skills in Power BI Premium, including data modeling, DAX, performance tuning, and utilizing advanced features like composite models and incremental refresh.
- Strong Understanding of Data Governance and Security: Comprehensive knowledge of data governance principles, security best practices, and compliance with GDPR and other regulations.
- Agile Methodology Experience: Demonstrated experience working within Agile teams and contributing to various Agile processes.
- Effective Stakeholder Communication: Excellent communication skills, with the ability to convey complex technical concepts to non-technical stakeholders clearly and effectively.
Benefits:
- Competitive salary
- Hybrid working model
- Opportunities for professional development
- Collaborative and innovative work environment
Location: Bristol, UK / Remote Working
Salary: £45,000 - £55,000 + Bonus + Pension + Benefits
Applicants must be based in the UK and have the right to work in the UK even though remote work is available.
To apply for this position please send your CV to Matt Jones at Noir.
NOIRUKTECHREC
NOIRUKREC
NC/RG/DE