Power BI Consultant / BI Developer

Founded in Marseille in 1959, the CMR Group specializes in energy management: from assembling complex wiring harnesses for engines to designing sensors for nuclear power plants and installing energy control systems on ships.
CMR now has more than 1,000 employees in 10 countries and continues its growth, notably by joining the American group Amphenol in 2023, a leader in connectors.
Our clients share a common major concern: to sustainably reduce their carbon footprint. We support them with innovative solutions to optimize their energy usage.

As part of the continued development of our ERP, BI & Development team, we are looking for a motivated 'Power BI Consultant / BI Developer' to contribute to the development, optimization, and maintenance of our Business Intelligence solutions.

Your main responsibilities

-Gather and analyze business users’ requirements.
-Translate functional requirements into relevant and reliable BI solutions.
-Design, develop, and maintain Power BI reports and dashboards.
-Build and optimize data models.
-Develop metrics and KPIs using DAX.
-Perform data preparation and transformation using Power Query / M.
-Work with data from SQL Server and develop the required SQL queries.
-Optimize the performance of reports, data models, queries, and refresh processes.
-Administer and support Power BI Service environments, including workspaces, datasets, gateways, refreshes, and access rights.
-Ensure the quality, consistency, and reliability of reported data.
-Contribute to BI governance best practices and reporting standardization.
-Analyze and resolve issues related to reports and data.
-Participate in meetings and workshops with business teams.
-Document developed solutions.
-Work closely with ERP, IT, and business teams.
-Technical skills required
-Business Intelligence & Data Visualization
-Strong command of Microsoft Power BI Desktop and Power BI Service.
-Proficiency in DAX.
-Proficiency in Power Query / M.
-Experience in creating and optimizing dashboards, reports, and KPIs.
-Experience in designing and optimizing Power BI data models.
-Ability to manage Power BI datasets, gateways, refreshes, and workspaces.

Data Warehouse & ETL

-Good knowledge of Microsoft SQL Server Integration Services (SSIS).
-Experience in designing, developing, and maintaining ETL processes.
-Experience in designing and working with Data Warehouses and Data Marts.
-Good understanding of dimensional modeling principles.
-Experience in managing data quality, historical data, and data consistency.
-Ability to analyze and optimize ETL performance.

SQL Server

-Strong command of SQL / T-SQL.
-Experience in developing and optimizing complex queries.
-Experience in creating and maintaining views and stored procedures.
-Ability to analyze and optimize SQL performance.
-Ability to work with large volumes of data.
-Nice-to-have skills
-Knowledge of an ERP environment, ideally Microsoft Dynamics AX.

Data Warehouse / Data Mart.

-Microsoft Fabric.
-Azure Data Factory and/or Azure Data Services.
-Power Platform.
-Azure DevOps / Git.

Candidate profile

-Master’s degree, engineering degree, or equivalent in Computer Science, Business Intelligence, Data, or a related field.
-At least 1 to 3 years of relevant experience in Power BI / Business Intelligence.
-Strong analytical and problem-solving skills.
-Ability to understand business processes and translate them into effective BI solutions.
-Ability to work independently, with attention to detail and strong organizational skills.
-Good communication skills.
-Comfortable participating in and progressively leading meetings and workshops with business users.
-Ability to work in an international environment and collaborate with multidisciplinary teams.
-Proficiency in French and English is appreciated.

What we offer

-An attractive salary package based on the candidate’s profile and experience.
-A dynamic working environment where initiative and individual contributions are valued.
-A role with significant responsibilities at the heart of our logistics and export operations.
-The opportunity to take ownership of your success, with the support needed for your professional development.
-A pleasant working environment within engaged and collaborative teams in an international company.

Contact us