Job Description

Business Intelligence Associate Technical Lead is responsible to work with Technical Consultant, Domain architect, key business stakeholders identifying and gathering requirements and delivering high end BI solutions/reports, drive the BI technical solutions. The resource will be required to work hands-on using technology knowledge and solving impediments, bring innovative approaches that continuously improve our ability to deliver faster, better and cheaper solutions while reducing the time and cost to build BI and analytics solutions and on-board with highest quality.


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:

• 
  Design and develop data structure, data model for BI system and support development team members in design and development of complex BI Solutions
• 
  Write complex SQL queries to fetch required data and Design Data warehouse solutions as pe business requirement
• 
  Improve the overall code base of the applications by ensuring compliance to coding standards and guidelines
• 
  Be responsible for generating actionable insights/recommendations to help clients address their ongoing problems
• 
  Ensure availability to resolve any on-going issues and improve the overall health of project by implementing eXtreme Programming practices across teams
• 
  Interact with required teams and stakeholders to determine their needs and to develop plans for continuous improvement
  

What you will be doing:

• 
  Design and build MSBI ETL, SSAS Cube ,SSRS reports and assist in development of complex ad hoc queries and analyses
• 
  Manage delivery and quality of work in line with agreed KPIs and SLAs
• 
  Perform required PoC on technical implementation as per business requirements
• 
  Closely work with Technical Consultant and Architect on Architecture Epics/Initiatives and support technical solutions
• 
  Ensure that all designs are built in accordance with industry best practice and standards. This includes ensuring that the logical modeling activity is consistent with the other technical project activities
• 
  Providing end to end software delivery on development, design, and systems integration for client engagement from definition phase through deployment to production
• 
  Ensure appropriate and latest code base source control using TFS and Release Automation tools (experience on XL Release tool will be given preference)
• 
  Automation of Release/Packaging process for BI applications through the use of PowerShell scripts
• 
  Learning new skills and technologies as required to meet the changing needs of business
• 
  Applying significant knowledge of industry trends and developments to improve the service to clients
• 
  Development and coding of BI applications being implemented in different technologies primarily MSBI stack (SQL/T-SQL, SSIS, SSAS, SSRS) on SQL Server 2016 and higher version. With preference for SQL 2016 & higher version (SSDT \xe2\x80\x93 SQL Server Data tools as an IDE)
• 
  Work with Technical Consultant to support resolution of any ongoing issues and technical solutions
• 
  Builds relationships with clients and required teams
• 
  Diagnosis and troubleshooting of deployment/production issues
  

What we need:

• 
  Candidate must have standard MSBI (SSRS, SSIS, SSAS) skills on SQL Server 2016 (SSDT \xe2\x80\x93 SQL Server Data tools as an IDE) that relate to following \xe2\x80\x93 SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services) \xe2\x80\x93 Tabular (DAX scripting) and Multidimensional (MDX scripting) cube models, SSIS (SQL Server Integration Services) and Relational Datawarehouse implementation, power shell scripting
• 
  Proven MSBI technology experience of more than 5- 6 years undertaking initiatives covering design and development of composite BI&DW (Business Intelligence & Data Warehouse) applications
• 
  Should possess demonstrated real hands-on work experience with designing/delivering one or more large BI & DW (Business Intelligence & Data warehouse) systems covering entire development lifecycle
• 
  Understands complex database concepts and effectively employ different database design techniques
• 
  Strong experience of ER Modeling, Dimensional Modeling, logical and physical database design
• 
  Strong understanding of dashboard development cycle i.e., data discovery, data modelling, data visualization, and distribution of reports/dashboards basis one of the dashboarding tools.
• 
  Strong ability on producing technical design for BI applications with focus on non-functional requirements (NFR) like quality, scalability, performance and security
• 
  Experience in dashboard development wherein experience of Power BI or Tableau will be an advantage (not mandatory)
• 
  A good understanding of the Applications Lifecycle Management(ALM), with full lifecycle experience, from design through to development, testing and deployment
• 
  A good understanding of agile methodologies, implementing eXtreme programming/practices such as Continuous Integration, Continuous Deployment, Pair programming, Test Drive Development etc
• 
  Ability to guide and lead Developers across multiple projects
• 
  Very strong communication skills are required. Must be capable of interacting with solution architects, other technology teams to identify technology opportunities
  

Personal Success Characteristics

• 
  Candidate should have very strong communication skills being required for this role. Must be capable of interacting with domain architect, business users and other technology teams
• 
  Excellent analytical skills, attention to detail, and problem-solving skills
• 
  Good team collaboration skills
• 
  Ability to adeptly manage multiple priorities from demanding stakeholders
• 
  Punctual, organised and efficient - ability to meet a daily publication deadline
• 
  Demonstrate ability to establish priorities
• 
  Ability to take initiative and self-motivate, Ability to remain calm and work effectively with clients when under pressure
  

Additional Requirements

• 
  Experience in using development tools such as Visual Studio 2015 or higher, configuration and design tools such as TFS, Visio etc
• 
  Agile/Scrum Methodology (experience in SAFe framework, Rally tool will be an added advantage)
  

Desired Skills

• 
  Relevant certification in Microsoft BI tool set and/or Dashboarding tool
  

Education and Experience

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

About the Firm


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.


We are a purpose-driven business with core values at the heart of everything we do, we actively demonstrate what it means to do the right thing both internally and externally. We want to create a space where everyone feels respected, included, valued, and listened to and our values are demonstrated through our behavior. Our Code of Conduct is value based and embodies five Principles \xe2\x80\x93 Act with Integrity, Be Inclusive, Embrace Challenge, Speak Up and Act Responsibly.


We offer you the opportunity to join a global law firm with one of the most pre-eminent legal practices in the world. We have an established presence in India for more than ten years, delivering value and supporting Clifford Chance offices across the globe in the areas of Information Technology, Finance, Business Research, Legal Support, Document Production, Project Management and Continuous Improvement. We have been certified as a \'Great Place to Work\' in India for implementing people practices that foster collaboration and enable employees to reach their full potential. We are proud of the colleagues who work for us and of the service that together we provide, many of whom are experts in their own sectors. Join us and you will experience, first-hand, the one firm, one team approach that makes working at Clifford Chance so different.


To find out more about what it is like to work in Clifford Chance in India, please visit link.


Equal Opportunities


At Clifford Chance we understand that our true asset is our people. We believe that each and every one of us should experience an equality of opportunity and an equality of experience here. We are always working to develop and deliver the best and most innovative approaches to make that happen. Inclusion is good for our team and their families, our firm and society.


We are therefore committed to treating all employees and job 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.


The firm will regularly review its procedures and selection criteria to ensure that individuals are selected, promoted and otherwise treated according to their relevant individual abilities and merits.


We have a a number of initiatives and networks that support our aspiration to be the Global Law Firm of choice. These include our LGBT, Gender Parity, Ethnicity and Disability networks.


#LI-RS2