FRONTIS is a boutique consulting firm doing work that matters to ensure progressive success for our clients, our people and society. We help organizations move and operate at the frontier of excellence by shaping strategies and transforming operations with insightful research and cutting-edge technology.

We are looking for a talented and driven ETL/ SSIS Developer to join our team of high performers doing exciting work in an environment which accelerates learning and development at every level.

• Design and develop ETL processes and Data Warehouse for external clients to achieve business goal; from the acquisition and staging of data, storing records within the warehouses historical archive and transforming records for loading into the reporting tables.
• Design and write the ETL code as well as the batch management and error handling processes.
• Prepare key documentation to support the technical design in technical specifications contributing to solution design across the data warehouse landscape, for example - business process redesign, user interface design and the implementation of automated control processes.
• Develop unit test scripts and conduct performance tuning to arrive at quality outcome
• Lead ETL development and design whilst mentoring the projects other ETL developer in best practice and design.
• Design and development of the Data Warehouses batch management control processes and error handling procedures

• 3 years+ experience supporting Data Warehouse implementations
• A good understanding of the concepts and best practices of data warehouse ETL design
• Detailed knowledge of core BI Fundamentals (Multi-Dimensional, Star Schemas, Cubes, Data Flows and Schemas)
• Have designed and developed ETL work packages on at least one data warehouse project, and be able to demonstrate expertise around the Microsoft SQL Server technologies (primarily SSIS and SSAS).
• Creative problem solver. Methodical and structured approach to design and development.
• Delivery focused with the ability to prioritize activities.
• Possess drive, demonstrable initiative and a strong work ethic.
• Flexible team player within a small, multi-disciplinary team.
• Professional attitude and presentation.
• Good communicator, both written and verbal.
• Ability to handle multiple tasks and adapt to a constantly changing environment.