Data EngineerSykes

Provide support to BI Developers and Reports Analysts in structuring raw data to useful datasets, and store the same in SharePoint, SQL Server, and other repositories within the organization as required
Ensure that all scripts deployed/utilized, using the existing programming language in the reports machine (i.e. Python) are working and functioning as intended
Assist BI Developers in building analytical tools that utilize the data pipeline to provide actionable insights into compliance, operational efficiency, and other key operational and business performance metrics
Monitor, update and execute scripts improvements to achieve efficiency in data and troubleshoot any data issues arising from out-of-date and dysfunctional scripts
Work with various internal teams to assist with data-related technical issues, perform root cause analysis (RCAs) on both internal and external data and process-related questions, and support their data infrastructure needs
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and other server technologies, whether On-Prem or Cloud
Create and maintain optimal data pipeline architecture, and optimize data delivery and re-design infrastructure for greater scalability
Assemble large, complex data sets that meet business requirements
Identify, design, and implement internal process improvement
Experience in SQL Management and Administration, preferably Microsoft MS SQL 2017 or the latest version
Experience in Windows Server Administration Experience in manipulating, structuring and monitoring big datasets
Experience in implementing ETL/ELT procedures, data mining processes, date pipelining, and building of data warehouse
Experience with Restful API
Experience with Azure PAAS (Platform-As-A-Service)
Experience with Power Automate and Power Shell
Experience with SFTP/Shell Scripting
Knowledgeable in MSStack Platform
Strong Knowledge with Pandas, Selenium, OS, Pyodbc, Regex, Xlsxwingst, Numpy, SQL Alchemy, Apache
Must be willing to work in night shift
Graduate degree in Computer Science, Statistics, Information System, Applied Mathematics, or recipient of any certifications related to Data Engineering
With more than 2 years of experience in using Python
With more than 2 years of experience in data engineering, data mining processes, date pipelining, and building of data warehouse
Bossjob

Makati City, Metro Manila
Permanent
Full-time