What We Do:
Temenos Group is a market leading banking software provider, partnering with banks and other financial institutions to transform their businesses and stay ahead of a changing marketplace. Our Analytics solution empowers business users with self-service access to accurate data providing a single version of the truth, driving smarter decision making faster and with better business outcomes; embeds intelligent analytics into core system, provides customers with contextual, relevant product offers and advice at a time when they are most likely to buy – improving cross selling, value of customer and customer loyalty; integrates analytical capabilities directly into the core banking and other applications; improve ROA and Profitability up to 30 basis points.
We are looking for a Senior ETL/ Business Intelligence (BI) Developer to fill a permanent position in our growing BI and EPM team.
The position will be responsible for planning, designing, configuring developing, testing, deploying and supporting ETL/BI solutions. The candidate creates and maintains ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows). He/she develops and uses ETL applications to perform data analysis, create technical designs and provide applications support.
The candidate should have 7+ years experience in developing ETL / business intelligence solutions. The position requires strong SQL knowledge and an advanced understanding of working in a data warehouse environment, which includes data design, data integration, database architecture, report development and application tuning. He/she will work closely with BI and EPM team members to develop and deploy new BI solutions and manage change requests
Responsibilities and Accountabilities:
Participate in requirements definition, solution development and the implementation phases of data warehouse and reporting projects
Create and maintain ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows)
Assist in definition of logical and physical data models
Configure and tune ETL infrastructure to optimize the data warehousing architecture
Design, implement and maintain a reporting, monitoring and dashboard framework
Develop aggregation, monitoring and alerting tools/modules
Troubleshoot and resolve data, system and performance issues
Inventory, comment and document existing customizations (DW, ETL, Repository, Catalog).
Work closely with BI Architect to define development strategy and estimate levels of effort.
Propose enhancements and strategy related to customizations.
Prepare requirements documents, functional and technical designs, test scenarios, deployment plans, etc.
Participate in day-to-day support as well as future-state design with BI team.
Skills and Qualifications:
Strong Experience with SQL on Oracle database
Strong Experience with Oracle ODI and other ETL data warehousing tools and concepts
Experience with Oracle ERP (E-Business Suite 11.5.10 or R12) is a plus
Knowledge on Atlassian (Jira and Bitbucket) is a plus
Experience with Oracle EPM (Planning, Essbase) is a plus