Senior Data Lead - Azure Data Factory (ADF), Databricks (IN)
HCLTech
HCLTech
Seeking a seasoned Senior AtScale Developer to architect, refine, and support enterprise-level semantic models. This role demands a strong command of AtScale development, SQL proficiency, and a deep understanding of dimensional modeling and BI integration, complemented by expertise in modern cloud data environments.
The ideal candidate will possess proven experience in optimizing performance and integrating semantic layers with diverse cloud platforms. This is an opportunity to leverage your skills in a challenging and rewarding environment, contributing to critical data analytics initiatives.
Architect and maintain robust AtScale semantic models, defining dimensions, measures, hierarchies, and KPIs to align with business needs.
Translate complex reporting and analytical requirements into efficient, reusable semantic models.
Seamlessly integrate AtScale models with leading cloud data platforms like Databricks, Snowflake, BigQuery, and Microsoft Fabric/Azure.
Empower consumption of semantic models via popular BI tools including Power BI, Tableau, and Excel.
Develop and optimize advanced SQL queries for model implementation and troubleshooting.
Proactively analyze and enhance query performance to accelerate BI and reporting response times.
Collaborate with data engineers to resolve data quality and structural issues within source models.
Conduct comprehensive testing, including unit, integration, regression, and performance testing, to ensure model integrity.
Validate business calculations against source data and established definitions.
Troubleshoot and resolve production issues spanning semantic models, data, queries, security, and BI consumption.
Support deployment activities across all environments and maintain detailed technical documentation.
Champion enterprise semantic standards and best practices through active participation in code reviews.
Demonstrate extensive hands-on experience in AtScale development and a solid grasp of semantic modeling principles.
Possess advanced SQL skills and a thorough understanding of dimensional data modeling, including star-schema designs.
Exhibit experience with major cloud data platforms such as Databricks, Snowflake, BigQuery, or Microsoft Fabric/Azure.
Showcase practical experience integrating semantic models with BI tools like Power BI and Tableau.
Have a proven track record in troubleshooting query and analytical performance issues.
Understand the Software Development Life Cycle (SDLC), including source control, testing methodologies, and deployment procedures.
Proven experience delivering semantic models for enterprise BI/reporting use cases is essential.
HCLTech
IT Consulting