Job
In this position, you will design lakehouse and warehouse architectures with Microsoft Fabric, create ETL pipelines, model data with Power BI, and optimize database solutions to support data-driven decision-making.
This listing has been machine translated. Show original
Job technologies
Your role in the team
- You design and build lakehouse and warehouse architectures in Microsoft Fabric using OneLake, Data Factory, and notebooks.
- You design star schemas, build ETL/ELT pipelines, and ensure data quality.
- You develop Power BI reports and semantic models using DAX, Power Query, and row-level security.
- You integrate and optimize SQL Server, Azure SQL, and PostgreSQL.
- You gather requirements, define KPIs and reports together with the customer, and hand over the solution to them seamlessly.
- You take responsibility for architectural decisions and, depending on your experience, for providing technical leadership on the project.
Our expectations of you
Qualifications
- Modeling: Dimensional modeling and ETL/ELT design are your specialty.
- Code: You write excellent SQL and Python, are familiar with relational databases, and have already developed APIs, for example with FastAPI.
- Mindset: You translate business questions into KPIs. When someone says, “We need a dashboard,” you first ask what decision it’s meant to support.
- Requirements: German at C1 level, fluent English.
Experience
- Experience: 4 to 7 years as a Data Engineer, BI Engineer, or Analytics Engineer, ideally working on client projects.
- Platform: You have hands-on project experience with Microsoft Fabric and/or Databricks.
- Power BI: You have several years of project experience with Power BI, including DAX and data modeling.
- Additional advantages: PySpark, Azure Synapse, Airflow or dbt, experience with data governance (Microsoft Purview), and capacity and cost management in Fabric. Certifications such as PL-300, DP-600, or DP-700 are a plus.
What we offer
- Projects that are fun: We work on truly exciting data and AI projects for renowned clients in the energy, industrial, and financial sectors.
- Modern stack: Microsoft Fabric, Databricks, Power BI, and Azure. You’ll work with in-demand technologies, not legacy systems.
- See the impact: Your dashboards reach management. You see how your work influences decisions.
- Short lines of communication: You work directly with the executive team and our principals. Ideas are quickly decided on and implemented.
- Development: Those who grow with us take on more responsibility, projects, and team leadership. We support certifications such as DP-600 and DP-700.
- Flexibility: You can work from home or from our offices in Berlin or Munich.
Topics you will work on
Job locations
About your employer
Pexon Consulting GmbH provides comprehensive IT consulting and development services to assist companies in digitizing their IT infrastructure, focusing on cloud solutions, DevOps, and data management.
- Established Company
- Onsite, Hybrid, Full Remote
- Consulting
More jobs
These jobs might also interest you
Hello, let's say WE! We - the HUK-COBURG Insurance Group - are among the top 10 in Germany. Founded over 90 years ago, we are now the leading insurer for private households with over 13 million customers and the largest German auto insurer. Our...
You’ll be joining at a stage where we’re building and evolving our new CRM platform. That’s exactly what makes this role special: you won’t just develop features—you’ll actively help shape the technical foundation of a modern CRM ecosystem. Together...
The role As a Forward Deployed AI Engineer, you go directly into our specialist departments, understand the processes, and develop production-ready AI and automation solutions that will fundamentally change the way the entire GGW Group operates. You do...
