Senior Power BI Data Modeler

Your Team Responsibilities

EDWH data modeling team is responsible for building high quality data models for MSCI Sales, Finance and Marketing teams. These models are used by internal stakeholders to build dashboard for data driven decision making. We are looking for a Senior Power BI Data Modeler who can help us building new BI models and enhancing existing models.

Your Key Responsibilities

• Gather business requirements and define technical design
• Define, implement, and optimize Data Modeling layer for Power BI Reports using SQL and Power BI
• Deep understanding of dimensional modeling, enterprise data warehouse and Azure Data Lake.
• Performance tuning of Power BI data model using aggregation configuration and incremental refresh

Your skills and experience that will help you excel

• 7+ years of experience in Power BI, Azure Sql, Azure Synapse or Azure Databricks.
• 7+ years of strong hands-on Power BI experience in creating large data models. Should be well versed with drill down and drill through techniques.
• Ability to understand complex data schemas and create optimized BI data models for reporting needs is a must.
• Hands-on experience in architecting Power BI Premium large Data-sets is required (leveraging XMLA end-points and Power-BI APIs).
• Able to implement row level security (RLS) on data and understand application security layer models in Power BI.
• Experience in data extraction, data modelling, data warehousing and performance optimization.
• Experience in managing Azure Power BI dedicated capacity and good understanding of management APIs required.
• Writing efficient and performant DAX queries is required.
• Experience of working with Microsoft Fabric for Direct Lake and Data Activator is a plus

Minimum Qualification

• Bachelor's Degree in Computer Science or related discipline.
• Demonstrated ability to work as an effective team member.
• Strong work ethic and motivation to constantly improve the product.
• Clear and effective communication and writing skills.
• Analytical, detail-oriented, and problem-solving aptitude.
• Knowledge of Marketing and financial data is a plus.

About MSCI

What we offer you

• Transparent compensation schemes and comprehensive employee benefits, tailored to your location, ensuring your financial security, health, and overall wellbeing.

• Flexible working arrangements, advanced technology, and collaborative workspaces.

• A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results.

• A global network of talented colleagues, who inspire, support, and share their expertise to innovate and deliver for our clients.

• Global Orientation program to kickstart your journey, followed by access to our Learning@MSCI platform, LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development.

• Multi-directional career paths that offer professional growth and development through new challenges, internal mobility and expanded roles.

• We actively nurture an environment that builds a sense of inclusion belonging and connection, including eight Employee Resource Groups. All Abilities, Asian Support Network, Black Leadership Network, Climate Action Network, Hola! MSCI, Pride & Allies, Women in Tech, and Women’s Leadership Forum.

At MSCI we are passionate about what we do, and we are inspired by our purpose – to power better investment decisions. You’ll be part of an industry-leading network of creative, curious, and entrepreneurial pioneers. This is a space where you can challenge yourself, set new standards and perform beyond expectations for yourself, our clients, and our industry.

MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data, and technology, we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process.

MSCI Inc. is an equal opportunity employer committed to diversifying its workforce. It is the policy of the firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, gender, gender identity, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy (including unlawful discrimination on the basis of a legally protected parental leave), veteran status, or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process, please email Disability.Assistance@msci.com and indicate the specifics of the assistance needed. Please note, this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries.

To all recruitment agencies

MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location, or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes.

Note on recruitment scams

We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on careers.msci.com