This job posting isn't available in all website languages

Technical Lead (MSBI)

JR-2087 Requisition #

Technical Lead is the “Go-To Tech” person for both client and BI development team who facilitates technical strength using technology knowledge and solving impediments, managing risk, and driving program-level continuous improvement. Tech Lead is responsible for ensuring that delivery has desired code quality and teams technical skills are continuously sharpened. This role helps to implement technical strategy (incl. architecture roadmap) having clear visibility aligned to IT Roadmap.

What we need:

  • Substantial technology experience of more than 8 years undertaking initiatives covering design and development of composite BI&DW (Business Intelligence & Data Warehouse) applications
  • Should possess demonstrated 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
  • Extensive experience on Technical delivery, technical solution design
  • Deep understanding of Dataware housing concepts and practical implementation of enterprise data warehouse
  • Expertise on Microsoft BI technology stack – SQL/T-SQL, SQL Server Database (RDBMS), SSIS, SSAS – Tabular (DAX) / MOLAP (MDX), SSRS. Knowledge of MDS, Windows Azure will have added advantage
  • Strong understanding of dashboard development cycle i.e. data discovery, data modeling, data visualization, and distribution of reports/dashboards basis one of the dashboarding tools. While, knowledge of Power BI will be a big plus for this role!
  • An understanding of the range of "Visualisations" that are available and how they add value to the business when displaying data
  • Strong experience on an ETL, Reporting, dash boarding tool is highly desirable
  • Should have expertise in OLAP/MOLAP schemas, Semantic Layer design and implementation, writing of DAX and/or MDX queries
  • Strong ability on producing technical design for BI applications with focus on non functional requirements (NFR) like quality, scalability, performance and security
  • Strong experience in SQL Server 2012 or higher. Experience with SQL 2016 or higher will be given preference (incl. SSDT – SQL Server Data Tools as an IDE)
  • Experience on SQL migration from SQL Server 2008R2 to SQL Server 2016 for warehousing application will be definitely an edge/advantage
  • Strong experience on performance optimization for MSBI tool set – SQL Server (T-SQL), SSAS (cubes), SSIS, SSRS
  • Experience in dashboard development wherein experience of Power BI or Tableau will be an advantage
  • Knowledge of SharePoint administration, power shell scripting
  • A good understanding of the Applications Lifecycle Management(ALM), with full lifecycle experience, from design through to development, testing and deployment
  • Excellent documentation skills to be able to contribute to Architecture standard document and possessing strong knowledge of processes contributing at group/practice level e.g. Defining best practices and guidelines etc
  • A good understanding of agile methodologies, implementing eXtreme programming/practices such as Continuous Integration, Continuous Deployment, Pair programming, Test Drive Development etc
  • Assuring compliance to technical practices/standards through code review, design review 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

  • Excellent verbal and written English language communication skills, with particularly strong writing ability
  • Excellent analytical skills, attention to detail, and problem-solving skills
  • Good team collaboration skills
  • Ability to adeptly manage multiple priorities from demanding stakeholders
  • Keeps track of lessons learned and shares those lessons with team members
  • Excellent time management skills
  • Demonstrate ability to establish priorities
  • Ability to take initiative and self-motivate
  • Challenges others to develop as leaders while serving as a role model

Additional  Requirements

  • Experience in using development tools such as Visual Studio 2010 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

This role demands someone who is highly committed and motivated, great at understanding developer's mindset and helps them to see beyond current challenges. The person should have good communication skills, excellent at problem solving and breaking down complex tasks into simple easy to complete milestones, willing to jump in and solve the problem.

How you will influence:

  • Assist and steer the technology teams to implement the Architectural roadmap; Ensure stakeholder are informed of progress towards roadmap objectives
  • Help improve the technical productivity and knowledge by removing impediments
  • Improve the overall health of project by implementing eXtreme Programming practices across teams

What you will be doing:

  • Research and Development on technical implementation of Architecture initiatives
  • Closely working with Solution/Domain Architects on Architecture Epics/Initiatives as well as supporting in creation of High Level Design documents
  • Provide the Architects with information to assist in the development of/ validation of the architectural strategy roadmap for BI applications
  • Work as a Technical Solution Designer, leading the technical delivery by providing design support and guidance to development team ensuring out of the box solutions are implemented and challenge where appropriate. Should review and impact assess all application designs providing required feedbacks
  • 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 technical direction on development, design, and systems integration for client engagement from definition phase through deployment to production
  • Managing continuous integration/continuous deployment (CI /CD Builds) 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
  • Defining Coding and Unit testing (including scripted, automated unit testing) guidelines for the team and guiding them to follow the same
  • Design, Development (Coding) of quality and performing BI/DW (Business Intelligence & Dataware housing) applications that works and addresses business requirements against coding standards while working in a fast paced and dynamic environment
  • Will be responsible to develop and maintain core applications components, design principles, techniques, tools, document templates etc and work with wider technical teams to implement simple designs for complex problems
  • Development and coding of BI applications being implemented in different technologies primarily MSBI stack (SQL/T-SQL, SSIS, SSAS, SSRS) on SQL Server 2012 and higher version. With preference for SQL 2016 & higher version (SSDT – SQL Server Data tools as an IDE)
  • Creating customized and interactive dashboards using relational schema with Power BI and/or Tableau. Knowledge on one of the dashboard tool especially Power BI will be big plus for this role!
  • Dashboard deployment & testing in a multi-environment setup
  • Providing guidance to the team on complex technical issues
  • Holds regular status meetings with team. Perform code reviews and mentor team members
  • Work with Project Manager to define and size any impact assessments. Keep him well informed with status of development effort and serve as a liaison between development team and project manager
  • Manage communication regarding solution design/delivery with client technical stakeholders (architects)
  • Builds relationships with clients, both Business (PM, PO etc) and architecture demonstrating architecture concepts and details
  • Provide necessary application/technical guidance to Microsoft BI and Database teams aiding optimised implementation of system related changes
  • Will evaluate technical risks at program level and propose contingency plans. Contribute towards the development of new techniques, models, processes or plans within area of expertise
  • Diagnosis and troubleshooting of deployment/production issues


Requires B.E./B.Tech/MCA from reputed college 

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My applications

View your applications

My applications