Data Modeling and Reporting Specialist

Best Infosystems Ltd.Bengaluru, Republic Of India, IN

30+ days ago

Job description

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.

Create a job alert for this search

Reporting Specialist • Bengaluru, Republic Of India, IN

Related jobs

Promoted
New!

Automation Specialist

Narwalhosur, tamil nadu, in

The ideal candidate will work closely with BI, Data, and QA teams to automate end-to-end validation processes across data pipelines and reporting dashboards. Develop test suites and automate.Power B...Show moreLast updated: 21 hours ago

Promoted
New!

AIML Engineer

Tata Consultancy Serviceshosur, tamil nadu, in

Competencies (Technical / Behavioral Competency).AI / ML, Azure ML Studio, AI / ML On Databricks, Python & CICD Devops.Supervised and unsupervised ML and Predictive Analytics using Python • Feature gener...Show moreLast updated: 21 hours ago

Promoted
New!

Data Reporting Analyst

WNS ProcurementBengaluru, Republic Of India, IN

Job Position : Associate – Procurement Services.Plot 8A, RMZ Centennial, Kundalahalli Main Road, Whitefield, Bangalore, India. This role focuses on ensuring alignment of supply and demand metrics, wh...Show moreLast updated: 21 hours ago

Promoted

Data Analytics Reporting Lead

OGSBengaluru, Karnataka, India

About Omnicom Global Solutions.Omnicom Global Solutions (OGS) is an agile innovation hub of Omnicom Group, a leading global marketing and corporate communications company.Guided by the principles o...Show moreLast updated: 21 days ago

Promoted

Zoho Data & Reporting Analyst

Scope Metals GroupBengaluru, Karnataka, India

We are looking for a highly motivated Data Analyst with proven expertise in the Zoho.The ideal candidate will play a key role in. Operations teams with actionable insights.This role will focus on da...Show moreLast updated: 30+ days ago

Promoted

Senior Data Modeler

Neutrino Advisory, an Inc 5000 Companyhosur, tamil nadu, in

The role involves designing and optimizing data models across transactional, analytical, and cloud environments using platforms such as SQL Server, Oracle, Snowflake, and Azure Synapse.The ideal ca...Show moreLast updated: 21 days ago

Promoted

Cloud Consultant - Data Migration & Reporting

Oraclehosur, tamil nadu, in

Oracle’s Customer Success Services (CSS) is on a mission to help our customers unlock the full potential of their Oracle investments. We partner with some of the largest enterprises globally, delive...Show moreLast updated: 20 days ago

Promoted
New!

Tableau Reporting Specialist

Tata Consultancy ServicesBengaluru, Republic Of India, IN

Greetings from Tata Consulting Services.TCS is Hiring for Tableau Developer.Proficiency in writing / debugging complex SQL queries involving multiple joins (inner, outer, cross), subqueries, and CTEs...Show moreLast updated: 21 hours ago

Promoted

Accounting & Reporting Specialist

ScalemetricsBengaluru, IN

Scalemetrics is a leading provider of modular CFO services, dedicated to supporting startups and SMEs in scaling their businesses globally. Mission : Enhance business predictability and value through...Show moreLast updated: 30+ days ago

Promoted

Data Integration and Reporting Specialist

Delta Air LinesBengaluru, Republic Of India, IN

Delta Air Lines (NYSE : DAL) is the U.Powered by our employees around the world, Delta has for a decade led the airline industry in operational excellence while maintaining our reputation for award-...Show moreLast updated: 19 days ago

Promoted

Data Modelling Specialist

ConfidentialBengaluru / Bangalore, India

Our Tier 1 Investment Banking client's Data Modelling team is looking for skilled BI and Data Modelling Specialists to help design and implement data architecture for tracking and reporting on our ...Show moreLast updated: 4 days ago

Promoted

Analytics and Reporting Specialist

RandstadBengaluru, Republic Of India, IN

Data analyst at Randstad Global Bangalore - India, hybrid, fulltime.Working at Randstad is unlike working at any organization. Because at Randstad we put people at the heart of everything we do.This...Show moreLast updated: 30+ days ago

Promoted
New!

Senior Data Visualization And Reporting Solutions Manager [T500-21240]

FMbangalore, karnataka, in

FM is a 190-year-old, Fortune 500 commercial property insurance company of 6,000+ employees with a unique focus on science and risk engineering. Serving over a quarter of the Fortune 500 and major c...Show moreLast updated: 21 hours ago

Promoted
New!

Financial Reporting Analyst

CohnReznickhosur, tamil nadu, in

What will your next career challenge offer? At CohnReznick, our people are talented, intellectually curious and driven to make a difference for our clients, community, and our firm.We are an organi...Show moreLast updated: 21 hours ago

Promoted
New!

Actuarial Specialist - Python

AInsurCohosur, tamil nadu, in

The Actuarial Specialist will be primarily responsible for building and validating actuarial models using Python, ensuring they meet detailed business specifications. The role requires a blend of te...Show moreLast updated: 21 hours ago

Promoted

Data Modeler

Recrohosur, tamil nadu, in

NoSQL) to support enterprise information management, BI, analytics, machine learning, and other business use cases.They drive data strategies, build models (conceptual, logical, physical), ensure p...Show moreLast updated: 22 days ago

Promoted

Machine Learning Specialist

upGrad RekrutBangalore Rural, Karnataka, India

Coding : Write clean, efficient, and well-documented Python code adhering to OOP principles (encapsulation, inheritance, polymorphism, abstraction). Experience with Python and related libraries (e.Te...Show moreLast updated: 19 days ago

Promoted

Data Integration & LLM Engineer

Chargebeehosur, tamil nadu, in

We are seeking a highly motivated.This role is ideal for engineers who enjoy working at the intersection of.APIs, SaaS connectors, and ETL / ELT pipelines to ensure reliable and scalable data flows.B...Show moreLast updated: 30+ days ago