Jobs · jobstreet_ph

K

Data Engineer / Excel Automation Developer

KMC Solutions · Metro Manila · Posted 30d ago

remoteFull-timemid5-8 yrs🇵🇭 Philippines
Apply on jobstreet_ph

About the role

About the role We are looking for a hands-on Data Engineer / Automation Developer to support our Manila-based Remote Operations / Production Data Management team for a growing portfolio of utility-scale solar power plants. The team works with production and operational data from multiple monitoring providers. Much of the current data collection, checking, standardization and reporting workflow is manual and heavily Excel-based. The main objective of this role is to build, manage and continuously improve the data infrastructure and automation supporting the production-data environment. The role will be responsible for ensuring that underlying data is complete, accurate, current, standardized and technically reliable. Key responsibilities Build and maintain automated collection of production and operational data from multiple monitoring systems. Design and manage the database and data structures used to store, organize and process operational data. Standardize and normalize data from different providers into a common internal structure. Monitor data pipelines and database updates to ensure data remains complete, current and reliable. Build and maintain data-quality controls for missing, duplicate, incorrect, stale or inconsistent data, and investigate and resolve data issues. Develop and maintain scripts, ETL pipelines, APIs and system integrations supporting the data environment. Automate calculations and data outputs used by the monthly reporting process. Integrate automation into existing Excel-based workflows, including VBA / macros where appropriate. Preserve raw source data for auditability and reprocessing. Maintain, troubleshoot and improve the automation and data infrastructure as systems, providers and business requirements change. About you Mid-level data engineer / developer with approximately 3–5 years of relevant hands-on experience in Excel Automation, Data Automation Engineeringing Beyond junior level and comfortable taking ownership of a defined technical workstream from requirements through implementation, operation and ongoing improvement. Experience in Python or any language for data automation is a plus SQL, database design and database management ETL / data pipelines APIs and system integration Data quality management, validation and error handling Excel automation, using VBA or macros or any automation tool is a must Technical troubleshooting and maintenance of production data systems Proactive and self-directed — able to identify issues, propose practical solutions and move work forward without waiting for detailed instructions.

Read the full posting on jobstreet_ph →

FAQ

Is the Data Engineer / Excel Automation Developer role at KMC Solutions remote?+

This Data Engineer / Excel Automation Developer position is listed as remote (Metro Manila).

What seniority level is this Data Engineer / Excel Automation Developer role?+

This is a mid level position.

How do I apply for the Data Engineer / Excel Automation Developer role at KMC Solutions?+

Use the "Apply on jobstreet_ph" button to open the original posting on jobstreet_ph, where you can submit your application directly to KMC Solutions.