The Strengthening Supply Chain Systems (SSCS) activity in collaboration with the Ministry of Health (MoH) developed the Pharmaceutical Information Portal (PIP) currently hosted at the MoH. SSCS seeks the support of a Business Intelligence developer to support further customization and development of dashboards and reports within the PIP and provide associated support functions required for PIP to function effectively.

OVERALL RESPONSIBILITIES

The Principal Programmer – Business Intelligence (BI) is responsible for the maintenance and further expansion of the PIP (Pharmaceutical Information Portal) data warehouse and portal in collaboration with the IT Programmer/SharePoint developer. The priorities and required functionality for expansion of the PIP will be determined in collaboration with the Department of Pharmacy and Natural Medicines (DPNM). The Principal Programmer – Business Intelligence will architect, design, build, implement, support, test, and maintain; dimensional models, extract, transform and load processes, reporting modules, and analysis/dashboard solutions.

SPECIFIC RESPONSIBILITIES
• Collect and analyze end-user Business Intelligence requirements and evaluate the feasibility of these requirements from a technical perspective.
• Work closely with report requestors to clarify needs and ensure that deliverables are to their specifications and delivered in a timely manner.
• Perform conceptual, logical, physical, and multidimensional data modelling.
• Identify data discrepancies and data quality issues and work to ensure data consistency and integrity.
• Develop and maintain SSIS Extract, Transform, and Load processes across multiple data sources.
• Design, develop and distribute reports (standard and ad-hoc) and dashboards from different data sources.
• Design, develop and implement data management and data analytics solutions.
• Optimize the OLAP and data-mining performance functions.
• Monitor system details within the data warehouse including stored procedures and execution time and implement efficiency improvements.
• Respond to and resolve load failures and performance issues.
• Work with the Senior Systems Administrator in developing and executing project plans within assigned schedule and timeline.
• Recommend improvements to provide optimum reporting solutions.
• Stay updated with business operations and business intelligence processes.

QUALIFICATIONS

• Bachelor’s degree in Information Technology/Computer Science or a related field. Master’s degree in any of the above fields is an added advantage.
• Six (6) years of experience with demonstrated skills in software development and maintenance (i.e., software requirements analysis, software design including object-oriented analysis and design, coding, testing, documentation, configuration management, user training, deployment, and lifecycle maintenance). This includes working with users to define requirements, architecting an effective software solution, and designing and developing databases and applications.
• A minimum of six (6) years ETL development experience in a SQL Server environment with at least three (3) years of SSIS specific experience
• A minimum of six (6) years reporting development experience in a SQL Server environment with a minimum of three (3) years SSRS/Report Builder experience
• A minimum of three (3) years OLAP and cube development experience with SSAS or similar tools
• MCSE Business Intelligence and MCSE Data Platform certifications are an added advantage
• Strong Microsoft SQL Server skills, preferably MCSA SQL Server certified.
• Strong TSQL skills.
• Strong programming skills using VB.net or C#.net.
• In-depth knowledge of dimensional modelling.
• Knowledge of Performance Point, Power Pivot and Share Point is an added advantage
• Strong analytical, problem solving, collaboration and technical skills.
• Proficient in creating written communication materials that effectively summarize findings and support.
• Attention to detail and commitment to high quality/error free deliverables.
• Must be motivated, independent and self-sufficient. Able to receive an assigned task and see it through to completion with minimal supervision.
• Must be well organized, a good communicator, able to effectively prioritize tasks, and manage projects from concept to production.
• Must be able to write thorough and concise functional and design specifications as well as easily readable end user documentation.
• Must be well able to brainstorm with others, thrive in a collaborative team environment, multi task, and quickly adapt to change.
• Emphasizes personal and professional growth by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Must have excellent written and oral communication skills, and able to read and write in English.
• A wide degree of creativity and latitude required.

MSH is an equal opportunity employer and will not discriminate against any employee or applicant for employment on the basis of race, color, sex, sexual orientation, gender or gender identity, religion, creed, citizenship, national origin, age, veteran status, or disability unrelated to job requirements. MSH will take affirmative action to ensure that qualified applicants are employed and that employees are treated without regard to their race, age, color, religion, sex, sexual orientation, gender identity, national origin, veteran and disability status. In compliance with U.S. Department of Labor Executive Order 11246, Section 503 of the Rehabilitation Act, and Section 4212 of the Vietnam Era Readjustment Assistance Act, MSH has developed and maintains an affirmative action program and plan.