Software Developer mastering SQL / Grafana/ remote / Porto F/H

Smartpoint en bref, qui sommes-nous et en quoi nous sommes différents ?

Smartpoint est une ESN pure player Data & IA créée en 2006 à Paris. Nous concevons, modernisons, déployons et opérons des plateformes Data/IA de bout en bout, avec une approche DataOps & IAOps 360° : du cadrage à l’industrialisation, run et à amélioration continue. Notre valeur ajoutée : des architectures data production-ready, des pipelines automatisés et observables et une obsession de la valeur opérationnelle pour les métiers. Nos équipes interviennent sur l’ensemble des grands chantiers Data & IA : architecture et modernisation des plateformes, data engineering & XOps (DataOps, MLOps/LLMOps), IA / IA générative (LLM, RAG, agents), BI & analytics (modernisation BI, reporting, dashboards) ainsi que gouvernance des données & qualité (catalogue, lineage, data quality, data contracts). Quelques repères : +300 experts, SmartLab (R&D inshore à Paris, agrément CIR), certifications ISO 27001/27701, engagement RSE et bilan carbone.

Vos responsabilités et le périmètre du poste

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

Votre profil

Software Developer mastering SQL / Grafana technologies with many years of experience 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…). The delivery of software is made as Docker or RPM 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…). The delivery of software is made as Docker or RPM

Vos qualités pour réussir