Job Description
Job Purpose
Module Lead is the key contributor for Microsoft BI team who facilitates code productivity and quality using technology knowledge, problem solving skills and innovative ideas. This role is responsible for producing the code that adheres to coding standards and continuously improved to deliver desire business requirements without compromising on quality standards.
This role focuses on development, creation, and modification of MSBI software applications, analyse user needs and develop ETL solutions. Enhance and design databases to support front end application, working individually as a lead developer on MSBI Stack and helping development team.
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
- Ensure availability to resolve any on-going issues and improve the overall health of project by implementing Programming practices across teams
Key Responsibilities
What you will be doing:
Position Objectives and Expectations
- Candidate must have standard MSBI (SSRS, SSIS, SSAS) skills on SQL Server 2016 or 2022 or Azure Cloud (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
- 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 having practical 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
Qualifications
Technical Requirements
Required/Essential Skills:
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 5 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 SQL SERVER 2016 or SQL SERVER 2022 or Azure Cloud
- 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
- Data warehousing experience using SSIS packages
- Worked on performance optimization for MSBI tool set – SQL Server (T-SQL), SSAS (cubes), SSIS, SSRS
- Experience of Tableau dashboard tool & PowerShell scripting from development perspective will be an added advantage
- Dimensional Modelling Experience
- An understanding of the range of "Visualizations/Charts" that are available and how they add value to the business when displaying data
Desired Skills
- Microsoft BI tool set certifications
- Trouble shooting knowledge in BI applications from development support perspective
Other Microsoft technology skills –
- Having basic knowledge of SharePoint and PowerShell 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 –
- Punctual, organized and efficient - ability to meet a daily publication deadline
- Ability to think laterally
- Strong adherence to processes and ability to solve the problems creatively
- Ability to remain calm and work effectively with clients when under pressure
- Competent in MS Office (Word, Excel, Outlook)
- 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
Company Description
Who we are
We are one of the largest international law firms in the world. With over 30 offices across the globe, we strive to exceed the expectations of our clients, providing them with the highest-quality advice and legal insight, which combines the firm’s global standards with in-depth local expertise.
Our firm, work and people span jurisdictions, cultures, and languages. We offer our clients a truly international perspective. We believe every career should be rewarding and stimulating - full of opportunities to learn, thrive, and grow. That’s why we’re so proud of our inclusive, friendly, and team-based approach to work.
Our one firm global strategy is focused on targeted growth led by the needs of our core clients, those who we can best support with the breadth and depth of Clifford Chance expertise, across the sectors and geographies, which matter most to them.
You’ll find our clients in commercial and industrial sectors, the financial investor community, governments, regulators, trade bodies, and not-for-profit organizations. But no matter who they are or why they’ve reached out to us, we provide a world-class service every step of the way. And that’s possible thanks to the entrepreneurial spirit and conscientious approach to work that you’ll find across all of our teams.
Whichever area of the business you join, you’ll become an integral part an innovative, diverse and ambitious team of people. Clifford Chance is a place where the brightest minds and the best of colleagues meet.
Additional Information
Equal opportunities statement
At Clifford Chance, we understand that our true asset is our people. Inclusion is good for our team and their families, our firm and society.
We are committed to treating all employees and applicants fairly and equally regardless of their gender, gender identity and expression, marital or civil partnership status, race, colour, national or ethnic origin, social or economic background, disability, religious belief, sexual orientation, or age. This applies to recruitment and selection, terms and conditions of employment including pay, promotion, training, transfer and every other aspect of employment.
We have a variety of flourishing employee networks. These networks are a place for colleagues to share experiences and advocate for change wherever they see an opportunity for improvement.
Our goal is to deliver an equality of opportunity, an equality of aspiration and an equality of experience to everyone who works in our firm.
Find out more about our inclusive culture here.
#LI-RS1
