Sr BI Analyst / Lead BI Analyst

Data Automation Intern (Remote) 

GreenTree is an asset management firm specializing in cross-border real estate investment banking in China and the USA. This is an online/remote internship. The internship is unpaid. It is up to the applicant's discretion to choose a start and end date (the dates listed on the posting are flexible). You will be given a short quiz to test your background and passion for data automation. 

Responsibilities: 

• ▪ Work with large datasets to clean, transform, and organize data for analysis and reporting. 
• ▪ Develop and implement automated data pipelines using Excel, Power Query, Power BI, or other data tools. 
• ▪ Research and recommend tools to improve data workflow efficiency. 
• ▪ Collaborate with other teams to gather data requirements and support automation goals. 
• ▪ Test and troubleshoot automated solutions and workflows to ensure data accuracy. 

Qualifications: 

• ▪ Strong understanding of Excel and data processing tools (Power Query, Power BI, or similar). 
• ▪ Passion for automating data workflows and improving efficiency. 
• ▪ Excellent attention to detail and problem-solving skills. 
• ▪ Proficient in Microsoft Office Suite (especially Excel), and familiarity with Google Sheets is a plus. 
• ▪ Self-driven and organized with strong communication skills. 
• ▪ Willingness to learn new tools and apply feedback quickly. 
• ▪ Ability to prioritize and manage multiple tasks independently. 

While this position is unpaid, it can be used to receive course credit at partner universities. 

About GreenTree: 

GreenTree provides project identification, acquisition negotiation, developer liquidity, strata asset pricing, property management, and leasing solutions. GreenTree identifies and underwrites project risk, pricing, and strategies while simultaneously negotiating with developers and 3rd-party sales rep companies for projects in the USA and China. 

Our value-add is project identification, acquisition negotiation, developer liquidity, strata asset pricing, property management, and leasing solutions. GreenTree identifies and underwrites project risk, pricing, and strategies while simultaneously negotiating with the developer and 3rd-party sales rep companies. 

Greentree’s website: www.greentree.group 

Qualifications & Experience:

▪ 2 - 4 years overall experience in ETLs, data pipeline, Data Warehouse development and database design

▪ Software solution development using Hadoop Technologies such as MapReduce, Hive, Spark, Kafka, Yarn/Mesos etc.

▪ Expert in SQL, worked on advanced SQL for at least 2+ years

▪ Good development skills in Java, Python or other languages

▪ Experience with EMR, S3

▪ Knowledge and exposure to BI applications, e.g. Tableau, Qlikview

▪ Comfortable working in an agile environment

*Job Title:** Data Analyst

**Location:** Permanent Work from Home

**Job Type:** Full-Time

**Job Description:**

We are seeking a highly motivated and skilled Data Analyst to join our team. The ideal candidate will have a strong background in data analysis, incident management, and real-time data reporting. The role demands exceptional communication skills, both written and spoken, as well as the ability to work flexible shifts to support our global operations.

**Key Responsibilities:**

- Perform data analysis to identify trends, anomalies, and insights.

- Manage and resolve incidents effectively using tools like Jira and Slack.

- Conduct real-time data analysis and reporting to support business decisions.

- Generate comprehensive reports and dashboards to visualize data findings.

- Collaborate with cross-functional teams to ensure data integrity and accuracy.

- Communicate findings and recommendations clearly and concisely to stakeholders.

- Flexibility to work in different time zones as required.

**Required Qualifications:**

- Bachelor’s degree in Computer Science or a related field.

- Proven experience in data analysis and incident management.

- Proficiency in using Jira and Slack for communication and incident tracking.

- Strong skills in real-time data analysis and reporting.

- Exceptional communication skills in English, both written and spoken.

- Ability to work flexible shifts to accommodate global operations.

**Preferred Qualifications:**

- Experience with Python and automation tools is a plus.

**Work Environment Requirements:**

- Must have a reliable laptop/computer and home-based infrastructure, including high-speed WiFi and power backup.

- Ability to work effectively in a remote environment with minimal supervision.

**Benefits:**

- Permanent work-from-home opportunity.

- Flexible working hours.

- Opportunity to work with a dynamic and diverse team.

If you meet the above qualifications and are eager to contribute to a fast-paced and innovative team, we encourage you to apply.

Company Profile :

Merilytics, an Accordion company is a fast-growing analytics firm offering advanced a and intelligent analytical solutions to clients globally. We combine domain expertise, advanced analytics, and technology to provide robust solutions for clients' business problems. You can find further details about the company at https://merilytics.com.

We partner with our clients in Private Equity, CPG, Retail, Healthcare, Media & Entertainment, Technology, Logistics industries etc. by providing analytical solutions to generate superior returns. We solve clients' business problems by analyzing large amount of data to help guide their Operations, Marketing, Pricing, Customer Strategies, and much more.

Position :

- Business Associate at Merilytics will be working on complex analytical projects and is the primary owner of the work streams involved.

