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 join a major BI/DWH modernization initiative where a complex legacy Microsoft data warehouse environment is being analyzed and reshaped for the future. This role is centered on understanding existing data flows, dependencies and design choices, then helping drive the transition toward a modern cloud-based data platform.

You will work from an early stage of the project, contributing in both discovery and implementation. The role suits you if you combine deep technical hands-on skills with the ability to see the bigger picture in data architecture, data modeling and migration strategy. It is an exciting opportunity if you want to influence a modernization journey from the ground up and help define how a future-ready data platform should be built.

Job Description

• You will take a lead role in the early phases of a BI/DWH modernization project.
• You will analyze legacy ETL flows, stored procedures, views, tables and technical dependencies.
• You will help shape the modernization of existing SQL Server and SSIS-based data flows.
• You will contribute in discovery, analysis and hands-on implementation.
• You will work with data modeling and support the move toward modern platforms such as Microsoft Fabric, Azure Synapse, Databricks or Snowflake.
• You will document technical solutions, data flows, mappings and design decisions in a structured way.
• You will collaborate closely with architects, BI developers, business experts and other data engineers.
• You will support and guide more junior data engineers in the team.

Requirements

• Experience 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/BI environments.
• Experience analyzing ETL flows, stored procedures, views, tables and dependencies.
• Experience with 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 work closely with architects, BI developers, business experts and other data engineers.
• Ability to contribute in both analysis/discovery and hands-on implementation.
• Experience leading more junior data engineers.
• Ability to pass a background check.

Nice to have

• Experience 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 Offer

• Permanent 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.