Senior Analytical Engineer 97 views

Senior Analytical Engineer 

Company Overview:

About Palladium – Palladium is a global leader in the design, development and delivery of Positive Impact – the intentional creation of enduring social and economic value.  We work with governments, businesses, and investors to solve the world’s most pressing challenges. With a team of more than 3,000 employees operating in 90 plus countries and a global network of over 35,000 experts, we help improve economies, societies and, most importantly, people’s lives. 

Diversity, Equity & Inclusion – We welcome applications from all sections of society and actively encourage diversity to drive innovation, creativity, success and good practice. We positively welcome and seek to ensure we achieve diversity in our workforce; and that all job applicants and employees receive equal and fair treatment regardless of their background or personal characteristics. These include: (but are not limited to) socio-economic background, age, race, gender identity, religion, ethnicity, sexual orientation, disability, nationality, veteran, marital or Indigenous status. 

Should you require any adjustments or accommodations to be made due to a disability or you are a neurodivergent individual or any other circumstance, please email our team at accessibility@thepalladiumgroup.com

Safeguarding – We define Safeguarding as “the preventative action taken by Palladium to protect our people, clients and the communities we work with from harm”. We are committed to ensuring that all children and adults who come into contact with Palladium are treated with respect and are free from abuse.  All successful candidates will be subject to an enhanced selection process including safeguarding-focused interviews and a rigorous due diligence process.

Project Overview:

Funded under the US President’s Emergency Plan
for AIDS Relief (PEPFAR) through a cooperative agreement with the US Centres
for Disease Control and Prevention (CDC), Palladium Development and Consultancy
Kenya Ltd (Palladium Kenya) anticipates 5-year funding to support the Kenya
Ministry of Health, county governments and healthcare service delivery partners
to implement technological innovations in health information systems.

These innovations include the scale up of
electronic medical records systems (EMRs) for clinical decision support and
improved patient care,  the enhancement
of the Kenya National Data Warehouse (NDWH), a centralized data repository of
data from EMRs for analysis and reporting, the development of an
interoperability layer to support the exchange of data across systems, the
enhancement of mHealth solutions and numerous other innovations including  patient identification and informatics
solutions to support health surveillance.

 Primary Duties and Responsibilities: 

• Responsible for developing and maintaining the data infrastructure for analytics and reporting 
  
• Creation of ad-hoc datasets used in modeling, mining, acquisition, and verification.
  
• Developing data extraction routines for EMR platforms and for data in the data warehouse
  
• Ensuring formulas and indicator definitions in the DWH are in concordance with the EMR guidelines definitions (PEPFAR & MoH)
  
• Work closely with the Data Analysis and Use Team in developing information products for the various stakeholder groups.
  
• Assembling large, complex sets of data that meet non-functional and functional business requirements
  
• Be part of discussions with product manager and data analyst to guide them in their understanding of the data in the data repository, shape the product solutions and to better grasp the context of requirements coming your way 
  
• Capture business requirements for analytics and translate complex ones into technical requirements. Collaborate with data engineers to design & implement end-to-end solutions 
  
• Use SQL queries to transform data in our data repository to move it from raw nuggets into reliable business entities and then into reporting aggregates. Identify dependencies for these transformations. Schedule these transformations on our platform. Investigate discrepancies in data. 
  
• Document analytics datasets and any business logic 
  
• Lead some refactoring of data warehouse where needed, to make data more consistent, better documented and the pipelines more resource-efficient 
  

Required Qualifications:

•  BSc degree in Computer
  Science/Computer Engineering. Masters is a plus.
  
• A
  minimum of 5 years’ experience in the same or similar position.
  
• Strong competencies
  in algorithms and software architecture.
  
• Excellent SQL knowledge with the ability to understand, manage and handle complex data and create efficient data models (applied to data warehousing in particular) 
  
• 3+ years of experience with Data Warehousing, DBT or SSIS or Opensource ETL Tools
  
• 5+ years of Software engineering experience with hands-on experience automating tasks with scripting.
  
• Ability to work with multiple parts of the business (product, ads) and multiple stakeholders (engineers, analysts, product managers…) 
  
• Have basic knowledge of machine learning to understand data scientist’s needs better (and, by extension, the organization’s needs), get models into production and build more accurate data pipelines.
  
• Experience in creating project plans to identify tasks, milestones, and deliverables.
  
• Proven experience with project management tools (Jira / Microsoft Project) is a plus
  
• Passionate about data visualization. Experience with any of the mainstream visualization tools such as Power BI, Tableau, Qlik.
  
• Demonstrated experience modelling data in analytics and the ability to develop data models that cater to specific domains—both conceptual and physical models.
  
• Strong communication. Ability to articulate complex problems/solutions for the senior stakeholder to understand