The Role
Design, build, and optimize SQL-based data transformations, relational data models, and ETL pipelines to support BI reporting. Collaborate with BI developers and stakeholders to translate requirements, ensure data quality, troubleshoot ETL failures, and document models and business logic for governance and reuse.
Summary Generated by Built In
The BI Consultant is responsible for designing, building, and maintaining robust data models and transformation logic that power reliable business intelligence and reporting. The role focuses on SQL‑based data transformation, relational modeling, and ETL processes to ensure high data quality, consistent business logic, and scalable analytics solutions. Working closely with BI developers and business stakeholders, this position translates business requirements into well‑structured, performant data models that support reporting and decision‑making.
Responsibilities
- 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
Skills, Knowledge & Expertise
Core Technical Skills:
- 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
BI & Analytics Knowledge:
- 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
Ways of Working:
- 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
Nice to Have:
- Experience with modern BI platforms and data warehousing environments
- Familiarity with ERP or enterprise data domains (finance, sales, supply chain, operations)
- Exposure to data governance, naming standards, and best‑practice BI architecture
About
Forterro is a federation of ERP software and services companies serving small to mid market companies around the globe, with offices in UK, Germany, Sweden, Switzerland, France, Poland, Bulgaria, India, Morocco and USA. At Forterro, we invest in and help to fortify both local and niche ERP software businesses.Our product line businesses are local, not localized and vertical, not verticalized.
Skills Required
- Strong SQL expertise with performance tuning and scalable query design
- Experience with relational data modeling (facts, dimensions, star/snowflake schemas)
- Experience designing and maintaining ETL processes and pipelines
- 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
- Strong collaboration skills with technical and non-technical stakeholders
- Structured, detail-oriented approach to documentation, data quality, and maintainability
- Experience with modern BI platforms and data warehousing environments
- Familiarity with ERP or enterprise data domains (finance, sales, supply chain, operations)
- Exposure to data governance, naming standards, and BI architecture best practices
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Founded in 2012, Forterro has grown to become a category leader software solutions for the industrial market – with strongholds in Europe’s top production economies, as well as regional service hubs and development centres around the world. From more than 40 office locations, our 1,600+ employees provide and support software for more than 13,000 industrial businesses. Our products are deeply rooted in the demands of their local geography. And each is designed to strengthen and accelerate our customers’ ability to operate efficiently and compete effectively.
.jpeg){kind=icon}
