Job Vacancy Software Developer mastering SQL / Grafana F/H

Description of the services to be rendered :

Deliver part of MDG Viewer / OEG Viewer Replacement project:

• Design Grafana dashboards corresponding to specifications, including potentially complex SQL requests, targeting the database (ClickHouse) loaded with OEG/MDG messages. Some SQL requests have time-series specificities (windowing…). Give insights on inserted data to enable optimized requests.

• The delivery of the Grafana dashboards should be repeatable in the various environments automatically.

• Establish with testers common QA plan allowing clear, accurate, regular reporting through KPI’s related to the testing activities (design, execution, automation, regression). Deliver Unit Tests.

• Context: o Model driven development, using code generation through Java, XSL or Python for the database schema o The delivery of software is made as Docker or RPM depending on the production environment, configuration is delivered through Ansible or AWS parameters, with CloudFormation typically for AWS

Deliverables :

• Grafana dashboards, with complex / time-series oriented SQL request • SQL code for new functionalities and tests, following coding standards, state of the art practices

• Clear and accurate documentation relative to implemented code

• Actively contribute to continuous code improvement

• Automated test suites, built around tests frameworks (Unit Test part)

• Deliveries reports

• Context: Java, Python, Git, Jenkins (Groovy), JIRA, tests automated using Gherkin, AWS

• Ability to deliver Python and/or Java code accompanying the dashboards is a plus, for example to enable “screenshots” of the Grafana dashboard in emails

Unity :

• We respect and value the people we work with

• We are unified through a common purpose

• We embrace diversity and strive for inclusion

Integrity :

• We value transparency, communicate honestly and share information openly

• We act with integrity in everything we do

• We don’t hide our mistakes, and we learn from them

Agility :

• We act with a sense of urgency and decisiveness

• We are adaptable, responsive and embrace change

• We take smart risks

Energy :

• We are positively driven to make a difference and challenge the status quo

• We focus on and encourage personal leadership

• We motivate each other with our ambition Accountability

• We deliver maximum value to our customers and stakeholders

• We take ownership and are accountable for the outcome

• We reward and celebrate performance