Your tasks

• Consulting and conception: Strategic consulting for customers in the development of data-driven solutions – from requirements gathering to implementation.
• Data modeling and architecture: Design and development of high-performance and scalable data models based on Microsoft SQL Server, Azure Synapse and Microsoft Fabric.
• Reporting and visualization: Creation of interactive dashboards and reports with Power BI including DAX optimization and UX-oriented preparation.
• Microsoft Fabric projects: Implementation of modern data warehousing and lakehouse solutions based on Microsoft Fabric, including OneLake, notebooks, and pipelines.
• ETL/ELT processes: Development of efficient data loading processes using Power Query, Dataflows Gen2, SQL and Spark in Fabric.
• Customer workshops and training: Conducting workshops for requirements gathering, know-how transfer and project support.
• Quality assurance: Ensuring data quality, performance tuning, and the use of best practices in data governance and security.
• Project management and team leadership: Taking responsibility for (sub-)projects, managing junior consultants, communicating with stakeholders at management level.

Your profile

• Completed studies in business informatics, computer science, mathematics or comparable courses.
• At least7 years of relevant professional experiencein the data analytics/BI environment.
• In-depth knowledge of the conception, modeling and implementation of business intelligence solutions.
• Several years of professional experience working with theMicrosoft BI Stack:
• Power BI(including DAX, M-Language, Deployment Pipelines)
• SQL Server(T-SQL, Stored Procedures, Views, Indexing)
• Microsoft Fabric / Azure Synapse / Data Lake / Lakehouse concepts
• Experience in planning and implementing modernETL/ELT routes– ideally with Dataflows Gen2, Azure Data Factory or Notebooks in Fabric.
• Strongconsulting and communication skillsin customer contact (focus: specialist departments & IT).
• Experience indata integration of heterogeneous sources(ERP, CRM, APIs, flat files, etc.).
• Knowledge ofdata visualization, UX and storytelling with data.
• Familiar with agile methods (Scrum, Kanban) and collaborative tools (e.g. Azure DevOps, Git).
• Ability to implement complex tasks both independently and as part of a team.

What we offer - your crew:Benefits

• Individually tailored training opportunities through our Crew:Academy – external and internal training opportunities
• Crew:ShoppingCard – tax-free monthly credit for free use (after the trial period)
• Modern notebook and an iPhone work phone
• Corporate Benefits & JobRad*
• Health Plus supplementary insurance* with valuable preventive and additional benefits
• Home office options
• 30 days vacation
• Crew:Spirit & Events: Christmas parties, summer parties, after-work events, team events
• after one year of employment

About Kramer & Crew

As IT directors of digital transformation, we develop holistic, future-oriented IT projects individually for each client. With excellent digital transformation strategies, turnkey crew solutions, and personalized crew services, we make our clients future-ready. Our agenda includes the latest technologies, growth, and lasting crew values, ensuring we also stay on top of our people and take on our clients' projects with 360-degree IT direction.

Crew:Academy - the key to success for your development

To ensure we're always among the best and remain future-proof, we've founded our own Crew:Academy. There, we offer our employees individually tailored training opportunities to deepen their personal and social skills, ensuring we stay at the top of our game, both professionally and personally. This opens up a wide range of development opportunities for professional and personal development, as well as excellent opportunities for advancement within the crew.

Our Spirit - Crew: Values ​​we live by and stand up for

Our daily life as a crew member is shaped by our values, which guide our thoughts and actions and which we champion. A dedicated and welcoming team awaits you, offering a family-friendly working environment. We value togetherness, closeness, and trusting relationships so that everyone in the crew feels comfortable and their individual talents can flourish. The inclusion of all people is part of our identity. We ensure fair, performance-based, and transparent recruitment, personnel development, and promotion of our crew.

Contact information

Kramer & Crew GmbH & Co. KG
Paula Bolte
Stolberger Straße 5
50933 Cologne