Gallagher & Mohan
Location
Delhi | India
Job description
Job Position: Data Analyst (SQL & Power BI)
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 towers in the United States and European markets and range in value sizes from $10 million USD - $200 million+ USD. What you're supposed to do: - 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 client. Moreover , candidates should possess previous experience in data integration within YARDI, coupled with a solid understanding of finance, and a preference for expertise in real estate finance. 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 Having a good grasp of navigating through monday.com. Collaborate with team members and contribute to a diverse, collaborative, and driven professional environment. Should possess a foundational knowledge of finance. Requirements – Skills, Knowledge, and Abilities: 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/Looker, 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. Organizational Skills: - Ability to multitask and manage time effectively. Communication Skills :- Strong written and oral communication skills. - Ability to present technical data clearly and concisely. Entrepreneurial: Self-starter with proactive and strategic thinking. - Ability to align research with business objectives. Computer Skills : Proficiency in Excel, Power BI/Looker, SQL, VBA, PowerPoint, and database systems. Team Player: 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.Job tags
Salary
