Responsibilities:
Support the Business Intelligence and Business Analytics (BIBA) Unit in developing and implementing the technical solutions needed for data acquisition as well as providing operational support ensuring that any technical glitch is quickly addressed.
Design technical solutions for data acquisition and storage into our centralized data repository.
Develop ETL scripts, design data-driven logic and conduct unit testing .
Conduct database modeling and design as to improve overall performance.
Produce design artifacts and documentation which will allow future support of the implemented solutions.
Investigate and resolve incidents and identify whether the problem is caused by the data loading code or is due to bad data received from the data provider.
Execute service requests related to routine and ad-hoc data loads.
Provide the data quality check and report on the data quality issue.
Ensure that data collected is in a format which is easy consumable by the business users from Digital and Analytics Strategy Division.
Re-engineer ETL processes as to make them suitable for Informatica IDMC migration.
MUST HAVES:
10+ years experience in data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas
10+ years experience in design, build, automate and optimize complex data ETL/ELT processes
10+ years experience in building mappings and workflows using Informatica PowerCenter and Intelligent Data Management Cloud
Working experience with cloud data warehouse solutions such as Amazon Redshift
Experience and Skill Set Requirements
Public Sector/HealthcareExperience - 5 points
Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.
Knowledge of Project Management Institute (PMI) and Public Sector I\&IT project management methodologies.
Knowledge and understanding of Ministry policy and IT project approval processes and requirements
Experience with large complex IT Health-related projects.
General Skills - 15 points
Demonstrated strong leadership and people management skills.
Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions.
Exceptional analytical, problem solving and decision-making skills.
Demonstrated strong interpersonal, verbal and written communication, and presentation skills.
Proven troubleshooting and critical thinking experience
Demonstrated ability to apply strong listening skills to facilitate issue resolution.
Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships.
Strong interpersonal, facilitation and negotiation skills with ability to build rapport with stakeholders and drive negotiations to a successful outcome.
Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively.
A motivated, flexible, detail-oriented, and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.
Technical Skills - 60 points
10+ years experience in data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas
10+ years experience in design, build, automate and optimize complex data ETL/ELT processes
10+ years experience in building mappings and workflows using Informatica PowerCenter and Intelligent Data Management Cloud
10+ years experience in data modelling (relational \& dimensional), advanced SQL, query optimization
10+ years experience in scripting languages (Python, Unix shell)
Working experience with cloud technologies (AWS, Azure, Google)
Working experience with cloud data warehouse solutions such as Amazon Redshift
Core Skill and Experience - 20 points
10+ years of experience with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications.
10+ years of experience in technical analysis, program code, detailed programming and reports specifications, program design, writing and /or generating code, and conducting unit tests.
10+ years of experience in software in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.
10+ years of experience in developing and maintaining system design models, technical documentation, and specifications.
5+ years of experience in conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements / specifications / documentation.
SDLC end-to-end.
Agile/scrum using JIRA/Confluence and waterfall methodologies.
**This position is listed as Onsite; expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified office location.**
Job Types: Full-time, Fixed term contract
Pay: From $125,000.00 per year
Work Location: In person