Core Responsibilities
• Design, build, and maintain scalable ETL/ELT pipelines for structured and unstructured data.
• Develop high-quality data integration workflows using modern data engineering tools and frameworks.
• Optimize data processing performance, storage usage, and pipeline reliability.
• Implement data quality checks, validation rules, and monitoring dashboards.
• Collaborate with data analysts, data scientists, and business teams to deliver reliable datasets suitable for reporting and analytics.
• Manage data security, access controls, and governance best practices.
• Support production workflows, troubleshoot issues, and improve platform stability.
Additional Responsibilities for Data Models & Structures (Operational + DW)
• Own the design and maintenance of logical and physical data models for
operational systems and enterprise data warehouse (OLTP + DWH).
• Define and enforce data modeling standards, naming conventions, and schema governance.
• Translate business processes into efficient database schemas, including star/snowflake models.
• Optimize queries and database structures for high-performance analytics and real-time data access.
• Work closely with DBAs, architects, and product teams to ensure data models meet scalability and performance requirements.
• Lead database refactoring efforts, schema evolution, and versioning processes.
• Perform impact analysis for schema changes across upstream and downstream systems.