Lead Data Engineer
Avaron AB1 dag kvar
Sammanfattning
Avaron is seeking a Senior Data Engineer to lead a modernization initiative for a BI and data warehouse project, transitioning from a legacy Microsoft environment to a cloud-based platform. This role involves both discovery and hands-on implementation, focusing on analyzing and reshaping data flows, ETL processes, and dependencies. The position offers the chance to influence the project's direction from the outset and requires collaboration with various stakeholders. This is a permanent positionJobbet i korthet
Anställningstyp
tillsvidareanstallning
Arbetstid
heltid
Förmåner
Permanent employment at Avaron ABOccupational pensionWellness allowance of SEK 5,000 per year
Ansök senast: 2026-07-30
Publicerad: 2026-07-28
Beskrivning
About the Company
At Avaron, you get the security of permanent employment combined with the variety of working at different customers. We place specialists across everything from tech, IT and industry to project management and business support - and whatever the assignment, you have a consultant manager who is there for you and your development.
About the Role
You will step into a key role in a BI and data warehouse modernization initiative where a legacy Microsoft environment is being analyzed, reshaped and moved toward a modern cloud-based data platform. This is an early-phase assignment where you get to combine discovery work with hands-on delivery, helping define how existing data flows, dependencies and models should evolve.
The environment is complex and calls for someone who understands more than implementation alone. You need to be comfortable looking at traditional DWH and BI solutions in depth, identifying how ETL flows, stored procedures, views, tables and integrations fit together, and turning that understanding into a practical modernization path. What makes this role especially interesting is the opportunity to influence both direction and implementation from the very start.
Job DescriptionYou will take a leading role in the early stages of the modernization and help shape the technical path forward.
You will analyze legacy SQL Server and SSIS-based data warehouse flows, including ETL, stored procedures, views, tables and dependencies.
You will contribute to discovery and analysis work as well as hands-on implementation.
You will help modernize existing data flows toward platforms such as Microsoft Fabric, Azure Synapse, Databricks or Snowflake.
You will work with data modeling and help apply concepts such as Kimball, Data Vault, star schema and data marts in a practical way.
You will document technical solutions, mappings, data flows and key design decisions in a structured manner.
You will work closely with architects, BI developers, business experts and other data engineers.
You will support and guide more junior data engineers in the team.
RequirementsExperience working as a Senior Data Engineer.
Very strong SQL skills, especially in SQL Server and T-SQL.
Documented experience with SSIS and traditional Microsoft DWH and BI environments.
Experience analyzing ETL flows, stored procedures, views, tables and dependencies.
Experience of modernization or migration from a legacy DWH to a cloud-based data platform.
Experience with at least one of the following: Microsoft Fabric, Azure Synapse, Databricks or Snowflake.
Good understanding of Kimball, Data Vault, star schema and data marts.
Experience with CI/CD, Git and structured development flows.
Ability to document technical solutions, data flows, mappings and design decisions.
Ability to collaborate closely with architects, BI developers, business experts and other data engineers.
Ability to contribute in both analysis and discovery work as well as hands-on implementation.
Ability to lead more junior data engineers.
Nice to haveExperience with dbt.
Experience with SSAS, SSRS or Power BI.
Experience with Purview, Unity Catalog or DataHub.
Experience from retail, supply chain, finance, HR or similar domains.
What We OfferPermanent employment at Avaron AB
Occupational pension
Wellness allowance of SEK 5,000 per year
Application
Selections are made on an ongoing basis - apply as soon as you can.
At Avaron, you get the security of permanent employment combined with the variety of working at different customers. We place specialists across everything from tech, IT and industry to project management and business support - and whatever the assignment, you have a consultant manager who is there for you and your development.
About the Role
You will step into a key role in a BI and data warehouse modernization initiative where a legacy Microsoft environment is being analyzed, reshaped and moved toward a modern cloud-based data platform. This is an early-phase assignment where you get to combine discovery work with hands-on delivery, helping define how existing data flows, dependencies and models should evolve.
The environment is complex and calls for someone who understands more than implementation alone. You need to be comfortable looking at traditional DWH and BI solutions in depth, identifying how ETL flows, stored procedures, views, tables and integrations fit together, and turning that understanding into a practical modernization path. What makes this role especially interesting is the opportunity to influence both direction and implementation from the very start.
Job DescriptionYou will take a leading role in the early stages of the modernization and help shape the technical path forward.
You will analyze legacy SQL Server and SSIS-based data warehouse flows, including ETL, stored procedures, views, tables and dependencies.
You will contribute to discovery and analysis work as well as hands-on implementation.
You will help modernize existing data flows toward platforms such as Microsoft Fabric, Azure Synapse, Databricks or Snowflake.
You will work with data modeling and help apply concepts such as Kimball, Data Vault, star schema and data marts in a practical way.
You will document technical solutions, mappings, data flows and key design decisions in a structured manner.
You will work closely with architects, BI developers, business experts and other data engineers.
You will support and guide more junior data engineers in the team.
RequirementsExperience working as a Senior Data Engineer.
Very strong SQL skills, especially in SQL Server and T-SQL.
Documented experience with SSIS and traditional Microsoft DWH and BI environments.
Experience analyzing ETL flows, stored procedures, views, tables and dependencies.
Experience of modernization or migration from a legacy DWH to a cloud-based data platform.
Experience with at least one of the following: Microsoft Fabric, Azure Synapse, Databricks or Snowflake.
Good understanding of Kimball, Data Vault, star schema and data marts.
Experience with CI/CD, Git and structured development flows.
Ability to document technical solutions, data flows, mappings and design decisions.
Ability to collaborate closely with architects, BI developers, business experts and other data engineers.
Ability to contribute in both analysis and discovery work as well as hands-on implementation.
Ability to lead more junior data engineers.
Nice to haveExperience with dbt.
Experience with SSAS, SSRS or Power BI.
Experience with Purview, Unity Catalog or DataHub.
Experience from retail, supply chain, finance, HR or similar domains.
What We OfferPermanent employment at Avaron AB
Occupational pension
Wellness allowance of SEK 5,000 per year
Application
Selections are made on an ongoing basis - apply as soon as you can.
Ansök till tjänsten
Lead Data Engineer
1 dag kvar
OM FÖRETAGET
Avaron AB