- The Business Associates are expected to lead the team of Business Analysts to deliver robust analytical solutions consistently and mentor the Analysts for professional development.

Location : Hyderabad

Roles and Responsibilities :

The roles and responsibilities of a Business Associate will include the below:

- Proactively provide thought leadership to the team and have complete control on the delivery process of the project.

- Understand the client's point of view and translate it into sound judgment calls in ambiguous analytical situations.

- Highlight potential analytical issues upfront and resolve them independently.

- Synthesizes the analysis and derives insights independently.

- Identify the crux of the client problem and leverage it to draw relevant actionable insights from the analysis/work.

- Ability to manage multiple Analysts and provide customized guidance for individual development.

- Resonate with our five core values - Client First, Excellence, Integrity, Respect and Teamwork.

Pre-requisites and skillsets required to apply for this role :

- Undergraduate degree (B.E/B.Tech.) from tier-1/tier-2 colleges are preferred.

- Should have 2-4 years of experience.

- Strong leadership & proactive communication to coordinate with the project team and other internal stakeholders.

- Ability to use business judgement and a structured approach towards solving complex problems.

- Experience in client-facing/professional services environment is a plus.

- Strong hard skills on analytics tools such as R, Python, SQL, and Excel is a plus.

Why Explore a Career at Merilytics :

- High growth environment: Semi-annual performance management and promotion cycles coupled with a strong meritocratic culture, enables fast track to leadership responsibility.

- Cross Domain Exposure: Interesting and challenging work streams across industries and domains that always keep you excited, motivated, and on your toes.

- Entrepreneurial Environment: Intellectual freedom to make decisions and own them. We expect you to spread your wings and assume larger responsibilities.

- Fun culture and peer group: Non-bureaucratic and fun working environment; Strong peer environment that will challenge you and accelerate your learning curve.

Other benefits for full time employees:

(i) Health and wellness programs that include employee health insurance covering immediate family members and parents, term life insurance for employees, free health camps for employees, discounted health services (including vision, dental) for employee and family members, free doctor's consultations, counselors, etc.

(ii) Corporate Meal card options for ease of use and tax benefits.

(iii) Work dinners, team lunches, company sponsored team outings and celebrations.

(iv) Reimbursement support for travel to the office, as and when promulgated by the Company.

(v) Cab reimbursement for women employees beyond a certain time of the day.

(vi) Robust leave policy to support work-life balance. Specially designed leave structure to support woman employees for maternity and related requests.

(vii) Reward and recognition platform to celebrate professional and personal milestones.

(viii) A positive & transparent work environment including various employee engagement and employee benefit initiatives to support personal and professional learning and development.

Role: Data Analytics Lead / Manager

1. Lead cross-functional projects using advanced data modelling and analysis techniques to discover insights that will guide strategic decisions and uncover optimization opportunities.
2. Build, develop and maintain data models, reporting systems, data automation systems, dashboards and performance metrics support that support key business decisions.
3. Coordinate with different teams to determine requirements for data warehousing, reporting and analytical solutions, and ensure customer satisfaction on deliverables
4. Oversee analytics projects to extract, manage, and analyse data from multiple applications, ensuring that deadlines are met.
5. Apply statistics and data modelling to gain actionable business insights and boost customer productivity and revenue.
6. Enforce company policies and procedures to ensure quality and prevent discrepancies.
7. Communicate and track key performance metrics across departments.
8. Keep abreast of industry best practices and policies.
9. Research Latest trends, analyse data, identify opportunities and incorporate changes into business strategies.
10. Manage and optimize processes for data intake, validation, mining and engineering as well as modelling, visualization and communication deliverables.
11. Examine, interpret and report results of analytical initiatives to stakeholders in leadership, technology, sales, marketing and product teams.
12. Oversee the data/report requests process: tracking requests submitted, prioritization, approval, etc.
13. Develop and implement MLDevOps, quality controls and departmental standards to ensure quality standards, organizational expectations, and regulatory requirements.
14. Anticipate future demands of initiatives related to people, technology, budget and business within your department and design/implement solutions to meet these needs.
15. Organize and drive successful completion of data insight initiatives through effective management of data analyst and effective collaboration with stakeholders.

Essential Skills

1. Working knowledge of data mining principles: predictive analytics, mapping, collecting data from multiple data systems on premises and cloud-based data sources.
2. Strong SQL skills, ability to perform effective querying involving multiple tables and subqueries.
3. Understanding of and experience using analytical concepts and statistical techniques: hypothesis development, designing tests/experiments, analyzing data, drawing conclusions, and developing actionable recommendations for business units.
4. Experience and knowledge of statistical modelling techniques: multiple regression, logistic regression, log-linear regression, variable selection, etc.

 We’re looking for someone with at least 10+ years of experience in a position monitoring, managing, transforming and drawing insights from data, and someone with at least 5 years of experience leading a data analyst team.

Experience in Azure is preferred