About the Company
Nice Software Solutions is a technology company that specializes in enterprise-grade Data Engineering, Analytics, BI Reporting, and AI solutions. With a global client base across India, the Middle East, the USA, and other regions spanning BFSI, Retail, Media, Automotive, and Life Sciences, the company offers structured career growth, global exposure, and a collaborative work culture. The company emphasizes impactful innovation, role-based growth paths, certifications, and continuous upskilling.
Role Overview
We are seeking an experienced Senior Data Modeler / Data Designer to lead the design, development, and governance of enterprise data models with a strong focus on risk data domains. The role holder will translate complex business and regulatory requirements into robust conceptual, logical, and physical data models, and will build analytical solutions using SQL Server Analysis Services (SSAS) and Power BI to support risk management, regulatory reporting, and executive decision-making. This is a full-time, work-from-office position based in Pune or Nagpur, India.
Key Responsibilities
- Data Modeling & Design: Design and maintain conceptual, logical, and physical data models across enterprise data warehouse, data marts, and analytical platforms. Develop and enhance dimensional models (star/snowflake schemas) and normalized models to support risk, finance, and regulatory reporting. Define and enforce data modeling standards, naming conventions, and metadata documentation. Perform data profiling, source-to-target mapping, and gap analysis.
- Risk Data Management: Design and manage data models covering credit risk, market risk, operational risk, and liquidity risk. Support regulatory and compliance reporting (e.g., Basel III/IV, IFRS 9, BCBS 239, Central Bank of UAE reporting). Work with Risk Management and Finance stakeholders to ensure data lineage, quality, and completeness. Contribute to data governance initiatives including data dictionaries, business glossaries, and data quality rules.
- Analytics & BI Development (SSAS & Power BI): Design, build, and optimize SSAS cubes (Multidimensional and/or Tabular models) including DAX/MDX measures, partitions, and security roles. Develop and maintain Power BI dashboards, datasets, and reports for risk, business, and executive stakeholders. Implement row-level security, incremental refresh, and performance tuning. Manage Power BI workspace governance, dataset certification, and deployment pipelines.
- Stakeholder Engagement & Leadership: Act as subject matter expert on data modeling and BI. Mentor junior team members. Participate in solution design reviews, architecture forums, and vendor evaluations. Communicate complex data concepts to non-technical stakeholders.
Tech Stack
- Data Modeling Tools: ERwin, ER/Studio, PowerDesigner, or equivalent
- Analytics & BI: SQL Server Analysis Services (SSAS) – Tabular / Multidimensional, DAX, MDX, Power BI
- Database: SQL Server, SSIS, SSRS
- Methodologies: Data warehousing (star/snowflake schemas), data governance, data profiling
- Domains: Risk data (credit, market, operational, liquidity), regulatory reporting (Basel, IFRS 9, BCBS 239)