Senior Data Analytics Consultant — BI, SQL & Strategy

Forfirm; Ticino; Hybrid; CHF 120,000 - 165,000; Full time

Job summary

FORFIRM in Switzerland seeks a Senior Data Analytics Consultant to lead data-driven transformation for Swiss and European clients. You will work with stakeholders, design analytics solutions, and shape modern data architectures.

You will own SQL development, data modelling, Power BI dashboards, and mentor junior consultants, contributing to pre-sales and delivery in a dynamic international team.

Qualifications

• Bachelor's or Master's degree in CS/Engineering/Math/Stats/Data Science or related field.
• At least 5 years of professional experience in Data Analytics, BI, Data Warehousing, or related fields.
• Strong expertise in SQL development and relational databases.

Responsibilities

• Engage with business stakeholders to understand strategic objectives and analytical requirements.
• Translate business needs into scalable data and reporting solutions.
• Lead workshops, requirement-gathering sessions, and analytical assessments.
• Support clients in defining KPI frameworks and performance measurement models.
• Act as a trusted advisor for data-driven decision-making initiatives.
• Design and maintain data models (conceptual/logical/physical).
• Define dimensional models (Star/Snowflake) for reporting needs.
• Collaborate with Data Engineers and Architects on analytics architectures.
• Support data governance, MDM, and data quality initiatives.
• Ensure consistency, integrity, and sustainability of analytical data platforms.
• Develop and optimize complex SQL queries and data analysis.
• Perform data profiling and root cause investigations.
• Analyze large datasets to identify trends and opportunities.
• Support data migration and transformation initiatives.
• Design and develop dashboards/reports using Power BI.
• Develop advanced DAX calculations, KPIs, and semantic models.
• Implement reporting best practices and governance standards.
• Support executive reporting and management dashboards.
• Ensure performance optimization and scalability of reporting solutions.
• Act as senior reference in client engagements.
• Coach and mentor junior consultants and analysts.
• Define scope, timelines, and deliverables with project managers.
• Contribute to proposals and business development.

Skills

SQL development

Data analytics

Power BI

Stakeholder management

Data modeling

Education

Bachelor's or Master's Degree in Computer Science, Engineering, Mathematics, Statistics, Economics, Data Science, or related discipline

Tools

Power BI

DAX

Job description

FORFIRM in Switzerland seeks a Senior Data Analytics Consultant to lead data-driven transformation for Swiss and European clients. You will work with stakeholders, design analytics solutions, and shape modern data architectures.

You will own SQL development, data modelling, Power BI dashboards, and mentor junior consultants, contributing to pre-sales and delivery in a dynamic international team.