Senior SQL Developer

<p>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.</p><p>We are looking for a Senior SQL Developer to add to our team. The successful candidate will have a number of years of experience working with BI platforms, Microsoft SQL Server, and GDP. Training and mentoring will be provided to develop the individual’s business application knowledge. </p><p><br/></p><p>Responsibilities will include</p><ul> <li>Development of high-quality database solutions (predominantly within MS SQL Server).</li> <li>Develop, implement and optimize stored procedures, functions and ETL processes.</li> <li>Analyze and troubleshoot existing SQL-based solutions for performance improvements.</li> <li>Work with Google BigQuery to process and analyze large datasets, optimizing queries for performance.</li> <li>Expertise in building data transformation pipelines using DBT.</li> <li>Develop procedures and scripts for data transformation and migration.</li> <li>Architecture and strategic planning for future development.</li> <li>Scoping new technical briefs and providing informative solutions for stakeholders.</li> <li>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.</li> </ul><p><strong>Requirements</strong></p><p><em>Technical Skills &amp; Knowledge</em></p><ul> <li>3+ years overall experience with DWBI/ETL</li> <li>Experience with SQL Server and creation of Stored Procedures / Functions (T-SQL)</li> <li>Deep experience SQL performance tuning and server administration</li> <li>Google BigQuery experience (DBT experience will be plus)</li> <li>Understanding of the needs of data structures for Business Intelligence reporting inc. Tableau and Microsoft Power BI.</li> <li>Excellent attention to detail and ability to communicate and present complex technical information to all levels of stakeholders. </li> <li>Experience with Jira or similar project management tools</li> </ul><p><em>Personal Skills &amp; Knowledge</em></p><ul> <li>Very technology-focused individual with a strong interest in using systems and data to improve operational problems.</li> <li>Knowledge of the mining industry, or a drive to learn to enable them to act as a partner to our client’s </li> </ul><ul> <li>Interested in finding innovative but practical solutions to resolve complex challenges.</li> <li>Interested in working in a dynamic environment combining technology, software and large mining equipment.</li> <li>A good communicator - both written and orally in English (B2)</li> <li>A good listener (there is a consultancy element to the role).</li> <li>Willing to travel periodically if able (globally and sometimes to remote locations).</li> </ul><p><strong>Benefits</strong></p><p>At MTS, we offer a range a benefits including flexible working and as we have projects across the Americas, Europe, Africa, Australia and the CIS, from day one, we make sure every team member gets the opportunity to work on different projects to provide career learning and growth opportunities and travel where possible.</p>