Team Lead- MSBI

Mandatory Expectations:  

Excellent verbal and written communication skills. Punctuality and ability to meet deadlines. Strong team spirit and collaboration skills. Commitment to ethical work practices and professionalism. Attention to details and accuracy. Effective task and time management abilities. Demonstrated professional behavior and demeanor. Responsible and reliable work approach. Enthusiasm for work and a positive attitude. Confidence in decision-making and problem-solving. Right mindset and attitude towards work and colleagues. Ability to follow instructions and work well within a team. Willingness to act as a backup and mentor when needed. Familiarity with company policies and willingness to adhere to established processes. 

 Preferred Expectations: 

Develop and execute strategic plans to drive business growth and achieve organizational objectives. Effectively communicate with clients to understand their requirements, provide updates, and address any concerns or issues. Gather and analyze client requirements to ensure a clear understanding of project objectives and deliverables. Provide expertise to finalize the technical solution for a project, ensuring it aligns with the project requirements, mitigates risks and sets the foundation for successful implementation. Delegate tasks to team members based on their skills and capabilities, ensuring efficient project execution and resource optimization. Implement quality assurance processes to ensure project deliverables meet or exceed client expectations and adhere to industry standards. Take ownership of project responsibilities, handling multiple projects, ensuring timely delivery, adherence to budget and scope, and effective project management. Proactively manage changes in project requirements, evaluating impacts and proposing appropriate solutions. Strive to exceed client expectations and ensure their satisfaction with project outcomes, fostering long-term relationships. Contribute to business development efforts by identifying new opportunities, nurturing client relationships, and proposing value-added solutions. Establish clear and measurable goals for project deliverables, team performance, and individual objectives. Effectively manage and lead a team, providing guidance, support, and mentorship to drive productivity and professional growth. Timely filling of performance management systems (PMS) reviews for team members. Foster a collaborative and high-performing team environment, promoting teamwork, communication, and mutual support. Collaborate with stakeholders, both internal and external, to ensure effective communication and alignment throughout the project lifecycle. Bring forward innovative ideas and suggestions to improve processes, enhance project outcomes, and drive continuous improvement. Design learning paths and professional development opportunities to enhance team members' skills and knowledge. Ensure thorough and accurate documentation of project processes, requirements, and deliverables. Promote a culture of knowledge sharing, fostering collaboration and learning among team members. Effectively resolve conflicts within the team, encouraging open communication and finding mutually beneficial resolutions. Estimate project tasks and resources accurately to support effective project planning and resource allocation. Participate in the interview process to identify and select qualified candidates for project teams. Apply Agile methodologies to project management, ensuring iterative and collaborative development processes. Utilize version control systems to manage source code, track changes, and facilitate collaboration among team members. 

Technical Expectations: 

This position requires Expert level knowledge/proficiency level in the following: 

Strong proficiency in MS SQL, including database design, development, and optimization. Knowledge of the processes and technologies involved in ETL/ELT data integration as well as data migration. Proficient in SSIS features, components, and best practices to combine the data from multiple data sources to generate a single structure in a unified view. Understanding of data integration concepts, hands-on experience in building and managing data pipelines, and the ability to design, implement, and optimize data movement and data transformation workflows in the Azure cloud environment. Proficient in creating efficient, scalable, and high-performance analytical models using SSAS Tabular for effective data analysis and reporting. Creating efficient, scalable, and high-performance OLAP models using SSAS multidimensional for effective data analysis and reporting. Proficiency in Creating, managing and delivering interactive, tabular, graphical, or free-form SSRS reports from various data sources. Should have understanding of its features, functionality, and best practices for SSRS report development.Experience with MDX for multidimensional data analysis. Create, manage, and deliver interactive, tabular, graphical, or free-form reports from various data sources. Should have intermediate understanding of its features, functionality, and best practices for report development. Knowledge of Azure Synapse Analytics for big data processing and analytics. Intermediate proficiency in leveraging features of SharePoint Knowledge of C# is required for developing custom components, extending existing functionalities, and integrating with other systems.

---