The Data Warehouse Manager will be responsible for managing and optimizing SBP's Microsoft SQL data warehouse, ensuring that it runs efficiently, is secure, and meets the business needs of our organization. The Data Warehouse Manager will be responsible for designing, implementing, and maintaining our data warehouse infrastructure, as well as overseeing the ETL processes and data modeling activities.
Responsibilities:
- Manage a team of data developers, providing guidance and support to ensure that project timelines and quality standards are met.
- Design and implement Microsoft SQL data warehouse infrastructure.
- Develop and maintain data models that align with the needs of the organization.
- Oversee ETL processes and ensure they run efficiently and accurately.
- Ensure data integrity, security, and availability.
- Develop and maintain performance metrics to track data warehouse efficiency and identify opportunities for optimization.
- Manage user access and permissions to the data warehouse.
- Provide technical expertise and support to other members of the IT and SQL development teams as needed.
Requirements:
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- 8+ years of experience in data warehouse management with expertise in Microsoft SQL Server.
- 8+ years of experience leading and managing a team of data developers.
- Strong understanding of data warehousing concepts and methodologies, including data modeling, ETL processes, and data quality management.
- Strong knowledge of SQL and database query optimization.
- Familiarity with cloud-based data warehousing solutions, such as Azure or AWS.
- Experience with data visualization tools (e.g., IBM Cognos, Power BI) is a plus
- Excellent problem-solving skills with the ability to troubleshoot complex technical issues.