11 Sep
|
VARITE
|
Bengaluru
Company Name: VARITE India Private Limited
About The Client:
An American software development company founded in 1993. It is headquartered in Redwood City, California. Its core products include enterprise cloud data management and data integration.
Essential Job Functions:
- Design and develop robust Power BI datasets, semantic models, and reports to enable self-service reporting and deliver an Clientive end-user experience.
- Write complex and effective SQL for data extraction, transformation, and loading (ETL), including development of optimized views and queries to support reporting needs.
- Develop and optimize star schema-based data models by designing dimension tables, fact tables, and relationships to ensure scalability and performance.
- Leverage advanced DAX for creating measures, calculated columns, and field parameters to enhance reporting capabilities.
- Collaborate with data engineers, architects, and platform teams to ensure accurate data modeling and warehouse design that aligns with business requirements.
- Translate business reporting needs into concrete technical requirements, focusing on data warehousing best practices and semantic modeling.
- Conduct data validation, testing, and performance tuning to maintain high-quality data models and reports.
- Define and standardize design and development practices across enterprise data models to promote consistency and reusability.
- Provide guidance on Power BI deployment pipelines, workspace management, and cross-environment report automation.
Qualifications:
- Expert-level SQL skills, including complex query writing, view development, and optimization techniques for large datasets.
- Strong understanding of data warehousing principles (e.g., ETL processes, dimensional modeling, star schemas, and snowflake schemas).
- Expertise in semantic moClienting within Power BI, including knowledge of granularity, hierarchies, and relationships.
- Proficiency in advanced Power BI functionality, including DAX,
📌 Consultant (Bengaluru)
🏢 VARITE
📍 Bengaluru