Job Overview:
We are seeking a talented and experienced BI Analyst to join our dynamic e-commerce company. As a BI Analyst, you will play a vital role in analyzing and interpreting data to provide actionable insights that drive business growth and improve decision-making processes. Your primary focus will be on commerce-related models, data visualization using tools such as Microsoft Power BI, and a basic understanding of SSIS. Familiarity with Tableau and Metabase is considered a plus.
Key Responsibilities:
- Collaborate with cross-functional teams to identify business requirements and define key performance indicators (KPIs) for ecommerce analytics.
- Develop and maintain retail and ecommerce-related models, ensuring accuracy, reliability and scalability of data and reporting.
- Perform in-depth data analysis to identify trends, patterns, and opportunities for optimization and growth in ecommerce operations.
- Create intuitive and visually appealing reports, dashboards, and visualizations using Microsoft Power BI, ensuring data is presented in a meaningful and actionable format.
- Collaborate with stakeholders to understand their reporting needs and deliver accurate and timely insights.
- Monitor key metrics and proactively provide analysis and recommendations to enhance ecommerce performance.
- Identify and implement process improvements to streamline data collection, analysis, and reporting procedures.
- Collaborate with the engineering team to understand data structures and ensure data integrity and consistency.
- Assist in data extraction, transformation, and loading (ETL) processes using SSIS and other relevant tools.
- Stay up-to-date with industry trends, best practices, and emerging technologies in the field of ecommerce analytics.
Requirements:
- Bachelors degree in computer science, Mathematics, Statistics, Economics, or a related field.
- Proven experience as a BI Analyst or similar role, preferably in an ecommerce or online retail environment.
- Strong expertise in commerce-related models and concepts such as customer lifetime value, customer segmentation, funnel analysis, A/B testing, and cohort analysis.
- Proficient in data visualization tools, particularly Microsoft Power BI. Experience with Tableau and Metabase is a plus.
- Good understanding of SSIS (SQL Server Integration Services) for data extraction,
- transformation, and loading.
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- Familiarity with SQL for data querying and manipulation.
- Knowledge of statistical analysis techniques and experience with statistical software (e.g., R, Python) is beneficial.
- Excellent communication and presentation skills, with the ability to translate complex data into clear and actionable insights for non-technical stakeholders.
- Strong problem-solving skills and the ability to think critically to identify trends, patterns, and opportunities in data.
- Proactive and self-motivated, with the ability to work independently as well as part of a team.
If you are passionate about ecommerce, data analysis, and driving business growth through insights, we would love to hear from you