Data Engineer, Coniq

• Proactive problem solver
• Able to work independently, identifying problems and solutions and planning for future improvement
• Able to work with stakeholders that are not data experts
• Excellent attention to detail
• Highly proficient and experienced in any Native SQL - experience of MySQL dialect essential
• Understanding of Enterprise Queues and pipelines
• Understanding of APIs
• A strong understanding of agile methodologies
• Proficient in Python scripting or similar scripting language
• You have managed a high volume, high performance MySQL database in a multi-tenancy, SaaS environment
• You are highly proficient in creating, optimising and maintaining SQL queries and processes - including triggers and stored procedures
• Database health and performance is central to your thinking and work - you have experience of performance tuning, optimising and partitioning data in conjunction with analysing query performance
• You have designed and maintained processes to replicate data into redundant databases and into read-replica sets - including into different database systems
• You have supported an application development team to ensure that all data operations are optimal to the needs of the business
• You have an experience working with columnar and non-relational databases
• You have experience modeling and management of ETL/ELT processes on data flow systems; such as airflow, azkaban etc.; between tabular databases and data warehouses
• You have scripting experience in Python, bash or similar scripting language

Desirable

• Maintenance, development and expanding of multiple MySQL databases and data warehouses
• Ensuring data management systems health and performance
• Creating and optimising queries for data analysis and day-to-day data operations required by Coniq’s applications
• Supporting Data Analysts to transform client data requirements into executable queries
• Synchronising data between data sources (MySQL, 3rd Partydata sources, etc.) and data store systems (MySQL, Exasol, etc.)
• Supporting the application development team to build, validate and optimise database interactions
• Maintaining processes to ensure failover and disaster recovery
• Supporting the development team with data operations to facilitate software deployments
• Reports to Head of Data Operations