What are the responsibilities and job description for the Business Intelligence Developer position at PGMTEK Inc.?
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, SSRS, 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.
- ability to speak mandarin highly preferred
Education and Experience Requirements :