Senior Data Engineer

Mine Tech Services (MTS) is a rapidly growing UK and Ukraine based mining consultancy. We are a diverse team of engineers, data scientists and developers who pride ourselves in helping to sustainably solve the key challenges facing the world’s commodity production.

We are looking for a Senior Data Engineer to add to our team in Lviv. The successful candidate will have a number of years of experience working with BI platforms, Microsoft SQL Server, Azure Data Platform, and GDP. Training and mentoring will be provided to develop the individual’s business application knowledge. Please note this is an office-based role, with a minimum of 3 days a week in our Lviv office.

Responsibilities will include

• Development of high-quality database solutions (predominantly within MS SQL Server).
• Develop, implement and optimize stored procedures, functions and ETL processes.
• Analyze and troubleshoot existing SQL-based solutions for performance improvements.
• Work with Google BigQuery to process and analyze large datasets, optimizing queries for performance.
• Expertise in building data transformation pipelines using DBT.
• Develop procedures and scripts for data transformation and migration.
• Architecture and strategic planning for future development.
• Scoping new technical briefs and providing informative solutions for stakeholders.
• Providing technical stewardship on projects; with ownership of engineering scopes, testing documentation and working with the Project Manager having oversight of work breakdown scheme in Jira as required.

Requirements

Technical Skills & Knowledge

• 3+ years overall experience with DWBI/ETL
• Experience with SQL Server and creation of Stored Procedures / Functions (T-SQL)
• Deep experience in SQL performance tuning and server administration
• Google BigQuery experience (DBT experience will be a plus)
• Understanding Azure Delta Lake.
• Understanding of the needs of data structures for Business Intelligence reporting inc. Tableau and Microsoft Power BI.
• Excellent attention to detail and ability to communicate and present complex technical information to all levels of stakeholders.
• Experience with Jira or similar project management tools

Personal Skills & Knowledge

• A very technology-focused individual with a strong interest in using systems and data to improve operational problems.
• Knowledge of the mining industry, or a drive to learn to enable them to act as a partner to our clients

• Interested in finding innovative but practical solutions to resolve complex challenges.
• Interested in working in a dynamic environment combining technology, software and large mining equipment.
• A good communicator — both written and orally in English (B2)
• A good listener (there is a consultancy element to the role).