Senior Lead - Applications (AP5)

Microland Limited; Bengaluru; On-site; INR 1,000,000 - 1,400,000; Full time

Job summary

Microland Limited is seeking a skilled BI/Data Engineering specialist to design, develop, and optimize data pipelines and analytics solutions. The role focuses on SQL, ETL, and Power BI within an Azure data ecosystem, delivering robust BI platforms and dashboards.

The ideal candidate will have strong proficiency in SSIS, SSAS, SSRS, and experience with Azure Data Factory, Databricks, and Power BI Online to enable data-driven decision making across business units.

Qualifications

• Experience with SQL, SSIS, ADF, cubes and Power BI.
• Strong knowledge of stored procedures and ETL processes.
• Excellent verbal and written communication and problem-solving abilities.
• Familiarity with software design patterns and programming principles.

Responsibilities

• Deliver high-quality, tested and secure code.
• Write well designed, testable, efficient, high quality code using industry standards.
• Gather and refine specifications and requirements based on technical needs.
• Develop technical documents and handbooks to accurately represent application design and code.
• Adhere to project processes and ensure SLA compliance.

Skills

SQL

Power BI

Python

JavaScript

Education

Engineer - B.E / B.Tech / MCA

Tools

Microsoft SQL Server

Power BI Online

SSRS

SSIS

SSAS

Azure Data Factory

Azure SQL

Databricks

Job description

Education Qualification

Engineer - B.E / B.Tech / MCA

Skills

• Primary -> Technology | Database Development|Microsoft SQL Server, Understanding of | 3 - Experienced
• Primary -> Technology | BI Tools / Systems | Microsoft Power BIBI Tools / Systems, Development | Microsoft Power BI | 4 - Advanced
• Secondary -> Technology | BI Tools / Systems, Development | SQL Server Reporting Services (SSRS)BI, DWH, ETL Roles | SSIS DeveloperBI Tools / Systems, Development | SSAS | 3 - Experienced
• Secondary -> Technology | Java Script / Python | 3 - Experienced
• Tertiary -> Technology | Azure Services - Azure Data Factory, Azure SQL, Databricks ETL | 2 - Knowledgeable
• Tertiary -> Technology | Power BI Online (SaaS) | 3 - Experienced

Delivery Skills

• 2. Deliver high quality, tested and secure code
• -Write well designed, testable, efficient, high quality code base by using industry standard software development practices.
• -Gather and refine specifications and requirements based on technical needs.
• -Develop technical documents and handbooks to accurately represent application design and code
• -Must have Strong knowledge on SQL, SSIS, ADF, Cubes and Power BI
• - Must have strong knowledge on Stored procedures and ETL process
• -Should have expert knowledge in writing SQL commands, queries and stored procedures. Ability to improve SQL performance: analyzing SQL joins and table structures
• 2. Excellent understanding of software design patterns and programming principles.
• -Should have Excellent Verbal and Written communication skills along with Problem-solving attitude and attention to detail
• 3. Perform thorough analysis and generate root-cause-analysis for any production issue
• -Provide necessary fixes and test the fixes to ensure no defect leakage.
• -Adherence to project processes and ensure SLA compliance.

Skill and Competency Management

• Define the job roles across team and the skills that employees need to do these jobs
• Assess recruits’ and employees’ competencies to determine how well their skills and knowledge match their job requirements
• Create development plans to close the skill gaps
• Monitor, measure, and repeat to achieve your individual, team goals

Succession Planning

Plan for succession and groom the next generation of technical resources for all critical roles

Other activities

• 1. Technical Assessments
• 2. Training need identification, Impart training and monitor
• 3. Cross skilling of resources