Business Intelligence Assistant

Mavi; Fatih; On-site; TRY 180,000 - 240,000; Full time

Job summary

Mavi, a leading global lifestyle brand headquartered in Istanbul, is seeking a Business Intelligence Assistant to join the Global Information Technology team. The role focuses on designing ETL/ELT pipelines, building data structures, and delivering robust Power BI solutions to monitor retail performance.

Ideal candidates hold a Bachelor’s degree in a related field and have 1–2 years BI experience, strong SQL skills, and fluency in English.

Qualifications

• Bachelor’s degree in a relevant field.
• 1–2 years of BI experience in a fast-paced environment.
• Strong understanding of data architectures (Lakehouse, Data Warehouse, Semantic Models).
• Excellent English and MS Office skills.

Responsibilities

• Design and develop ETL/ELT pipelines using Python and SQL.
• Build and maintain Lakehouse and Data Warehouse structures.
• Create analytical and semantic models to support decision-making.
• Develop and optimize Power BI datasets, reports, and dashboards.
• Plan and execute BI studies to monitor retail performance.
• Ensure data quality, consistency, and reliability across pipelines.
• Troubleshoot data and pipeline issues with IT and business teams.
• Translate business requirements into scalable data solutions.

Skills

SQL

ETL / ELT Development

Microsoft Fabric

Power BI & DAX

Data Warehousing

Data Modeling

BI Delivery

Analytical Thinking

Education

Bachelor’s degree (Computer/Industrial/ MIS or related)

Tools

Microsoft Fabric

Power BI

SQL

Job description

Are you ready to be a part of this journey?

Mavi, incorporated in 1991 in Istanbul, is recognized as a highly successful global lifestyle brand, rooted in 34 years of denim expertise. Mavi has been publicly traded since 2017 and has a presence in 34 countries, including Turkiye, the USA, Canada, Germany, and Russia, selling its products through approximately ~4,000 points, including 498 Mavi shops.

Mavi’s trusted brand image translates into high quality and strong pricing power with products positioned between the upper end of the core and the premium segments of the ready-to-wear market. Perfect Fit philosophy guides Mavi in designing jeans that perfectly fit its customers’ lifestyles, body types, and quality expectations. Mavi ranks among the world’s leading premium denim brands and stands apart as the preferred lifestyle brand across female and male consumer segments.

Here’s what you need to know:

We are looking for an "Business Intelligence Assistant" who will work under the in our Global Information Technologydepartment, within Project team.

What will be expected of you in this role?

• Designing and developing ETL / ELT pilelinse using Python and SQL on Microsoft Fabric
• Building and maintaining Lakehouse and Data Warehouse structures
• Creating analytical and semantic models to support business decision-making
• Developing and optimizing Power BI datasets, reports, and dashboards
• Planning and executing BI studies to monitor retail business performance
• Ensuring data quality, consistency, and reliability across data pipelines
• Troubleshooting data and pipeline issues in collaboration with IT and business teams
• Translating business requirements into scalable data and analytics solutions.

Why you?

• Bachelor’s degree in Computer Engineering, Industrial Engineering, Management Information Systems, or related fields
• Minimum 1–2 years of experience in Business Intelligence within a fast-paced environment
• Strong understanding of modern data & analytics architectures (Lakehouse, Data Warehouse, Semantic Models)
• Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Factory / Pipelines, Notebooks)
• Strong knowledge of SQL and ability to write complex analytical queries (T-SQL / Spark SQL)
• Hands-on experience developing ETL / ELT processes using Python and SQL
• Experience with Python-based data transformation (Fabric Notebooks, PySpark)
• Solid knowledge of data modeling concepts (relational & dimensional modeling, star schema)
• Experience with Power BI (semantic models, DAX, reports, dashboards, performance optimization)
• Strong analytical thinking and problem-solving skills
• Team player with strong interpersonal and communication skills
• Ability to work under strict deadlines and manage multiple priorities
• Excellent command of written and spoken English
• Excellent knowledge of MS Office applications.

Required Skills:

• SQL (T-SQL, Spark SQL)
• ETL / ELT Development
• Microsoft Fabric (Lakehouse, Data Factory, Notebooks, Semantic Models)
• Power BI & DAX
• Data Warehousing & Lakehouse Architecture
• Relational & Dimensional Data Modeling
• Business Intelligence Application Delivery

You might be the team member we are looking for!

We can’t wait to meet unique, creative thinking, productive and innovative candidates, who match Mavi’s brand spirit and closely follow fashion and global trends.

*Driven by our “All Blue. All Better. For All.” strategy and empowered by our people-centric Mavi culture, we create a work environment where human rights are respected and diversity and differences are embraced. We promote gender equality and commit to equal opportunity in all our recruitment processes. In line with our Diversity and Inclusion Policy, we select and recruit employees based on their professional competencies and qualifications, regardless of their age, gender, sexual orientation, race, skin color, language, religious belief, spiritual and political ideology, ethnicity, economic status and health condition, disability, physical appearance, lifestyle and what they wear and support them in unlocking their potential.