Sr Technical Lead | 9 to 12 years | Mumbai, Pune & Bengaluru

Job Description

• Interface with the client application teams for technical discussions and solution resolutions
• Collaborate with Technical SME’s, BI Administrators , Developers and Analysts for successful development of BI reporting and analysis solutions
• Design and implement Azure Synapse based integration solutions
• Design and implement the data model, develop tabular / multidimensional data models
• Design the Reporting Platforms technical components
• Review & finalize data transformation requirements.
• Convert business requirements into technical specifications
• Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations as needed
• Oversee the development of the dashboards build per approved wireframes and KPI deliverables agreed

Primary Skills

• Hands on experience in design of BI solution and enterprise architecture
• Strong expertise on MS SQL Server database
• 5+ years on MS BI technologies (Power BI,DAX, AAS, SSAS, SSRS, SSIS)
• Very strong hands on experience width Azure Data Lake, Azure Data Factory, Azure Synapse , ADLS Gen2, Azure Analysis Services
• Deep experience in data modelling
• Experienced in using APIs for Data Integration
• Proven ability to identify and fix issues, performance bottlenecks across the DWH, Datamart, Cubes, Reporting layers

Secondary Skills

• Strong documentation skills
• Excellent verbal/written communication & good interpersonal skills
• Experience on Agile – Scrum based engagements
• Domain knowledge of Resource (People) Supply Chain desired
• DP-203 certification desired