sql server analytics & power bi developer_full-time_noida, pune, mumbai, delhi, chennai, bangalore
job title: sql server analytics & power bi developer
location: noida, pune, mumbai, delhi, chennai, bangalore
job type: full-time
experience: 5-10 years
skills: sql server analytics service (ssas), basic power bi, strong sql knowledge
job description:
- we are seeking an experienced senior sql server analytics & power bi developer to design and optimize high-performance data models and reporting solutions leveraging sql server analytics services (ssas), power bi, and advanced sql techniques.
- the successful candidate will have expertise in multidimensional modeling, complex query optimization, and data visualization, along with a deep understanding of how to architect solutions that integrate with larger data ecosystems.
key responsibilities:
- design and implement ssas cubes: architect, develop, and optimize olap cubes for reporting and analytics using sql server analysis services (ssas), focusing on performance tuning, security, and usability.
- advanced data modeling: develop complex data models within ssas, ensuring they are scalable and optimized for reporting efficiency. employ best practices in dimensional modeling (star and snowflake schemas) to deliver high-performing datasets.
- power bi integration: design power bi reports with complex visualizations, integrating ssas cubes and custom sql queries for enhanced data insights. implement advanced dax calculations and power query transformations.
- etl and data processing: design, implement, and optimize etl processes to populate ssas models from heterogeneous data sources, ensuring data integrity, validation, and consistency.
- performance optimization: apply advanced query tuning, indexing, partitioning, and caching techniques to optimize both ssas cubes and sql queries for fast, responsive reporting.
- collaborate with stakeholders: work closely with business analysts, architects, and stakeholders to translate complex business requirements into scalable data solutions.
qualifications:
- extensive experience with sql server (t-sql, ssis, ssrs, ssas).
- proficient in building and optimizing ssas multidimensional models, including cube design, mdx, and query optimization.
- expertise in power bi with advanced dax, power query, and report optimization techniques.
- strong understanding of data warehousing concepts and performance tuning techniques.
- hands-on experience with large-scale, enterprise-level data architectures.
- solid knowledge of advanced sql query writing and optimization strategies.
