Data Consultant - Business Intelligence

Description

Job Summary: We are seeking an experienced professional to create interactive reports, automated workflows, and data analyses to optimize decision-making for our clients. Key Highlights: 1. Optimizing decision-making with BI and automation 2. Developing advanced analytical solutions with AI 3. Working on environmental and sustainability projects **Job Description** The Data Management, Analysis, and Visualization team supports projects with Business Intelligence and automation solutions to deliver dashboards, reports, and intelligent workflows that optimize our clients' decision-making. We seek a professional experienced in creating interactive reports, automated workflows, and data analyses using tools such as Microsoft Power BI, Power Automate, and Fabric. Future development opportunities include applying artificial intelligence to data, integrating diverse data sources, building pipelines in Fabric, and developing more advanced analytical solutions. **Responsibilities:** * Create new ETLs (Extract, Transform and Load) to support dashboard development projects; * Support existing ETLs (Extract, Transform and Load) and dashboards, assisting project teams in resolving specific issues, driving continuous improvement, and adding new functionalities; * Build new dashboards for projects covering various topics related to environment, sustainability, and risk management—such as Contaminated Site Management, Environmental Licensing, Mergers and Acquisitions, and Due Diligence; * Publish dashboards on our Microsoft Power BI Online infrastructure; * Create process automations using Microsoft Power Automate, integrating systems and optimizing workflows; * Develop BI solutions using Microsoft Fabric capabilities—including pipelines, notebooks, dataflows, and lakehouses—for data integration and orchestration; * Apply Artificial Intelligence capabilities in BI solutions, using predictive models, automated data analysis, and insight generation to support decision-making. **Technical Skills:** * Intermediate knowledge of Microsoft Power BI: experience developing interactive dashboards and reports, with focus on user experience; * Basic/intermediate knowledge of data modeling and commonly used DAX functions (CALCULATE, FILTER, variable declarations, SUMMARIZE, CALCULATETABLE), M language (logical IFs, date operations, appending and merging tables), and API queries; * Proficiency in Microsoft Office (especially Excel — intermediate/advanced): pivot tables, chart creation, database modeling and structuring; * Intermediate English; * Experience in environmental consulting. **Behavioral Skills:** * Agile, dynamic, independent, and curious when solving complex problems; * Organizational and communication skills; * Systems thinking and commitment to continuous improvement; * Focus on user experience and full dedication to the client; * Ability to switch between projects covering different topics; * Staying continuously updated on software updates and new tools in the Data Science and BI market; * Familiarity with online communities to find solutions for developing the tools used. **Desirable but not mandatory:** * Programming knowledge in R and Python; * Familiarity with Microsoft Power Automate platform; * Experience using Microsoft Fabric features and tools; * Use of Artificial Intelligence features applied to BI and automated analysis. **Relevant differentiators:** * Knowledge of SQL and database structuring with Azure and/or other platforms; * Familiarity with ESRI tools; * Experience with environmental data management software—EQuIS. **Education and experience preferred:** * Bachelor’s degree in Environmental Engineering, Environmental Management, Chemistry, Chemical Engineering, or related fields; * Minimum 2 years of experience. Candidates may be invited to complete an online assessment as part of our recruitment process. All personal information will be handled confidentially and in compliance with data protection laws.