Senior CRM & BI Data Architect (Azure & Power Platform)
Architect a modern CRM-to-Azure analytics ecosystem—integrating Salesforce, HubSpot, Lime and SAP into governed Power BI reporting for end-to-end sales insights.
About the Company
Avaron AB is a growing consultancy focused on technology, finance, and business support. We match your expertise with the market's most interesting assignments, offering a platform where your professional development is central.
About the Assignment
For a global company within propulsion and powertrain technology, we are looking for a hands-on CRM Technical Specialist with strong architectural capabilities across CRM data, BI engineering, and cloud-based integration. You will own the technical design and governance of a CRM-driven reporting landscape and act as the bridge between Sales, IT, and Data Engineering to ensure reliable, secure, and scalable data flows into a modern Azure-based BI platform.
This is an engineering-focused role with architectural influence—well beyond dashboarding—where you will integrate CRM and ERP data into unified reporting structures and ensure high data quality, performance, and compliance.
Job Description
- Lead technical integrations for CRM platforms such as Salesforce, HubSpot, and Lime CRM.
- Integrate ERP data from SAP S/4HANA to enable end-to-end sales lifecycle reporting.
- Design and maintain scalable ingestion patterns from CRM systems to a data lake (batch and incremental loads).
- Define canonical data models to harmonize CRM and ERP schemas into unified reporting structures.
- Build and maintain robust API-based integrations, including monitoring and performance optimization.
- Manage authentication and access control using Azure AD and RBAC models.
- Monitor and troubleshoot pipelines, data latency, and refresh failures.
- Apply CI/CD principles in BI and data pipeline deployments.
- Own semantic models and reporting architecture in Microsoft Power BI.
- Establish data dictionaries, metadata standards, and documentation practices.
- Define and implement data quality controls and validation frameworks for CRM data.
- Drive improvements in data reliability, scalability, and overall performance.
- Ensure alignment with internal security and data privacy policies.
Requirements
- 5+ years of experience in CRM technical roles, BI engineering, or data engineering.
- Proven experience architecting CRM integrations and enterprise reporting environments.
- Strong understanding of CRM data structures (accounts, contacts, opportunities, activities, pipeline stages).
- API integration knowledge (REST, authentication flows, incremental sync logic).
- Hands-on experience with Power BI (Service, DAX, semantic modeling, RLS, deployment pipelines).
- Hands-on experience with Azure Data Lake (ADLS Gen2).
- Experience designing ETL/ELT pipelines (Azure Data Factory, Databricks, or equivalent).
- Strong SQL-based data transformation skills.
- Understanding of data governance, RBAC, Azure AD, and secure BI deployment.
- Experience with performance tuning across BI datasets and data pipelines.
- Bachelor’s or Master’s degree in Data Engineering, Computer Science, Information Systems, or a related field.
Nice to have
- Experience with scripting/automation using PowerShell, Python, or similar.
- Experience integrating multi-source CRM and ERP data into a governed analytics platform.
- Experience working in complex global environments with multiple stakeholders.
Application
Selections are made on an ongoing basis, so we recommend that you apply as soon as possible.
- Platser
- Göteborg
- Distansarbete
- Hybridarbete
Göteborg
Om Avaron AB
Avaron grundades med visionen om att skapa ett konsultbolag där kompetens och livskvalitet går hand i hand. Vi är ett nischat team som idag verkar inom komplexa miljöer såsom bank, finans och storskalig industri.
Som konsult hos oss får du det bästa av två världar: tryggheten och de spännande uppdragen hos stora, etablerade uppdragsgivare, kombinerat med det lilla bolagets snabbhet, transparens och personliga kontakt.
Vi tror inte på krångliga hierarkier eller onödig administration. Istället lägger vi kraften på det som faktiskt betyder något – att leverera värde i våra projekt och att se till att våra medarbetare trivs, utvecklas och har en balans i livet som fungerar på riktigt.