Monitoring & Dashboard Developer

We are looking for a Monitoring & Dashboard Developer to join a project at a company specializing in the management of financial markets. The ideal candidate will design, develop, and deliver high-quality Grafana dashboards, SQL queries, and automated tests to ensure accurate monitoring and reporting of OEG/MDG data.

Key Responsibilities:

• Design Grafana dashboards based on specifications, including complex SQL requests targeting ClickHouse databases containing OEG/MDG messages. Some SQL queries may involve time-series specificities (e.g., windowing). Provide insights to optimize data queries.
• Ensure Grafana dashboards can be deployed and repeated automatically across multiple environments.
• Collaborate with testers to define a common QA plan enabling clear, accurate, and regular reporting via KPIs related to testing activities (design, execution, automation, regression). Deliver unit tests as required.
• Develop SQL code for new functionalities and tests, following coding standards and best practices.
• Maintain clear and accurate documentation related to implemented code.
• Actively contribute to continuous code improvement and delivery reports.
• Deliver Python and/or Java code alongside dashboards when needed (e.g., for generating Grafana dashboard screenshots in emails).

Technical Context:

• Model-driven development, including code generation using Java, XSL, or Python for database schema.
• Software delivery through Docker or RPM depending on the production environment. Configuration delivered via Ansible or AWS parameters, with CloudFormation used in AWS environments.
• Daily use of Java, Python, Git, Jenkins (Groovy), JIRA, AWS, and automated tests with Gherkin.

Requirements

• Expert in Grafana and SQL
• Experience with Python and Java
• Experience with ClickHouse
• Proficient in Git, Jenkins (Groovy), JIRA, and AWS
• Experience with CloudFormation, Ansible, Docker, RPM
• Experience with Gherkin for automated testing
• Bilingual / Fluent in English

Benefits

• Employment Contract;
• Health Insurance;
• Meal Card;
• Gym Ticket;
• Hybrid work (Porto).