Data Warehouse
Position Overview
Designing, implementing, and maintaining data warehousing solutions that support the organization's business intelligence and analytics initiatives. You will work closely with cross-functional teams to ensure data integrity, availability, and performance.
Responsibilities
- Design and implement data warehousing solutions to support business intelligence and reporting needs.
- Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and translate them into technical specifications.
- Utilize data warehousing platforms such as Amazon Redshift, Google BigQuery, Microsoft SQL Server (SSIS, SSAS), Oracle Exadata, or Snowflake to manage and optimize data storage and retrieval.
- Develop and maintain ETL (Extract, Transform, Load) processes using tools like Talend, Informatica, Microsoft SSIS, or Apache Nifi to ensure data is accurately and efficiently processed.
- Monitor and optimize data warehouse performance, ensuring data integrity and availability for reporting and analytics.
- Conduct data quality assessments and implement data governance practices to maintain high data standards.
- Stay up-to-date with industry trends and best practices in data warehousing and analytics.
Qualifications
- Bachelor’s or master’s degree in Computer Science, Information Technology, Data Science, or a related field. This provides a solid foundation in technical and analytical skills necessary for working with data warehouses.
- Proficiency with data warehousing platforms such as Amazon Redshift, Google BigQuery, Microsoft SQL Server (SSIS, SSAS), Oracle Exadata, or Snowflake.
- Experience with ETL (Extract, Transform, Load) tools like Talend, Informatica, Microsoft SSIS, or Apache Nifi. Experience with cloud platforms such as AWS, Azure, or Google Cloud.
- Several years of experience working with data warehousing solutions, demonstrating a strong understanding of data modeling, database design, and data integration techniques.
- Excellent analytical and problem-solving skills, with a keen attention to detail.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
- Proficiency in English; knowledge of German is a plus.