Senior Data Engineer

Senior Data Engineer About the Company A leading software development company is looking for an experienced Senior Data Engineer to join its technology team and contribute to building scalable, reliable, and high-quality data solutions. About the Role We are seeking a Senior Data Engineer to design, build, and optimize scalable data platforms, ETL/ELT pipelines, and data warehouses that power analytics, AI, and business applications. The ideal candidate has strong software engineering and database fundamentals, cloud experience, and expertise in data modeling, orchestration, and automation, with a passion for delivering reliable, secure, and high-quality data solutions. Key Responsibilities Design, develop, and maintain scalable ETL/ELT pipelines to ingest, process, and transform data from diverse sources into data warehouses and data lakes. Build and optimize data models, database schemas, and storage solutions to support high-performance data processing. Manage relational and NoSQL databases, ensuring performance, scalability, security, and data integrity. Develop SQL objects including stored procedures, functions, triggers, views, and optimized queries for efficient data processing. Design and maintain OLTP and OLAP data systems, including dimensional modelling and data warehouse architectures. Implement data validation, monitoring, and quality assurance processes to ensure data accuracy and reliability. Develop and integrate REST APIs for data ingestion, distribution, and retrieval. Automate workflows and orchestrate complex data pipelines using Apache Airflow and other ETL automation tools. Collaborate with Software Engineers, Product Managers, and business stakeholders to deliver scalable data solutions. Contribute to data governance, security, documentation, and engineering best practices. Participate in code reviews, CI/CD processes, and Git-based collaborative development workflows. Continuously evaluate and adopt modern technologies, cloud services, and AI-powered development practices. Job Requirements Strong proficiency in Python and SQL. Experience with PL/SQL and/or T-SQL is preferred. Well-versed in at least one programming language such as Python, JavaScript, or similar. Experience with relational databases such as PostgreSQL, MySQL, SQL Server, Oracle, or similar. Familiarity with NoSQL databases such as MongoDB or Elasticsearch. Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP). Familiarity with cloud services including S3, Redshift, Glue, Athena, RDS, Lambda, BigQuery, or equivalent. Experience with OLTP and OLAP database architecture, best practices, dimensional modelling, and data warehouse design. Working knowledge of Docker, containers, Kubernetes, and cloud-native infrastructure. Experience with Apache Airflow for workflow orchestration. Familiarity with DBT (Data Build Tool). Strong understanding of programming fundamentals, object-oriented programming, data structures, algorithms, and software engineering principles. Strong computing foundation with excellent analytical and problem-solving skills. End-to-end understanding of software architecture and application layers, including Frontend, Backend, and REST APIs. Knowledge of Power BI, Tableau, or other BI/visualization tools is an advantage. Proficient working knowledge of Git and Git-based development workflows. Preferable Skills Experience with Prompt Engineering and Retrieval-Augmented Generation (RAG). Familiarity with GenAI orchestration frameworks such as LangChain, LlamaIndex, or similar tools for building and integrating AI-powered applications. Understanding of Large Language Models (LLMs), embeddings, vector databases, AI APIs, and AI-assisted development workflows is an added advantage. Fundamentals of Artificial Intelligence (AI) and practical exposure to Generative AI technologies are a plus. Education & Experience Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Science, or a related discipline is preferred. 5+ years of professional experience in Data Engineering, Software Engineering, Database Development, or a related technical role. Relevant internships, open-source contributions, and personal projects demonstrating practical expertise are valued. Professional certifications are a plus, including but not limited to: AWS Certified Data Engineer – Associate Google Cloud Professional Data Engineer Microsoft Azure Data Engineer Associate