(Ref.402/2020) - SQL Developer | Data Analytics
Job description
An exciting opportunity has come up in our team!
We are looking for a Data Analytics / SQL Developer!
THE ROLE:
- Participate in an agile based software development life-cycle including technical analysis, documentation, development, testing and code reviews.
- Develops and maintains applications and databases by evaluating client needs; analysing requirements; developing software systems;
- Aid in planning product development and timelines;
- Arrange project requirements in programming sequence by analysing requirements; preparing a work flow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic;
- Collaborate with the production support team for release and maintenance of the components;
- Work closely with the other developers in determining and following best development and architecture practice;
- Identify dependencies and coordinate with other teams when required;
- Propose and provide feedback from experience/knowledge on architecture, design, technology choices and technology direction of the platform;
- Actively mentors intermediate and junior developers in Lisbon and both in London and India through pair programming and code review;
- Fully participate in requirement and design meetings for new functionality;
- Provide 3rd line application support on a rotation basis within the team.
Requirements
What do I need to bring?
- The candidate is required to be educated to Degree level, have extensive experience in the SQL Server, python programming language, data warehouse design within Finance and/or Investment Banking;
- 5 years developer (Design, implementation, modification) experience under SQL Server
(2014/2016);
- Proficient in writing fine-tuned SQL queries, stored procedures (e.g. PL/SQL code) and working with data in relational databases like Oracle, SQL Server, MySQL etc. ;
- 2 years developer experience ETL in Python;
- Proven experience in Pandas;
- A strong level of autonomy is required, as well as pro-activeness and curiosity;
- Good level of experience in a delivery focussed development team;
- Experience in working within an environment with high pressure on timeliness and quality of deliveries – Behavioural / Level: Expert;
- Proven experience leading a development team;
- Ability to recognize and resolve system related problems; work independently and make necessary decisions throughout the systems process within department guidelines;
- Experience with Agile/Lean development;
- Wider IT culture & interest: OS, parallelization, network, machine learning, databases;
- Ability to write unit tests within standard frameworks;
- Ability and willingness to learn quickly and adapt to a fast changing environment, with a strong interest in continuous improvement and delivery;
- Excellent knowledge of programming best practices, design patterns etc.;
- Strong communication skills, both orally and in writing, inside and outside the team;
- Strong problem solving skills;
- Strong developer and architectural appreciation, happy to develop;
- Strong analytical and interpersonal skills as well as reporting capabilities;
- Strong communication and presentation skills both verbal and written;
- Be creative, innovative, pro-active and convincing in terms of finding solutions;
- Proactive and flexible approach to dealing with challenges;
- Team Working in a virtual environment;
- Integrate the multicultural dimension: Works with other cultures and businesses, integrating different interpersonal and working styles in his approach;
- Able to work collaboratively with users and managers, and able to communicate in terms business oriented individuals can understand;
- Customer oriented. We expect our team members to act as technology consultants to our business customers.
What will be valued?
-
Financial Banking business knowledge (products / exchanges);
- Developer experience in SSIS;
- Tableau;
- Data lineage analysis;
- Knowledge/ experience of Continuous Integration/Continuous Development best practices(Git, Bitbucket, Jenkins, Artifactory);
- C# experience.
What can Syone offer me?
- Integration in an organization with profound and sustained growth and involvement in pioneering projects with innovative technological solutions;
- Strong IT training plans;
- Professional evolution with intervention in ambitious technological projects, both national and internationally.