Report Developer

Role: Database reporting Developer- SQL Server (SSRS, SSIS, SSAS)

The candidate is responsible for Database management, Data Integration and Report Development.

Skills and Knowledge Requirements:

• Have experience in large­ scale database operation and maintenance management.
• Bilingual in Mandarin highly preferred due to global team
• Familiar with data backup, restoration, import, export, synchronization, format conversion and other operations of Microsoft SQL Server or other database.
• Extensive experience writing advanced SQL queries and stored procedures and troubleshooting their performance.
• Experience in develop test plans, test scripts, validation procedures, and perform system testing.
• Familiarity with Business Intelligence tools including SSIS and SSRS, integration with SQL.
• Ability to develop reports development and maintenance policies, and draft the new product or report requirements.

Responsibilities:

• Responsible for all aspects of planning and management of database;
• Responsible for database environment configuration, migration and cutover, storage, fault handling, performance optimization, backup, daily monitoring, etc.;
• Design and develop database and applications with all phases of software development lifecycle.
• Use SSIS, SSRS, and SQL to develop ETL packages and reports.
• Design and develop new features/functionalities of ETL Data Integration using SSIS, SQL,
• Perform hands-on data-related tasks such as data analysis, data integration, data issue remediation, data reconciliation, data warehousing, and reporting automation.
• Develop functions, views and stored procedures, complex SQL queries for reports that meet business requirements.
• Write technical documents and testing reports. Provide support for the internal and external audit and exam.
• Be responsible for demonstrating risk awareness by following all policies, procedures, and internal control in their daily routine.

Education and Experience Requirements:

• Bachelor's degree in Computer Science or equivalent related field.
• 5 years of experience in Microsoft SQL Server or other database applications in an enterprise environment.