Power BI - developer

Power BI Consultant Role

emagine are seeking a Power BI Integration Consultant for an project on a 3-month contract (with potential 1-month extension). This consultant will lead a complex data integration initiative, ensuring our systems function as a cohesive unit and data flows without obstruction to support business operations. The role involves integrating data sources into Salesforce and our BI platform, developing a new data model, migrating legacy data, and enhancing reports.

Start: ASAP

Location: Stockholm

Responsibilities:

• Lead New Case Dataset Development: Combine data from Salesforce and SharePoint to design and build a new “Case” dataset. This includes defining a new data model that unifies case information from both sources. This is the consultant’s main responsibility ensuring the dataset supports reporting needs.
• 
  Migrate Historical Case Data: Design a process to handle historical case data from the SalesForce. Extract and transform legacy case records from the Salesforce backend and migrate them into Azure SQL DB in line with the new data model. Ensure the historical data is properly integrated (e.g. mapping old fields to new schema) and validated for consistency with current data.
• 
  Incorporate Call Data into BI Reports: Take newly available Salesforce call center data (call logs/metrics) and integrate it into our Power BI reporting. This involves updating or creating data pipelines so that call data flows into the BI database and is reflected on relevant dashboards and reports.
• 
  Integrate New Investigation Data from Salesforce: Load and map incoming investigation data from Salesforce, aligned to the new Salesforce data model. Ensure new fields/objects are created or configured as needed and that data ingestion is smooth and error-free.

We are looking for someone with skills in

• Power BI Integration: Strong experience with Power BI – able to ensure data from Azure SQL can be effectively consumed in Power BI, understanding of Power BI data models and refresh processes.
• Salesforce Data: Strong experience with Salesforce objects, fields (ability to understand and extend Salesforce’s data schema, and extract data).
• 
  SQL & Azure SQL Database: Expertise in SQL querying and database management on Azure SQL. Ability to design relational tables and optimize for integration and retrieval performance.
• 
  API Integration (Python): Proficient in Python for calling REST APIs and processing JSON/XML data. Experience building data pipelines or ETL scripts in Python to move data between systems.
• 
  SharePoint Data Access: Knowledge of retrieving data from SharePoint to incorporate SharePoint list/document data into the Power BI report
• 
  Data Modeling & ETL Design: Ability to design data models that integrate multiple sources and to build ETL pipelines (extract-transform-load) that are reliable. Should handle data mapping, transformation, and quality checks.