XTN-C250880
KMC Solutions Inc
- Taguig City, Metro Manila
- Permanent
- Full-time
- Ability to quickly learn new skills and technologies where required.
- Take ownership and manage business expectations.
- Understanding of business processes and requirements analysis to deliver functional and practical solutions.
- Data model design and mapping.
- Provide clean transformed data ready for analysis.
- Develop and maintain data documentation and definitions.
- Ability to work with snowflake cloud warehouse.
- Develop and maintain data documentation and definitions.
- Design and develop data pipelines and ETL processes using snowflake and data integration tools like Fivetran to ingest data from various sources into our data warehouse.
- Collaboration with stakeholders to understand data requirements and translate them into technical solutions.
- Implement data transformation processes using dbt to clean, enrich, and structure data for analytics and reporting purposes.
- Optimize data pipelines for performance, scalability, and reliability.
- Work closely with data analysts and other cross-functional teams to support their data needs.
- Identify, investigate, and develop solutions to data quality, performance, and integrity issues.
- Monitor data quality and troubleshoot issues to ensure the accuracy and integrity of data.
- Provision user access to data
- Ensure data security when working with confidential and personal data.
- Good understanding of the AWS cloud environment and data related services.
- Qualified with bachelor’s degree majoring in a quantitative discipline such as finance, economics, mathematics, statistics, science, computer science, engineering, or other relevant field.
- Experience working with relational database and administration of Postgre SQL/SQL server platforms.
- Strong programming skills in dbt and SQL with focus on data manipulation, ETL/ELT and analysis.
- Proven experience as a Data engineer or similar role, with hands-on experience in Snowflake,Fivetran, and dbt.
- Proficiency in data modeling concepts.
- Data integration (ETL/ELT) methods and techniques-flat files (CSV, JSON, XML), SQL (PostgreSQL, oracle, MMSQL, MySQL) and API’s.
- Expert knowledge of reporting/visualization tools, preferably Tableau server.
- Excellent problem solving skills and attention to detail.
- Scanned copy of valid NBI Clearance
- Accomplished Medical or PEME Slip (covered by KMC)
- 2x2 & Half body picture with white background
- Proof of government numbers (TIN, SSS, Pag-ibig, & Philhealth).
- Photocopy of 2 valid IDs – front & back (government-issued)
- Clear copy of your Birth Certificate (PSA or NSO)
- Accomplished HR Forms & Promissory Note (will be provided by KMC’s Onboarding Team)
We host amazing and quality events and implement people-centric policies to work flexibly. We ensure that everyone in our expansive network is engaged, from our internal employees and those who work on behalf our offshore partners.Life within KMC: Work Hard Party HarderAt KMC, we work hard and we are committed to putting our best foot forward in everything we do. Everyone is encouraged to be an individual while also working for the collective good of the KMC Community. We believe mistakes are opportunities and that you should not present a solution without a problem.
We also know when hard work deserves to be recognized so we reward our employees with monthly parties, free trips and much much more!