Job Summary: We are seeking a detail-oriented Data/Business Analyst to join our dynamic team. The ideal candidate will leverage their expertise in Excel, Power BI, and SQL to analyze data, generate insights, and support data-driven decision-making across the organization. This role involves collaborating with various departments to understand their data needs, develop reports, and provide actionable recommendations.
Key Responsibilities:
Data Analysis: Utilize Excel to perform complex data analysis, including data cleaning, transformation, and visualization.
Reporting: Develop and maintain interactive dashboards and reports in Power BI to communicate key metrics and trends effectively.
SQL Querying: Write and optimize SQL queries to extract and manipulate data from relational databases, ensuring data accuracy and integrity.
Stakeholder Collaboration: Work closely with business stakeholders to gather requirements, understand challenges, and provide analytical support for strategic initiatives.
Insights Generation: Analyze data to identify trends, patterns, and anomalies, presenting findings to relevant teams to support decision-making.
Documentation: Create comprehensive documentation of data processes, methodologies, and best practices to ensure knowledge sharing across the team.
Continuous Improvement: Identify opportunities for process improvement and automation to enhance data management and reporting efficiency.
Qualifications:
Bachelor's degree in Business, Data Science, Analytics, or a related field.
Proven experience as a Data Analyst or Business Analyst, preferably in a corporate environment.
Proficiency in Excel, including advanced functions, pivot tables, and data visualization techniques.
Strong experience with Power BI for data visualization and dashboard creation.
Solid understanding of SQL, with the ability to write and optimize complex queries.
Excellent analytical and problem-solving skills, with a keen attention to detail.
Strong communication skills, with the ability to convey technical information to non-technical stakeholders.
Ability to work independently and collaboratively in a fast-paced environment.
Preferred Qualifications:
Experience with additional data visualization tools (e.g., Tableau) or programming languages (e.g., Python, R) is a plus.
Knowledge of data warehousing concepts and ETL processes.
Familiarity with statistical analysis and predictive modeling techniques.