Data Engineer - W2

Oreva Technologies, Inc. is seeking a Mid/Sr. Level Data Engineer to design, build, and maintain their critical data infrastructure. This hands-on role focuses on optimizing MySQL, managing cloud databases, and developing scalable ETL/ELT data pipelines while ensuring performance, security, and reliability.

Responsibilities:

• Design, build, and maintain critical data infrastructure
• Support both day-to-day production needs and project-based initiatives
• Own the development of scalable ETL/ELT data pipelines
• Administer core analytical databases, ensuring performance, security, and reliability
• Integrate newly acquired customer data

Requirements:

• 5+ years of experience with Azure MySQL Flexible Server, including hands-on administration in production environments
• Deep, real-world MySQL expertise, with proven ability to optimize queries and schemas and troubleshoot complex production database issues
• Proven experience administering, tuning, optimizing, and modernizing cloud-based MySQL environments
• Strong proficiency in Python for data scripting, automation, and pipeline development
• Proven experience designing, building, and deploying scalable ETL/ELT data pipelines using Python, SQL, and Azure Data Factory, integrating data from APIs, transactional databases, and flat files
• Deep understanding of ETL/ELT concepts and tools, including Azure Data Factory, SSIS, Informatica, Talend, AWS Glue, or Fivetran