ADF Senior Technical Specialist (IN)
HCLTech
HCLTech
We are seeking a seasoned Senior AtScale Architect/Developer to spearhead the design and implementation of enterprise-scale semantic layers. This role involves defining robust semantic architectures, crafting reusable business models and metrics, and seamlessly integrating AtScale with contemporary cloud data platforms. The objective is to empower high-performance analytics across diverse BI and reporting tools.
The ideal candidate possesses a potent blend of solution architecture expertise, multidimensional and data modeling proficiency, AtScale development acumen, advanced SQL skills, performance optimization capabilities, and strong stakeholder engagement abilities.
Lead the architectural vision, design, and deployment of AtScale-powered enterprise semantic layers. Develop scalable semantic models, including dimensions, measures, hierarchies, calculated metrics, and key performance indicators. Establish clear semantic modeling standards to ensure consistent definitions and promote reusable business logic across analytics applications.
Configure and develop AtScale models to address complex analytical and reporting needs. Architect integrations between AtScale and leading cloud data platforms like Databricks, Snowflake, Google BigQuery, or Microsoft Fabric. Seamlessly connect the semantic layer with prominent BI and visualization platforms such as Power BI, Tableau, Looker, and Excel.
Define strategic approaches for logical and physical model optimization, crucial for supporting large-scale analytical workloads. Conduct in-depth query and model performance analysis, optimizing complex analytical workloads. Collaborate closely with data engineering teams on underlying lakehouse/warehouse models, dimensional models, fact tables, dimensions, aggregations, and data pipelines.
Design semantic models that champion governed, reusable enterprise metrics, thereby preventing the duplication of business logic within individual reports. Establish comprehensive security and access-control patterns for governed analytics. Implement robust development standards, naming conventions, model governance policies, deployment practices, versioning, and release processes.
Address and resolve complex technical issues that span the BI layer, semantic models, SQL/query generation, and underlying data platforms. Perform architecture reviews and offer expert technical guidance to AtScale developers and downstream BI teams. Foster collaboration with business, data engineering, BI, architecture, and governance teams to translate intricate business definitions into practical technical semantic models. Support the strategic migration of existing BI semantic models and business logic into an enterprise AtScale semantic layer.
Actively participate in all phases of the project lifecycle, including requirements analysis, estimation, technical design, testing, deployment, and production support. Produce comprehensive architecture documents, semantic model documentation, detailed design specifications, and essential operational/runbook documentation.
Possess strong, hands-on experience with AtScale, encompassing both development and architecture of semantic models. Demonstrate a profound understanding of semantic layer architecture and multidimensional modeling principles. Exhibit expertise in defining measures, dimensions, hierarchies, calculated metrics, and reusable business KPIs.
Showcase excellent SQL skills and proven experience in troubleshooting complex analytical queries. Maintain a solid grasp of: - Star and snowflake schemas - Fact and dimension modeling - Data warehouse/lakehouse architecture - Aggregations and query optimization strategies - Slowly Changing Dimensions - Enterprise data governance principles
Bring substantial experience with at least one modern cloud analytical platform, with a preference for Databricks or Snowflake; experience with BigQuery or Microsoft Fabric is highly advantageous. Be adept at integrating semantic models with leading BI tools like Power BI, Tableau, Excel, and Looker. Possess proven experience in performance troubleshooting across semantic, BI, and data platform layers.
Demonstrate a clear ability to translate complex business requirements into scalable, enterprise-grade semantic models. Exhibit strong skills in architecture documentation and effective communication. Preferred qualifications include experience implementing AtScale in large enterprise settings, modernizing legacy BI solutions, exposure to major cloud providers (Azure, AWS, Google Cloud), familiarity with CI/CD and source control for analytics, and experience within regulated industries.
HCLTech
IT Consulting