MS SQL Data Analyst Supervisor, Location : Aberdeen ( 5 Days ) Salary : 32-36K ( Negotiable) 

Responsibilities:

• Design, develop and maintain robust data pipelines to extract, transaction and load data from various sources into our data warehouse for efficient data storage and retrieval 

• Collaborate with stakeholders to understand data requirements and translate them into technical specifications and data models 

• Optimize, troubleshoot and automate data flow, and implement data quality processes to ensure data integrity, accuracy, and to facilitate timely analysis 

• Work closely with financial analysts and supervisors to support their data needs and enable efficient data analysis and operations such as month end closing 

• Monitor and optimize data warehouse performance, including query optimization, indexing and data partitioning

• Identify opportunities for process improvements and provide actionable recommendations for enhancing data collection, analysis and reporting methodologies

• Lead and provide technical guidance to junior data analysts, ensuring timely and high-quality deliverables

• Handle ad hoc data analysis requests and projects as required 

Requirements: 

• Degree in Computer Science, Information Systems, Mathematics or other related disciplines

• At least 5 years of relevant working experience in data engineering or data analysis, with proven track record of designing and implementing data solutions 

• Preferably with experience and knowledge in ERP systems, accounting and business processes, and business intelligence 

• Strong proficiency in MS SQL is must and other database technologies, with the ability to design and optimize complex queries 

• Good written and spoken English and Chinese

Front-End Developer軟件工程師 (系統) , Tsuen Wan , 5 days, salary : 26-35K ( Nego ) 

Requirements and description for the job ：

• Bachelor’s degree in Computer Science, Information Technology, or a related discipline.

• Excellent communication skills in Chinese, Cantonese and English. And the ability to work collaboratively in a team environment.

• Understand business process and user requirement to provide effective application system solution.

• Implementing an office automation system will enable us to embrace a new era of system revolution, enhancing the factory’s automated operation capabilities.

• Develop web applications using. Net Framework, C++ MS SQL Database.

• Proficient in HTML5, CSS3, Json, JavaScript, Ajax, jQuery and Python.

• With 2 years working experience in web programming.

Cloud Engineer/高級軟件工程師 (Cloud), Tsuen Wan , 5 days, salary : 32-38K ( Nego ) 

Requirements and description for the job 職位要求：

• Bachelor’s degree in Computer Science, Information Technology, or a related discipline.

• Excellent communication skills in Chinese, Cantonese and English. And the ability to work collaboratively in a team environment.

• Proficiency in Azure/ AWS Cloud Platform.

• 3 years of extensive experience in Azure cloud infrastructure management and Linux/ Unix system administration.

• Design, deploy cloud networks architecture on Azure/ AWS to build hybrid cloud solutions to ensure cloud network security and network management.

• Experience of maintaining and monitoring cloud resources including cluster nodes, database on Azure/ AWS to ensure optimal performance, scalability, and availability.

• Experience of AWS CloudFormation/Terraform/Azure Resource Manager programming.

• Experience of designing best practices of IAM Policy, Azure Security Certificate is preferred.

• Proven troubleshooting skills and the ability to resolve complex technical issues efficiently.

• Work closely with the IT team and factory team to ensure the security and compliance of the infrastructure.

• Cloud infrastructure will drive new developments and support factories’ transition to automation.

** Personal data will be treated with strict confidential and used for recruitment purpose only.

P & A consultant Ltd will not charge any fees from the above-stated job-seeker, your job apply to our company means your acceptance of our terms and conditions.  

All applications applied through our system will be delivered directly to the advertiser and privacy of personal data of the applicant will be ensured with security.