Lead Data Engineer

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 take a key role in a BI/DWH modernization initiative where legacy Microsoft-based data flows are being understood, challenged, and gradually moved to a modern cloud data platform. This is a role for you who can contribute early, not only when implementation is already defined. You will help analyze a complex data warehouse landscape, identify dependencies across ETL flows and data models, and shape how legacy solutions can be modernized in a structured and practical way.
This is more than a pure development role. You are expected to combine strong hands-on engineering skills with the ability to understand existing BI and DWH environments in depth and turn that understanding into sound technical decisions. You will work closely with architects, BI developers, business experts, and other data engineers, while also supporting more junior colleagues. If you enjoy roles where you can influence both direction and delivery, this is a strong opportunity to make a real impact.
Job DescriptionYou will take a leading role in the early phases of the modernization work and help drive discovery, analysis, and the first implementation steps.
You will analyze legacy SQL Server and SSIS-based data warehouse flows, including ETL processes, stored procedures, views, tables, and technical dependencies.
You will help define how existing data flows and models can be modernized toward a cloud-based data platform.
You will work hands-on with implementation while also contributing to technical direction and solution design.
You will collaborate closely with architects, BI developers, business experts, and other data engineers to align business needs with technical design.
You will document technical solutions, data flows, mappings, and design decisions in a clear and structured way.
You will contribute with best practices around structured development flows, CI/CD, and version control.
You will support and guide more junior data engineers in day-to-day work and technical decisions.
RequirementsSenior-level experience as a Data Engineer
Very strong SQL skills, especially in SQL Server and T-SQL
Documented experience with SSIS and traditional Microsoft DWH/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
Experience documenting technical solutions, data flows, mappings, and design decisions
Ability to work closely with architects, BI developers, business experts, and other data engineers
Ability to contribute both in discovery and analysis as well as hands-on implementation
Experience leading more junior Data Engineers
Fluent Swedish and good English
Ability to pass a background check
Nice to haveExperience with dbt
Experience with SSAS, SSRS, or Power BI
Experience with Purview, Unity Catalog, or DataHub
Experience from domains such as retail, supply chain, finance, or HR
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.