Job Description

• To ensure that source data generated via AIC's multiple business-specific systems are organized and transformed in ways that support business users' needs and Business Intelligence applications. To ensure that source data generated via AIC's multiple business-specific systems are organized and transformed in ways that support business users' needs and Business Intelligence applications. To work closely with Business Intelligence (BI) and Advance Analytics and Modelling (AAM) colleagues in the Research Department, and partner with program development, sector development, outreach, and grants divisions in AIC to understand the business requirements and translate them into long-term data solutions. To work with key external partners within the existing IT development processes, monitor and provide input to influence the Design, development, and optimization of scalable data warehouses Building of data pipelines across data systems both internal and external to AIC's data ecosystem and Optimizing of existing data structures so that it supports self-service reporting requirements Job Requirements: Bachelor degree in Computer Science, Applied Mathematics, or Engineering. Professional Data Engineer certification will be considered favorably. At least 5 years of relevant experience developing, testing, and maintaining data warehouses, preferably in health or social care settings. Experience in Data mapping and integration processes Building and managing ETL processes Handling large data systems with relational databases Building pipelines to automate data interface pipelines and Familiarity with Excel, SQL, Informatica, Python, Tableau Be an advocate for best practices and lifelong learning Able to work well independently and in teams Excellent written and oral communication skills and Flexible, self-motivating, and able to manage multiple projects efficiently.