Software Engineer

Forterro

BI Consultant designing and maintaining SQL data models and ETL processes for business intelligence. Collaborating with stakeholders to ensure high data quality and scalable analytics solutions.

Posted 5/19/2026full-timeCasablanca • 🇲🇦 MoroccoMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ERPETLSQL

About the role

Key responsibilities & impact

Write, maintain, and continuously optimize SQL‑based code for data transformation and reporting
Refactor and improve existing SQL logic to enhance performance, readability, and scalability
Design, build, and maintain relational data models to support BI and analytics use cases
Construct and manage dimensions, measures, and calculated fields within relational models
Ensure consistency, accuracy, and reuse of business logic across datasets, models, and reports
Collaborate with BI developers and business stakeholders to translate requirements into data structures and calculations
Develop, maintain, and enhance ETL processes for ingesting and transforming data from multiple sources
Monitor, troubleshoot, and resolve ETL job failures or performance issues
Validate and test data pipelines and models to ensure high data quality and integrity
Document data models, transformations, and definitions to support transparency, governance, and reuse

Requirements

What you’ll need

Strong SQL expertise with a focus on performance tuning and scalable query design
Solid experience with relational data modeling (facts, dimensions, star/snowflake schemas)
Experience designing and maintaining ETL processes
Ability to define and implement consistent business logic in data models
Strong data validation, testing, and troubleshooting skills
Understanding of business intelligence concepts, KPIs, and analytical use cases
Experience supporting reporting and analytics tools through well‑structured data models
Ability to bridge business requirements and technical implementation
Strong collaboration skills and ability to work with both technical and non‑technical stakeholders
Structured and detail‑oriented approach to data quality, documentation, and maintainability
Problem‑solving mindset with a focus on continuous improvement
Experience with modern BI platforms and data warehousing environments (nice to have)
Familiarity with ERP or enterprise data domains (finance, sales, supply chain, operations) (nice to have)
Exposure to data governance, naming standards, and best‑practice BI architecture (nice to have)

Benefits

Comp & perks

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETL processesrelational data modelingdata validationdata testingtroubleshootingdata transformationdata pipelinesperformance tuningscalable query design

Soft Skills

collaborationproblem-solvingdetail-orientedstructured approachcommunicationability to bridge business and technical requirementscontinuous improvementtransparencygovernancereuse