Senior Software Engineer- MSBI Developer @ BNP Paribas

Responsibilities

Direct Responsibilities

• Should be able to translate business requirements into system design

• Should be able to analyse user requirements, functional specifications, and providing development effort estimates for the same.

• Background in data warehouse design (e.g. dimensional modeling) and data mining

• Experience of database design or integration experience with SQL Server database

• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework

• Experience delivering reporting, database, data integration and cube solutions

• Should be good at Communication (written + oral) Skills

• Should have Business/Customer facing skills

• Should have the ability to work independently as well as within a team

• Should take complete ownership of tasks and drive them to completion.

• Should be well aware about standard IT processes and methodologies such as SDLC, Agile and SCRUM

Contributing Responsibilities

• Should be a team player

• Should contribute to organization goals

• Analytical mind with a problem-solving aptitude

• Should be able to guide and mentor junior team members

• Should be experienced in managing large databases and experienced in DB and ETL performance tuning

• Should contribute to innovation initiatives

• Should strictly adhere to organization processes

Technical & Behavioral Competencies

The candidate should have a minimum of 5 years software development experience in Microsoft technologies primarily SQL Server (MSBI) and, SSIS. The candidate should be able to create and maintain ETL jobs developed in SSIS and write complex queries in SQL server. Good to have hands-on and the working knowledge of SSAS (SQL Server Analysis Services). Able to do performance tuning.

Primary Skills : SSIS and SQL Developer

Secondary Skills : SSAS, C#.net, SSRS and Python would be beneficial (not mandatory)

Miscellaneous: Awareness about tools such as Alteryx, PowerBI and Tableau is nice to have.

Specific Qualifications (if required)

MCA/B-Tech

Skills Referential

Behavioural Skills

Attention to detail / rigor

Ability to deliver / Results driven

Communication skills - oral & written

Organizational skills

Transversal Skills:

Ability to understand, explain and support change

Analytical Ability

Ability to anticipate business / strategic evolution

Ability to manage / facilitate a meeting, seminar, committee, training

Ability to manage a project

Education Level:

Bachelor Degree or equivalent

Experience Level

At least 5 years