BI Data Analyst (Power BI Semantic Data Modeler)

Job Description

Job Title : BI Data Analyst (Power BI Semantic Data Modeler) Location State : Karnataka Location City : Bangalore Experience Required : 6 to 7 Year(s) CTC Range : Depend on current salary Shift: Rotational Work Mode: Onsite Position Type: Contract Openings: 3 We are looking for Immediate joiners only with Excellent Communication skills Company Name: VARITE INDIA PRIVATE LIMITED Interested candidate share there updated resume sangeeta.t@varite.com For more information contact sangeeta @ 8929376486 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. About The Job: Design and develop robust Power BI datasets, semantic models, and reports to enable self-service reporting and deliver an intuitive end-user experience. • Write complex and efficient 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. Essential Job Functions: 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 modelling within Power BI, including knowledge of granularity, hierarchies, and relationships. • Proficiency in advanced Power BI functionality, including DAX, Row Level Security, Power Query, Performance Optimization, Composite Models, and Storage Modes. • Familiarity with data modelling tools and best practices for scalable, high-performance design. • Knowledge of Microsoft Fabric and its integration within enterprise analytics workflows. • Experience with Power BI Apps, audiences, and deployment pipelines, including report auto-binding across environments. • Strong problem-solving skills, attention to detail, and a focus on delivering actionable insights through data visualization. • Understanding of agile methodologies and experience working with tools like JIRA for project management. Qualifications: Bachelors degree in computer science, Information Systems, or a related field, or equivalent experience. • 6+ years of experience in data analytics, data modelling, and BI development in an enterprise environment. • 3+ years of hands-on experience with Microsoft Power BI (Pro/Premium capacity)- Mandatory • Proven experience with SQL-based data modelling and data warehouse design is essential. • Experience working with cross-functional teams to deliver scalable analytics solutions. How to Apply: Interested candidates are invited to submit their resume using the apply online button on this job post. Equal Opportunity Employer: VARITE is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, veteran status, or disability status. Unlock Rewards: Refer Candidates and Earn. If you're not available or interested in this opportunity, please pass this along to anyone in your network who might be a good fit and interested in our open positions. VARITE offers a Candidate Referral program, where you'll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE. Exp Req - Referral Bonus 0 - 2 Yrs. - INR 5,000 2 - 6 Yrs. - INR 7,500 6 + Yrs. - INR 10,000 About VARITE: VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA, UK, CANADA and INDIA. VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking, Cloud Infrastructure, Hardware and Software, Digital Marketing and Media Solutions, Clinical Diagnostics, Utilities, Gaming and Entertainment, and Financial Services.