Business Intelligence Consultant - Internship

**Join the Innovation Journey with BIP Consulting!** At BIP Consulting, we don’t just adapt to change—we drive it. For over 20 years, we’ve partnered with global businesses to transform challenges into growth opportunities through cutting-edge strategies and advanced technology solutions. Our growing team of 5,000+ consultants spans 14 countries, fostering a culture of creativity, collaboration, and entrepreneurial spirit. Whether pioneering AI-driven solutions, optimizing data analytics, or shaping the future of tech, we empower professionals to innovate and lead. **Now, we’re excited to explore new horizons in Albania, creating opportunities for talented individuals passionate about shaping the digital landscape.** Joining BIP means being part of a fast-paced, supportive environment where your ideas matter, and your career can soar. **About the Role** We are looking for a motivated **Business Intelligence Specialist (Intern)** to support our data & analytics initiatives. You will help transform raw data into actionable insights by building dashboards, running analyses, and supporting data quality and reporting processes. This is a hands-on internship with mentorship, training, and exposure to end-to-end BI delivery. **What You’ll Do** - Support the design and development of **interactive dashboards** and **reports** (e.g., Power BI / Tableau / Looker). - Gather and refine business requirements, translating them into clear **metrics, KPIs, and data models** . - Query and analyze data using **SQL** ; assist in data preparation with **Power Query / ETL** tools. - Perform **data validation and quality checks** , documenting assumptions and findings. - Contribute to **ad-hoc analyses** (market, product, customer, operations) and present insights to stakeholders. - Maintain and iterate on existing **BI assets** , ensuring accuracy, performance, and usability. - Collaborate with data engineers and analysts on **data pipelines** and **source-to-report** flows. - Create **clear documentation** (datasets, dashboards, definitions, processes). **What You’ll Learn** - BI best practices: **data modeling (star/snowflake)** , **semantic layers** , **governance** , and **visual design** . - How to turn business questions into measurable **metrics and KPIs** . - Fundamentals of **ETL/ELT** , data quality, and data lifecycle. - Presenting insights effectively to **non-technical stakeholders** . **Qualifications** **Must-Have** - Currently enrolled in a **Bachelor’s or Master’s** program in STEM, Business Analytics, Economics, Statistics, or related fields. - Solid knowledge of **Excel** and basic **SQL** (SELECT, JOIN, GROUP BY). - Strong analytical thinking, curiosity, and attention to detail. - Good communication skills in **English** and **Italian** (written and spoken). - Ability to manage time, prioritize tasks, and meet deadlines. **Nice-to-Have** - Experience with **Power BI** (or Tableau/Looker): DAX basics, Power Query, data relationships. - Exposure to **Python** or **R** for data analysis (e.g., pandas, numpy). - Understanding of **data visualization principles** and dashboard UX. - Familiarity with **cloud data platforms** (Azure, GCP, or AWS) and/or **version control** (Git). - Knowledge of **statistics** (descriptive stats, A/B testing concepts) is a plus. **Tools & Stack (Preferred)** - **BI:** Power BI (DAX, Power Query) / Tableau / Looker - **Data:** SQL (SQL Server / PostgreSQL / BigQuery / Snowflake), Excel - **Scripting (optional):** Python (pandas), R - **Cloud (optional):** Azure (Synapse, Data Lake), AWS, or GCP - **Collaboration:** Azure DevOps / Jira / Confluence / Git **What We Offer** - **Mentorship** from experienced data professionals and a structured onboarding plan. - Access to **training resources** (courses, certifications, internal workshops). - Real impact on business initiatives with **portfolio-worthy projects** . - A collaborative environment that values **learning, feedback, and growth** . - Possibility of **extension or conversion** to a junior role based on performance. Burimi: https://al.linkedin.com/jobs/view/business-intelligence-consultant-internship-at-bip-4369483473

Niveli: mid level