Data Analyst

What we are and what we do: -

Gallagher & Mohan works exclusively within the real estate industry. Our mission is to provide financial analysis, marketing, and accounting support to our clients. Our clients are real estate-focused private equity investors, developers, fund managers, brokers, and more. We pride ourselves on our quality, our strong communication, and our work ethic. We are a natural extension of our client’s existing infrastructure. The type of transactions we currently work on range from multifamily apartment complexes to large office buildings in the United States and European markets and range in value sizes from USD 10 million - $200 million+ USD.

https://www.gallaghermohan.com/

:

As a Data Analyst specializing in Power BI, you will be responsible for transforming raw data into meaningful and visually appealing reports and dashboards. You will collaborate with cross-functional teams to understand their data requirements, design appropriate data models, and deliver insightful analytics solutions using Power BI. Your role will involve data extraction, data cleansing, data analysis, and visualization.

What we are Looking for: -

Roles & Responsibilities:

· Collaborate with stakeholders to gather and understand their data requirements.

· Develop data models and implement data transformations using Power BI and other relevant tools.

· Extract, clean, and manipulate large data sets from various sources to ensure data quality and integrity.

· Analyse complex data to identify trends, patterns, and insights.

· Design and create visually appealing and interactive reports, dashboards, and data visualizations using Power BI.

· We expect that the candidate is an expert in Excel and has the capabilities to use SUM, Average, SUMIF, PMI, NPV, IRR, VLOOKUP, RUNDOWN, PV, Index Match, IF(MIN, MIN), IF(VLOOKUP), HLOOKUP, SUMPRODUCT, and more.

· Proactively leverage knowledge from research for products, client projects, and business development efforts.

· Develop and maintain data governance and data quality standards.

· Perform ad-hoc data analysis and provide actionable recommendations to support decision-making processes.

· Stay up to date with the latest data visualization and analytics trends and techniques.

· Track and analyze all aspects of the local commercial real estate market.

· Responsible for analyzing and creating reports on the local real estate market and regional economy concerning employment statistics, major company activities, industry trends, and demographics that affect the local real estate market.

Requirements – Skills, Knowledge, and Abilities: 

· Bachelors degree in a relevant field such as Computer Science, Statistics, Mathematics, or a related discipline.

· Proven experience as a Data Analyst, preferably with expertise in Power BI.

· Strong knowledge of data analysis techniques, including data cleansing, data transformation, and data visualization.

· Proficient in SQL and advanced Excel functions.

· Experience working with large and complex data sets from diverse sources.

· Excellent analytical and problem-solving skills.

· Solid understanding of database concepts and SQL querying.

· Familiarity with data warehousing and ETL processes.

· Strong communication and presentation skills, with the ability to effectively convey complex data insights to non-technical stakeholders.

· Ability to work independently and collaboratively in a fast-paced environment.

Job Specifications:

• Title: Data Analyst - Power BI
• Department: Financial Analysis.
• Employment Type: Full Time, Permanent.
• Job Location: Working Remotely (Covid-19), New Delhi.
• Shift Timings: EST or PST (As per requirements)