Data Architect / Engineer - Business Intelligence (m/w/d)
Berlin, BE, DE Wildpoldsried, BY, DE Home Office, DE
We are seeking a Data Architect / Engineer (m/w/d) who will be part of our Business Intelligence unit in sonnen. In your role as Business Intelligence Data Architect, your primary responsibility at sonnen will be to enhance our already existing BI architecture as well as leading initiatives to develop and manage ETL processes and the definition of topic specific data marts. You will collaborate closely with our BI Lead to translate use cases into effective and efficient solutions. In our unit, you have the opportunity to explore and use the newest and most advanced technologies in the market such as a cloud-based database management system and an entire off-premise ETL implementation.
Being part of a global company with the offices across continents will provide you with the unique experience of collaborating with an international team and design BI solutions that will have an impact on sonnen’s business world-wide.
Your responsibilities:
- Develop a future-proof and sustainable BI architecture based on a defined strategy & vision
- Lead initiatives to develop and manage ETL process in an already existing cloud-based (Azure) BI environment
- Build conceptual and physical data models
- Lead the definition and development of data marts
- Design and implement data structures and data models
- Managing our Infrastructure as a Service implementations
- Assist with your technical expertise in the initiation of new BI projects
Your profile:
- You have at least three years of experience in the field of Business Intelligence
- You are an advanced SQL programmer (sound T-SQL knowledge is recommended)
- You have good Python and/or PHP experience
- You are familiar with self-service reporting tools such Tableau (Tableau knowledge recommended)
- You have experience in ETL design and management
- You are passionate about exploring different data sources such as Salesforce, SAP and further sources of structured as well as unstructured data
- In terms of designing BI solutions you follow a systematic view taking into consideration all actors
- You speak fluent German and English and have strong verbal and written communication skills
- You are a team player with a hands-on mentality and you are passionate about bringing clean and affordable energy to everyone
Jobsegment:
Database, Business Intelligence, ERP, Programmer, Developer, Technology