Lead Assistant Manager

Job Description

Business Intelligence Analyst (Minimum Three years of total experience): We are seeking an experienced and highly skilled Business Intelligence Analyst who is passionate about transforming innovative ideas into effective, data-driven solutions. In this role, you will be responsible for designing and delivering business intelligence solutions, which include ETL (Extract, Transform, Load) processes, data visualization, and data analysis. You will collaborate with cross-functional teams, including IT, Finance, and business stakeholders, to understand their requirements, design scalable and efficient solutions, and ensure the availability of insightful visualizations and reports. Your expertise will play a crucial role in driving data-driven decision-making and empowering the organization with actionable insights. Success in this role will require creativity and the ability to work independently to analyze sales data and create business intelligence dashboards. This position entails complete end-to-end project ownership, which includes conducting discovery meetings with stakeholders, leveraging existing SQL queries, building new SQL queries, creating ETL processes using AWS Glue and Lambda, working with AWS Redshift, developing automation workflows, and utilizing data visualization tools such as AWS QuickSight and Power BI. Key Responsibilities: Visualization and Reporting : Design and develop interactive dashboards, reports, and visualizations that provide actionable insights to business stakeholders using industry-leading tools and technologies. Data Analysis : Analyze data, identify insights, and collaborate with sales leaders to recommend business actions. Solution Design : Work closely with business stakeholders to understand their requirements and translate them into comprehensive and scalable business intelligence solutions. Data Asset Creation : Leverage internal data warehouses and external datasets to build new data assets for analysis and visualization. ETL Development : Design and implement ETL processes to extract, transform, and load data, focusing on automation, accuracy, and reusability. Collaboration and Stakeholder Management : Collaborate with cross-functional teams, including data analysts and sales leaders, to understand requirements, gather feedback, and ensure the successful delivery of solutions. Documentation and Training : Create comprehensive documentation of BI solutions (including ETL processes and visualizations) and provide training and support to users and stakeholders on the effective use of business intelligence dashboards and analytics. We recognize that skills and competencies can manifest in various ways and may stem from diverse life experiences. If you do not meet all the listed requirements, we still encourage you to apply for the position. Qualifications: The ideal candidate will have: Excellent problem-solving and analytical skills, with the ability to apply knowledge and creativity to resolve complex issues. Strong thought leadership and a quick understanding of how data and insights can be transformed into valuable features. Experience with: Data Visualization Tools: AWS QuickSight (experience with Power BI or similar tools is also acceptable). ETL Tools: AWS Glue and AWS Lambda. Databases: SQL programming (experience with PostgreSQL and AWS Redshift). Exceptional project management skills, with the ability to organize and prioritize multiple tasks effectively. Strong interpersonal skills and the ability to collaborate with partners from various business units and levels within the organization. 3-5 years of experience in business intelligence, analytics, or related roles. Minimum 2 Year of hand-on experience on AWS Glue, Lambda, RDS, RedShift, S3 A BS or MS degree in Engineering, Data & Analytics, Information Systems, or a related field (a master's degree is a plus).