Business Intelligence Analyst / BI Analyst / Reporting Specialist

Business Intelligence Analyst / BI Analyst / Reporting SpecialistRole Description We are seeking an analytical, data-driven, and detail-oriented Business Intelligence Analyst / BI Analyst / Reporting Specialist to translate complex data into actionable business insights and build scalable reporting solutions. In this mid-level analytical role, you will report directly to the Data & Analytics Lead or Head of Business Intelligence and work closely with Finance, Operations, Marketing, and Senior Leadership teams. You will be responsible for designing, developing, and maintaining enterprise dashboards, establishing automated reporting pipelines, and performing ad-hoc analytical deep-dives to uncover operational efficiencies and growth opportunities. Responsibilities include querying complex relational databases, performing data hygiene and ETL (Extract, Transform, Load) operations, defining standard KPIs across business units, and delivering visual analytics that drive strategic decision-making. Success in this position requires advanced SQL capability, mastery of modern BI visualization platforms, strong statistical and spreadsheet modeling skills, and the ability to articulate technical data stories to non-technical stakeholders clearly.QualificationsEducation: Bachelor's degree in Business Analytics, Data Science, Statistics, Computer Science, Information Systems, Finance, or a related quantitative discipline.BI & Data Visualization: 2–4 years of hands-on experience designing and deploying interactive enterprise dashboards and reports using tools such as Power BI, Tableau, Looker, or Qlik.SQL & Database Management: Advanced proficiency in SQL for data extraction, joining complex datasets, writing optimized subqueries, CTEs, and managing stored procedures across relational databases (e.g., PostgreSQL, MySQL, BigQuery, Snowflake, or MS SQL Server).Data Modeling & ETL: Practical experience with data modeling concepts (Star Schema, Snowflake Schema), data warehousing principles, and data transformation frameworks (e.g., dbt, Power Query, or Alteryx).Spreadsheet & Statistical Analytics: Advanced skill in Microsoft Excel / Google Sheets (dynamic array formulas, Pivot Tables, power pivot) alongside basic Python or R capabilities for data manipulation and statistical analysis (e.g., pandas, NumPy).Metric Definition & Governance: Proven ability to collaborate with functional leads to define key performance indicators (KPIs), establish single-source-of-truth data definitions, and enforce data hygiene standards.Ad-Hoc Analysis & Storytelling: Strong analytical thinking to conduct exploratory data analysis, root-cause analyses, and cohort tracking, converting raw outputs into executive summaries and slide presentations.Business Acumen & Stakeholder Alignment: Deep understanding of commercial and operational metrics across departments (e.g., CAC, LTV, Churn, Margin Analysis, Inventory Turnover) with the ability to gather business requirements effectively.Communication Skills: Excellent verbal and written communication skills to bridge technical data engineering teams and executive-level business decision-makers.Professional Attributes: High intellectual curiosity, meticulous attention to detail, strong problem-solving initiative, and a commitment to data integrity and security.