This website uses cookies to ensure you get the best experience. Learn more
Clifford Chance

Senior Software Engineer (MSBI Developer)

Skills & Experience – Senior Software Engineer

Standard Microsoft BI skills (SSRS, SSAS, SSIS) on SQL Server 2016 and higher version with primary focus on SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services) – Tabular cube models (DAX scripting), Multi-dimensional cube models (MDX), SSIS (SQL Server Integration Services), knowledge on any Dashboard tool will be an added advantage

§  Substantial technology experience of more than 4 years on BI&DW (Business Intelligence & Data Warehouse)

§  Should have experience in OLAP schemas design, development and deployment of – Tabular and Multi-dimensional cube models, writing DAX and MDX queries

§  Should have experience in SQLSERVER 20016 (Knowledge of SQL Server 2008R2 – BIDS will be useful to support with migration activity)

§  Experience in MS BI Tools – SSRS, SSAS and SSIS (knowledge on SSDT – SQL Server Data Tools IDE)

§  Creating database objects using SQL Server 2016 database (T-SQL) and work on Performance optimization

§  Design, Development and Deployment SSRS reports including paginated reports, highly graphical/charting report outputs, Mobile Reports & KPIs, Custom branding, Data driven subscription, Alerting mechanism etc. Knowledge of Power BI Report Server or Web Portal to deploy SQL 2016 Reports

§  An understanding of the range of "Visualizations/Charts" that are available and how they add value to the business when displaying data

§  Data warehousing experience using SSIS package

§  Worked on performance optimization for MSBI tool set – SQL Server (T-SQL), SSAS (cubes), SSIS, SSRS

§  Experience of any dash-board tool from development perspective will be an added advantage

§  Dimensional Modelling Experience

Desired Skills

MSBI Skills –

§  Microsoft BI tool set certifications

§  Trouble shooting knowledge in BI applications from development support perspective

§  Having basic knowledge of SharePoint and Power shell scripting

Ø  Additional  Requirements

§  Visual Studio 2015 and above, Experience with configuration and design tools such as Team Foundation Server (TFS), Visio etc

Ø  Personal Success Characteristics

§  Candidate should have very strong communication skills being required for this role. Must be capable of interacting with solution architects, business users and other technology teams

§  Candidate should have good team collaboration skills, high level of attention to detail and good analytical\research capabilities

§  Candidate should be –

o   Punctual, organised and efficient - ability to meet a daily publication deadline

o   Ability to think laterally

o   Strong adherence to processes and ability to solve the problems creatively

o   Ability to remain calm and work effectively with clients when under pressure

o   Competent in MS Office (Word, Excel, Outlook)

o   Ability to learn and work on the publication platform

Education and Experience

-          Requires B.E./B.Tech/MCA from reputed college with high grades, and strong relevant professional experience


Key responsibilities

Ø  Position Objectives and Expectations

-          Candidate must have standard MSBI (SSRS, SSIS, SSAS) skills on SQL Server 2016 (SSDT – SQL Server Data tools as an IDE) that relate to following – SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services) – Tabular (DAX scripting) and Multidimensional (MDX scripting) cube models, SSIS (SQL Server Integration Services):

§  Experience in SQL Server version with SSDT – SQL Server Data tools as an IDE will be required from code base migration from – SQL Server 2008R2 (BIDS as an IDE) to higher version SQL Server 2016 (SSDT – SQL Server Data tools as an IDE)

§  Person will be involved in SSRS – Report development on OLAP schema using MDX, SSAS (Cube creation – both Tabular and Multi-dimensional, Writing DAX, MDX scripting), SSIS package creation, execution and deployment of SSAS, SSIS, SSRS objects in a multi-environment setup

§  In addition to standard MSBI stack, candidates havingpractical knowledge on any dash-boarding tool will be given preference over others for this position having experience in –

·       Creating customized and interactive dashboards using relational schema and/or multi-dimensional data sources (SSAS Cubes)

·       Knowledge on Dashboard Server administration/support

-          Technical Documentation (Low Level Design, Technical specification/approach, PoC/Spikes) and scripted unit testing

-          Performing peer reviews

-          Experience of working in Agile Methodologies from development process perspective


Team Summary:

Senior Developer is the key contributor for Microsoft BI team who facilitates code productivity and quality using technology knowledge, problem solving skills and innovative ideas. Senior Developer is responsible for producing the code that adheres to coding standards and continuously improved to deliver desire business requirements with high level of quality.

This role demands someone with high analytical ability and who is highly committed and motivated. The person should have good communication skills, excellent at removing impediments and breaking down complex tasks into simple easy to complete milestones, willing to jump in and solve the problem.

How you will influence:

-          Solve complex business problems using technical knowledge

-          Deliver the application feature using shortest possible lead time

-          Improve the overall code base of the applications by ensuring compliance to coding standards and guidelines.



Clifford Chance is one of the world's leading law firms, helping clients achieve their goals by combining the highest global standards with local expertise.  The firm has unrivalled scale and depth of legal resources across the three key markets of the Americas, Asia and Europe and focuses on the core areas of commercial activity: capital markets; corporate and M&A; finance and banking; real estate; tax; pensions and employment; litigation and dispute resolution. Clifford Chance's aim is to be the leader of an elite group of law firms.

Clifford Chance Business Services provides a wide range of IT Enabled Services to its client/parent company, Clifford Chance LLP. Having grown steadily over ten years, the company employs more than 600 highly skilled and experienced professionals enabling the organisation to successfully support its client in the following areas:

  • Finance
  • Information Technology
  • Administration and Research
  • Legal Support Centre
  • Document Production Unit
  • Project Management and Continuous Improvement

Job Title

Senior Software Engineer


Unit No. 3, First Floor, Ambience Corporate Tower II, Plot No. 3, Ambience Island, NH-8, Gurgaon, Haryana, India

Global Career Band


Global Role Type

Administrator Assistant

Position Type


Days/Hours of Work

General Shift (8 a.m.-16:30 p.m.)

Reports to

Team Leader


Education and Experience-Requires B.E./B.Tech/MCA from reputed college with high grades, and strong relevant professional experience

Apply Now

Share this