Data Engineer

Job Title: Data Engineer (Python SQL, Data Modeling)

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using Python and SQL
• Extract, transform, and load data from various sources (APIs, databases, files, third-party systems)
• Build and optimize data storage solutions (data warehouses, data lakes)
• Design and implement efficient data models (star schema, snowflake schema, normalized/denormalized models)
• Ensure data quality, integrity, and consistency across systems
• Optimize SQL queries and database performance
• Monitor, troubleshoot, and improve data pipeline reliability and performance
• Collaborate with analysts and data scientists to understand data requirements
• Implement data governance, security, and best practices
• Document data processes, models, and workflows

Required Skills & Qualifications

• Strong proficiency in Python for data processing (e.g., Pandas, PySpark)
• Advanced SQL skills (joins, window functions, query optimization)
• Solid understanding of data modeling concepts and techniques
• Experience with ETL/ELT pipeline development
• Hands-on experience with relational databases (e.g., PostgreSQL, MySQL)
• Familiarity with data warehouses (e.g., Snowflake, BigQuery, Redshift)
• Understanding of distributed data processing frameworks (e.g., Spark)
• Knowledge of version control systems (e.g., Git)