Lead Software Engineer - MSBI

Responsibilities:

Minimum 7-9 Years of Rich Experience in developing solutions on MSBI Tech stack including SQL, SSIS .
Should have Good Knowledge and implementation on database modelling techniques.
Should have hand on experience on ETL technologies like SSIS
Should have Good work experience on Creation of Sub Queries, Joins, Stored Procedures, Views, Functions, Cursors and Triggers etc.
Good to have Cube development techniques using SSAS. (Optional)
Good to have worked on Partitions, Processing mechanism of cube, modelling concepts of cube. (Optional)
Should have Good work experience on working on recursive Datasets.
Should have good knowledge on Database optimization, Query optimization & Resolving performance issues of the queries.
Should be Good in Analytical thinking and should be able work independently on the assigned task
Should have Good Knowledge on database Deployment proces
Should have worked on agile project implementations
Good to have - Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Good to have - Building Reporting solutions with architecture understanding.

Experience in code reviews, peer reviews.
Coding standardization and mentoring of junior team members.
Experience in upskilling juniors troubleshooting issues.
Experience in various design patterns. Should be able to propose end to end design based on the requirements at application level.
Experienced in using GIT.

Profile Required:

7-9 years of Good knowledge and experience in designing and implementing technical architecture based on SQL/SSIS/SSAS technologies
Good communication and Good interpersonal skills
Comfortable to work as a team and share information with the teammates
Must have Good Knowledge on SQL Server with T-SQL and SSIS
Good knowledge on SQL Server Analysis service (SSAS) - Optional
Good to have knowledge and experience in power BI / Data Warehouse. Optional
Able to develop SSIS package Independently using data flow and control flows
Independently design components, develop code and test case scenarios by applying relevant software craftsmanship principles and meet the acceptance criteria.
Complete the assigned learning path. Take part in team ceremonies be it agile practices or chapter meetings.
Deliver on all aspects of Software Development Lifecyle (SDLC) in-line with Agile and IT craftsmanship principles.
Deliver high-quality clean code and design that can be re-used.
Actively, work with other development teams to define and implement API's and rules for data access.
Ensure customers, stakeholders and partners are rightly communicated on time.
Assess production improvement areas such as recurrent issues.
Perform daily checks and maintain required standards and production processes.
Provide suggestions for automating the repetitive and regular production activities.
Perform bug-free release validations and produce metrices, tests and defect reports.
Assist in developing guidelines and ensuring that team practices them.
Ability to perform level 2/level 3 production support

Specific Context

Development expertise needed

Environment

At Societe Generale, we are convinced that people are drivers of change, and that the world of tomorrow will be shaped by all their initiatives, from the smallest to the most ambitious. Whether youre joining us for a period of months, years or your entire career, together we can have a positive impact on the future. Creating, daring, innovating and taking action are part of our DNA.

If you too want to be directly involved, grow in a stimulating and caring environment, feel useful on a daily basis and develop or strengthen your expertise, you will feel right at home with us!