Senior Database Developer – Cigna, Nairobi

Job Description Summary

The Senior Database Developer provides strategic counsel to top management on critical Application Development issues, often necessitating cross-organizational collaboration. This role involves designing complex systems and subsystems, leveraging a deep understanding of available technologies and existing designs. The developer will offer comprehensive consultation to business units and IT management, addressing all phases of application programming and processes across diverse platforms and environments. This includes identifying effective application development solutions, modifying existing programs, and integrating purchased solutions. The role may also involve coding new or modified programs, documenting, testing, implementing, and providing ongoing support for applications. The Senior Database Developer is recognized internally as the go-to expert for complex Application Development tasks.

In this position, you will be instrumental in developing, maintaining, and optimizing our data integration solutions. You will collaborate with cross-functional teams, contribute to technical design, and ensure the reliability and efficiency of our ETL processes and SQL Server environments.

Key Responsibilities:

• Monitor, maintain, and enhance core ETL processes.
• Troubleshoot and resolve SQL Server-related issues.
• Collaborate with senior developers and business stakeholders to document requirements and design solutions.
• Develop and optimize SSIS packages and T-SQL code, including stored procedures, views, and functions.
• Model and document SQL data mapping solutions, collaborating with business and technical teams to determine the best approach.
• Support regular releases and monitor data processing batches.
• Proactively recommend improvements to code, tools, and processes.

Essential Skills:

• 4+ years of experience in developing and supporting SQL Server solutions.
• Strong proficiency in T-SQL and relational database concepts.
• Experience with ETL processes, preferably using SSIS.
• Knowledge of OLAP and OLTP environments.
• Excellent problem-solving skills and ability to reverse engineer code.
• Experience working in Agile development teams.

Desirable Skills:

• Experience with C#, VB.net, or other programming languages.
• Familiarity with Python / PySpark.
• Experience with Git or other source control tools.
• Knowledge of SQL Change Automation or Liquibase is a plus.
• Exposure to continuous integration/delivery practices (CI/CD).
• Experience with SQL Server Reporting Services (SSRS) or similar tools.
• Experience with SAFe or other Agile frameworks.

Personal Attributes:

• Self-motivated with a strong commitment to seeing projects through to completion.
• Passionate about technology and data-driven solutions.
• Excellent communication and teamwork skills.
• Dedicated to maintaining quality and governance standards.