Data Engineer

Key Responsibilities

• Design, develop, and maintain database structures and data pipelines in Snowflake and Oracle environments
• Write efficient SQL queries, stored procedures, and functions to support application requirements
• Create and optimize ETL processes for data migration between different database platforms
• Implement database security measures and access control protocols
• Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions
• Develop Python scripts for data processing, analysis, and automation
• Monitor database performance and recommend optimization strategies
• Participate in code reviews and implement best practices for database development
• Create and maintain comprehensive documentation for database structures and processes

Required Qualifications

• Bachelor’s degree in computer science, Information Technology, or related field
• 5 years of experience with Software/database development.
• 3 years of experience with Relational database development
• Python programming skills, particularly for data manipulation and analysis
• Proficiency in SQL query optimization and performance tuning
• Experience with ETL/ELT processes and data migration strategies
• Knowledge of database security best practices
• Strong analytical and problem-solving abilities

Preferred Qualifications

• Experience with PostgreSQL architecture and development
• Experience with Oracle databases or Oracle cloud infrastructure.
• Knowledge of data modeling and dimensional modeling concepts
• Familiarity with version control systems (Git)
• Experience with CI/CD pipelines for database changes
• Background in financial services or experience with financial data
• Understanding of agile development methodologies
• Certification in Snowflake, Oracle, or related technologies