Description

You will design, develop, and maintain the enterprise data warehouse and associated MS SQL servers, owning all ETL activities and reporting deliverables.

Responsibilities

• Design, develop, and maintain the enterprise data warehouse architecture and database schemas.
• Own end-to-end ETL activity, including development and maintenance of data load scripts using SSIS.
• Build and maintain enterprise reports, including monthly financial and board reports, using SSRS.
• Troubleshoot, debug, and test scripts to ensure error-free code and resolve complex process issues.
• Collaborate with stakeholders to gather requirements and design data warehouse enhancements.

Required Skills

• 5+ years of experience in data warehousing and database management.
• Deep technical knowledge of Microsoft SQL Server, SSIS, SSAS, SSRS, and MDS.
• Proficiency in database design, query optimization, and data manipulation.
• Experience using SQL Server Management Studio, SQL Server Data Tools, and Visual Studio.
• Strong understanding of ETL processes and data warehouse concepts.
• Familiarity with web technologies including HTML, CSS, and JavaScript.
• Proficiency with Microsoft Office Suite and MS operating systems.
• Ability to integrate diverse datasets into an enterprise data warehouse.

Preferred Skills

• Familiarity with ERP system inquiry screens.

Key Skills

Education

Any Graduate