Are you passionate about data engineering and ready to play a key role in modernizing enterprise data systems?

We are looking for an experienced Lead Data Engineer to help reshape our client's data infrastructure as they transition from legacy technologies to their next-generation data platform with a focus on Snowflake & Power BI. This is an exciting opportunity to make a meaningful impact by designing and optimizing scalable database solutions, integrating advanced analytics capabilities, and driving innovation across our data ecosystem.

Responsibilities:

• Design, implement, and optimize cloud-based data platforms with a focus on efficiency, scalability, and performance.
• Develop and maintain ETL pipelines, leveraging Snowflake, Azure, and other modern data solutions.
• Drive best practices in data architecture and modeling, including Dimensional, DVM, and other methodologies.
• Support advanced analytics and reporting solutions using Power BI, ensuring seamless data access and visualization.
• Administer and manage BI tools, including Cognos/Power BI, handling configurations, security, and data connections.
• Utilize strong SQL expertise to work with structured and semi-structured data across platforms like SQL Server, DB2, and MongoDB.
• Implement DataOps practices to improve automation, monitoring, and efficiency in data workflows.
• Provide technical leadership, offering guidance on best practices and mentoring junior team members.
• Collaborate closely with stakeholders to translate business needs into scalable data solutions.

Skills Needed:

• 8+ years of experience in data engineering, with a strong recent focus on Snowflake and cloud data platforms.
• Expertise in ETL development using SSIS or similar tools.
• Deep understanding of data warehousing principles, including Kimball and other modeling frameworks.
• Experience administering and configuring BI tools like Power BI and Cognos.
• Solid SQL skills and hands-on experience with both relational and NoSQL databases.
• Strong problem-solving, analytical, and organizational skills.
• Excellent communication and stakeholder management abilities.
• Experience in production support processes, including incident and problem management.
• Project leadership experience is a plus.

To be considered for the role please apply online or email an updated Resume to William Barclay at Oliver James - william.barclay@oliverjames.com