Gallagher And Mohan Private Limited Hiring For Data Analyst (SQL) at Remote

Gallagher And Mohan Private Limited; United States; Remote; USD 60,000 - 100,000; Full time

Job summary

Join a forward-thinking firm as a Data Analyst specializing in SQL and Power BI. In this dynamic role, you'll harness your analytical skills to develop and optimize complex SQL queries and create insightful reports that empower clients in the real estate sector. Your contributions will directly impact data-driven decision-making, helping clients navigate significant transactions in the real estate market. If you're passionate about data analytics and eager to work in a collaborative environment, this opportunity offers a chance to make a meaningful difference while advancing your career in a vibrant industry.

Qualifications

• 2+ years of experience in SQL and data analytics is required.
• Strong proficiency in Power BI and Excel for reporting.

Responsibilities

• Develop and optimize SQL queries for data extraction and analysis.
• Create and present Power BI reports to support decision-making.

Skills

SQL

Power BI

Excel

VBA

Spreadsheet Server

Query Designer

monday.com

Data Analytics

Communication Skills

Time Management

Education

Bachelor’s degree in Data Analytics

Bachelor’s degree in Business

Bachelor’s degree in Economics

Tools

Power BI

SQL

Excel

VBA

PowerPoint

Job description

Job Description

Position: Data Analyst (SQL & Power BI)

Company: Gallagher & Mohan

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, strong communication, and work ethic. The type of transactions we currently work on range from multifamily apartment complexes to large office towers in the United States and European markets, ranging in value from $10 million USD – $200 million+ USD.

Roles & Responsibilities

We seek a talented SQL (Major) and Power BI Analyst to join our team. As an SQL and Power BI Analyst, you will be responsible for developing, maintaining, and optimizing SQL queries and Power BI reports to support data-driven decision-making for our clients.

Primary Skills

• Develop complex SQL queries to extract, analyze, and manipulate data from multiple databases.
• Optimize SQL queries and database performance for improved efficiency and scalability.
• Previous work experience involving Spreadsheet Server and Query Designer is preferred.
• Provide technical support and troubleshooting for SQL and Power BI-related issues.
• Develop and present reports and dashboards to clients and management using Power BI.
• Utilize SQL for database management and data analysis.

Secondary Skills

• Good grasp of navigating through monday.com.
• Collaborate with team members and contribute to a diverse, collaborative, and driven professional environment.
• Foundational knowledge of finance.

Requirements

Education: Bachelor’s degree in Data Analytics, Business, Economics, or a related field.

Experience: A minimum of 2 years of practical experience in SQL is a must.

Knowledge

• Proven experience working with SQL databases.
• Strong proficiency in writing complex SQL queries and optimizing database performance.
• Strong command of Excel, Power BI, SQL, and VBA.
• Experience in managing workload, report production, and programs.
• Basic understanding of private equity, investment risk, and real estate investments.
• Knowledge of data analytics, with the ability to create reporting tools and dashboards.

Skills

• Ability to multitask and manage time effectively.
• Strong written and oral communication skills. Ability to present technical data clearly and concisely.
• Self-starter with proactive and strategic thinking.
• Proficiency in Excel, Power BI, SQL, VBA, PowerPoint, and database systems.
• Ability to work collaboratively within a team environment.

Job Specifications

Experience: 2 years (required)

Title: Data Analyst (SQL & Power BI)

Employment Type: Full Time, Permanent

Job Location: Remote (New Delhi)

Shift Timings: EST/PST (US Time Zone)

Note: Immediate availability preferred.