Droom - Associate Director - Decision Science

Skills Required :

1. Advanced MySQL

2. Advanced Excel

3. R

4. PowerBI

5. Projections

6. Cohort Analysis

7. Data Warehousing

8. Web Analytics

9. CRM & Marketing Analytics

Responsibilities :

1. Data Analysis and Reporting: Collect, analyze, and interpret data from various sources to support business decision-making. Develop detailed reports, dashboards, and visualizations to provide actionable insights to stakeholders.

2. Advanced Excel Modeling: Utilize advanced Excel skills, including formulas, pivot tables, VLOOKUP, macros, and data analysis tools, to perform complex data analysis and build financial models.

3. Presentation Development: Create professional PowerPoint presentations that effectively communicate data insights, trends, and recommendations to senior management and other stakeholders.

4. Market Research: Conduct market research and competitor analysis to identify trends, opportunities, and potential areas for improvement within Droom's business operations.

5. Process Improvement: Analyze current business processes and identify areas for improvement. Propose and implement solutions that increase efficiency and reduce costs.

6. Stakeholder Collaboration: Work closely with cross-functional teams, including product, sales, marketing, and operations, to understand business needs and provide data-driven recommendations.

7. Data Management: Maintain and manage data accuracy within Google Spreadsheets and other data management tools, ensuring up-to-date information is readily accessible for analysis.

8. KPI Tracking: Monitor key performance indicators (KPIs) to track business performance and support the strategic planning process.

9. Ad Hoc Analysis: Conduct ad hoc data analysis as required to support various business initiatives, providing timely and accurate insights to support decision-making.

10. Documentation and Reporting: Prepare clear and concise documentation of analysis methodologies, findings, and recommendations for use by internal teams and external stakeholders.

Requirements :

1. Educational Background: Bachelor's degree in Business Administration, Finance, Economics, Data Science, or a related field.

2. Experience: 1-3 years of experience as a Business Analyst or in a similar analytical role, preferably within a tech or SaaS environment.

3. Technical Skills: Proficiency in MS Excel (advanced level), Google Sheets, and data visualization techniques. Familiarity with data analysis tools like Tableau or Power BI is a plus.

4. Presentation Skills: Strong proficiency in Microsoft PowerPoint, with the ability to create impactful presentations from data.

5. Analytical Mindset: Strong analytical and problem-solving skills with a keen attention to detail and the ability to interpret complex data sets.

6. Communication Skills: Excellent verbal and written communication skills, with the ability to present data insights clearly to non-technical audiences.

7. Organizational Skills: Ability to manage multiple projects simultaneously, prioritize tasks, and meet deadlines in a fast-paced environment.

8. Team Collaboration: Strong collaboration skills with the ability to work effectively in cross-functional teams.

9. Adaptability: A proactive and flexible approach, with a willingness to learn and adapt to new challenges.

10. Attention to Detail: High level of accuracy and attention to detail in all aspects of work, including data analysis and reporting.