This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
The Systems Integration Senior Analyst role involves leading the design and development of data warehouse solutions, with a focus on SQL and ETL tools. Candidates should have strong analytical skills and experience in performance tuning. Mentoring junior team members and collaborating with stakeholders are key aspects of this position. A proactive approach to troubleshooting and documentation is essential.
Job Responsibility:
Lead the design and development of major features to the data warehouse system
Create and maintain requirements/design artefacts and documents
Provide estimates and deliverable dates to help with the development of project plans
Produces the required analysis and design, either individually or by actively participating in development process
Pro-actively identify and address any environment and performance concerns
Mentor junior team members and foster adherence to best practices in programming, testing, builds and deployments
Function as an integral part of a fast-paced and agile technical team
Interact closely with business stakeholders to clarify requirements and communicate technical design choices and limitations
Requirements:
Strong skills in developing and implementing the solutions in a Datawarehouse system
Proficient in an ETL tool like informatica, SAP BODS etc... (Talend knowledge would be added advantage)
Strong experience in SQL Server relational database system (Snowflake knowledge would be added advantage)
Should be an expert in SQL/procedure coding
Have knowledge in database maintenance and management
Strong knowledge/experience in designing data model
Familiarity with version control and DevOps process
Knowledge on any of the reporting tool and familiarity with agile methodology
Troubleshooting any issue that may arise and providing recommendation/solution
Proven work experience in performance tuning
Have knowledge on any of the Orchestrator tool
Desire and ability to adapt to new languages and coding standards
Prepare design document (LLD) and any other supporting documents
Should possess excellent writing, analytical and communication skills
Open minded to learn new integration tools and be able to apply skills to Integration development