Business Intelligence (BI/ DWH) Architect

As a Business Intelligence (BI/DWH) Architect at Drees & Sommer, you will analyze and design our BI and Data Warehouse structure, support maintenance of the existing BI environment, and develop ETL mapping and logic. Your role will also involve creating jobs for batch and real-time data processing and developing complex SQL queries and database objects.

To qualify for the Business Intelligence (BI/DWH) Architect role at Drees & Sommer, applicants should have completed studies in Computer Science or a related field, and possess a minimum of 4 years of experience in SSIS, Power BI, ETL & SQL Development, particularly with Microsoft SQL Server. Knowledge of NoSQL databases is considered an advantage.

Successful candidates for the Business Intelligence (BI/DWH) Architect position at Drees & Sommer should possess strong data analysis skills, the ability to create data migration scripts, and experience in data conversion and transformation. Proficiency in debugging and defect fixing is crucial, as is a proactive mindset and passion for data.

The work environment for a Business Intelligence (BI/DWH) Architect at Drees & Sommer is collaborative, innovative, and supportive. You’ll work alongside creative thinkers and industry leaders on high-profile projects, with opportunities for professional development and a strong emphasis on work-life balance.

Yes, the Business Intelligence (BI/DWH) Architect position at Drees & Sommer may require both national and international travel, as you’ll interface with various teams and departments across locations to develop and modify reporting applications.

When discussing ETL processes, it's important to highlight specific projects where you’ve implemented ETL. Discuss your role, the challenges faced, and the outcomes. Mention your proficiency in SSIS, detailing any complex mappings or transformations you’ve handled.

When designing a Data Warehouse architecture, start by understanding business requirements. Discuss your approach to data modeling, the choice of star vs. snowflake schemas, and how you address data integration from various sources.

Effective data analysis involves both technical skills and business acumen. Share specific tools and methodologies you've used, along with examples of how your analysis led to actionable insights or optimizations in previous projects.

Data quality is crucial. Explain your process for validation, cleansing, and monitoring data quality metrics. Discuss tools or frameworks you've implemented to ensure data integrity and accuracy in your past work.

Select a project that showcases your problem-solving skills. Explain the challenge, your thought process, and the eventual success. This demonstrates your ability to handle pressure and complexity in BI tasks.

Emphasize your commitment to continuous learning. Mention specific resources, communities, or training programs you participate in, and how you apply new knowledge or insights to your work at Drees & Sommer.

Discuss how you’ve utilized SQL in your projects, highlighting complex queries you've written for reporting or data transformation. Provide examples of how those queries improved business decision-making.

Collaboration is key. Talk about your communication strategies, how you translate technical concepts into understandable terms for non-technical stakeholders, and any success stories where your collaboration resulted in positive outcomes.

Select a reporting application that had significant impact. Describe your role in its development, the technologies you used, and user feedback. This showcases your hands-on experience and results-oriented mindset.

Share your passion for BI and alignment with Drees & Sommer’s vision. Discuss how the role fits your career goals and your enthusiasm for contributing to their mission of creating a better future.