Data Engineer

Job Purpose

Evaluate business needs and to design, develop and maintain data pipeline and ETL solutions. Other duties include data modelling, database design and performance tuning while championing the needs of the customer.

Data Engineering 

• • Evaluate business needs and provide recommended solution for data management.
  • Design, develop, and maintain the company's data infrastructure. This includes:
    • Designing and implementing data pipelines to move data between different systems.
    • Building and managing data warehouses and data lakes.
    • Developing and deploying data processing and analytics applications.
    • Automating data engineering tasks.
    • Monitoring and troubleshooting data infrastructure.
  • Stay up-to-date on the latest data engineering technologies and trends.
  • Document and maintain all data engineering processes and procedures.
  • Design and build data quality principles and solutions
  Identify opportunities for data acquisition
• Database Administration
• Database Management & Maintenance –
  • Monitor database health and performance using established tools and metrics.
  • Optimize queries, indexes, and database structures to improve efficiency.
  • Manage backup schedules, perform restores, and test disaster recovery procedures.
  • Apply database patches, updates, and security fixes.
• Security & Compliance
  • Create and manage user accounts, roles, and permissions.
  • Implement security standards, encryption, auditing, and compliance policies.
  • Respond to security incidents and assist with data governance requirements.
• Troubleshooting & Support
  • Diagnose and resolve performance bottlenecks, errors, and connectivity issues. (Base/Redgate)
  • Provide support to application/Qlik developers for SQL optimization and schema changes.
  • Assist with break-fix scenarios across development, testing, and production environments.
  • • Automation & Deployment
      • Automate routine tasks using scripts or scheduling tools.
      • Participate in database deployments, migrations, and version-control processes.
    • High Availability & Architecture
      • Maintain and monitor replication, failover clusters, and high-availability configurations where applicable
      • Support capacity planning and storage management with Infrastructure team
      • Contribute to database design discussions and architectural improvements.
    • Documentation & Collaboration
      • Maintain clear documentation for configurations, SOPs, and change logs.
    Collaborate with cross-functional teams including on topics like DevOps, development, and security
  • Data Analysis
  • • Work with data specialists, analysts and other stakeholders to understand business requirements and translate them into technical specifications.
    • Extract insights from data and solve business problems.
    Communicate effectively with technical and non-technical audiences.
  • Collaboration 
  • • Collaborate with other members of the Digital Team to ensure the success of data engineering projects.
    • Build relationships with stakeholders across the company.
    • Communicate effectively with technical and non-technical audiences.
    • Communicate and maintain relationships with vendors and global partners
    Collaborate with data scientists and architects on several projects
  • Development 
  • • Work with developers to build and deploy data-driven applications.
    • Translate business requirements into technical specifications.
    • Develop and deploy data-driven features and functionality.
    Work with developers to troubleshoot and debug data-driven applications.
  • Other
  • • Support and resolve BAU queries via Support Desk
    Create, manage, contribute and support projects for self and  team members (where needed)
  • Drug Safety / Pharmacovigilance
  • Escalate within 1 business day (24 hours) of becoming aware of any adverse events or serious medical incident to Drug Safety Unit/Pharmacovigilance on all Cipla products