Data Warehouse Architect (m/f/x)
Join Cloudflight as a Data Warehouse Architect, designing and optimizing data systems that drive business intelligence and innovation.
At Cloudflight, we’re committed to making a digital difference. It’s a difference that impacts businesses and society alike and one that’s fueled by our passion for technology and our dedication to sparking the brightest ideas in ourselves and others.
Together, an experienced team of over one thousand brilliant people, we collaborate to create value-driven custom software solutions.
The Data Warehouse Architect is responsible for designing, building, and maintaining of Cloudflight's internal data warehouse system. This role involves working closely with business analysts, data scientists, and other stakeholders to understand business requirements and translate them into technical specifications. The DWH Architect ensures data integrity, quality, and availability through the creation of efficient ETL processes, data models, and reporting mechanisms.
Key Responsibilities
- Designing and implementing scalable data warehouse architecture for business intelligence. Defining and maintaining data models and dictionaries
- Developing and optimising ETL processes for accurate data delivery
- Managing data integration from various sources
- Monitoring and improving query performance and data load times
- Performing warehouse tuning and optimisation
- Establishing data governance for accuracy, consistency, and security
- Implementing data quality monitoring and error-handling
- Gathering and documenting requirements for new data initiatives
- Ensuring the data warehouse is aligned with Cloudflight's IT strategy
- Maintaining documentation and providing training on warehouse functionalities
The following will make you succeed in this role
- Bachelor’s degree in Computer Science, Information Systems, or a related field. Master’s degree preferred
- Minimum of 5 years of experience in data warehousing, database management, and ETL development
- Proficiency in SQL and database technologies (e.g. Oracle, SQL Server, PostgreSQL)
- Hands-on experience with data warehouse tools (e.g. AWS Redshift, Snowflake, Microsoft Fabric)
- Strong knowledge of data modeling techniques and tools
- Familiarity with ETL tools (ideally dbt)
- Understanding of BI tools and reporting platforms (ideally Power BI)
- Excellent problem-solving skills and attention to detail
- Strong communication and interpersonal skills in English and German
We are an equal opportunity employer. We strive to create an inclusive environment where everyone can thrive regardless of their background and circumstances. All applicants receive equal opportunity regardless of age, gender identity or expression, language, disability, ethnicity, national origin, religion, or sexual orientation.
We will go through your application and come back with feedback.
Any questions? Contact us at jobs@cloudflight.io
- Area
- Other
- Role
- IT and tooling
- Locations
- Cologne (Germany), Frankfurt (Germany), Hamburg (Germany), Karlsruhe (Germany), Kiel (Germany), Munich (Germany)
- Remote status
- Hybrid Remote
Benefits and Perks
-
Learning and development opportunities
Dedicated programs that will support your growth from day one.
-
Location-specific benefits
Get to know colleagues of different backgrounds and enjoy various local benefits.
-
Workplace flexibility
Enjoy the harmony between private and professional life through remote options, flexible working hours and part time models.
-
Referral program
Get rewarded for bringing your friends to Cloudflight.
-
Team & company events
Always feel empowered to have fun. Welcome days, seasonal local and global events are waiting for you.
-
Mental health
Sometimes life gets hard, but here you will always feel safe and be heard. In a case of need, you are encouraged to consult a professional psychologist recommended by the company.
-
It’s the little things...
Snacks, fruits in the office, gifts for your new diploma or your wedding, books and many more little surprises.
Data Warehouse Architect (m/f/x)
Join Cloudflight as a Data Warehouse Architect, designing and optimizing data systems that drive business intelligence and innovation.
Loading application form