REQUIRED SKILLS & EXPERIENCE:

• 5+ years of experience in data engineering, database administration, or analytics.
• Strong hands-on experience with Vertica (schema design, performance tuning, administration).
• Proven experience in migrating data from Oracle, SQL Server, or SQLite → Vertica.
• Proficient in SQL, data modelling, and query optimization.
• Experience writing functions/procedures in Vertica for data preparation.
• Familiarity with ETL tools and data integration processes.
• Proficient in Linux and shell scripting; Python knowledge is a plus.
• Experience with data analytics, visualization tools, and quality validation processes.
• Knowledge of VerticaPy is an advantage.

ABOUT THE ROLE:

We are seeking an experienced Vertica Data Engineer with strong expertise in database migration, performance tuning, and data preparation. The ideal candidate will have hands-on experience with Vertica database administration, development, and optimization, as well as proven skills in data integration and analytics.

KEY RESPONSIBILITIES:

• Design, develop, and maintain data models, schema designs, and pipelines in Vertica.
• Migrate data from Oracle, SQL Server, or SQLite to Vertica with minimal downtime.
• Write and optimize functions, procedures, and SQL scripts for business data preparation.
• Perform data integration, performance tuning, and query optimization in Vertica.
• Work with ETL tools to extract, transform, and load large-scale datasets.
• Conduct quality checks and data validation to ensure integrity and accuracy.
• Collaborate with business stakeholders to deliver analytics and visualization solutions.
• Automate repetitive tasks using Linux shell scripting and/or Python.
• Leverage VerticaPy for advanced analytics where applicable.