Arbetsbeskrivning
About the CompanyAvaron 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 AssignmentFor 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.
ApplicationSelections are made on an ongoing basis, so we recommend that you apply as soon as possible.