Job Description: Senior Data Modeler & Power BI Designer (Remote)
(5-8 Years of Experience)

Role Overview
We are seeking an experienced Data Modeler and Power BI Designer to support our Enterprise Data Warehouse (EDW), reporting, and business intelligence initiatives.
The role will primarily focus on understanding business reporting requirements, designing analytics-ready dimensional data models, and designing interactive Power BI reports and dashboards. The successful candidate will work closely with business stakeholders, business analysts, data engineers, and the EDW team to convert data into accurate, actionable, and easy-to-understand business insights.

Data Modelling and EDW Support
Design and maintain conceptual, logical, and physical data models for reporting and analytics.
Build dimensional models using star and snowflake schemas, including fact tables, dimensions, hierarchies, and conformed dimensions.
Translate normalized source-system data into business-friendly, reporting-ready structures.
Define appropriate data granularity, relationships, surrogate keys,



historical tracking, and slowly changing dimensions.
Collaborate with data engineers to ensure data models are implemented efficiently through ETL/ELT pipelines.
Perform data discovery, profiling, reconciliation, and quality analysis across multiple data sources.
Prepare and maintain source-to-target mappings, data dictionaries, entity-relationship diagrams, metric definitions, and report specifications.
Identify data-quality issues, reporting gaps, duplicate calculations, and inconsistencies across reports.
Participate in impact analysis for changes to source systems, data pipelines, business rules, and reporting requirements.
Ensure models and reports comply with enterprise naming conventions, modeling standards, governance practices, and security requirements.

Power BI Reporting and Analytics
Gather and analyze business reporting requirements, KPIs, measures, calculations, and dashboard expectat

📌 Senior Data Modeler (India)
🏢 VyntraPro Innovations
📍 India