About the position
About our client:
Our client offers financial service solutions helping their clients achieve their dreams. With an emphasis on culture fit, they boast a dedicated team of over 600 employees, many with over a decade of tenure. They have built their culture on a feeling of togetherness, trust and respect and are always looking to support employees' continuous learning. Using Agile, they provide diverse services with a focus on research, innovation and improvement.
What you will be doing:
- Design, develop, and modify database structures, relationships, data flows, and data interfaces within the data warehouse.
- Analyse, create and modify data structures to adapt to business needs and add enhanced functionality.
- Develop and modify ETL processes to load data from various sources into the data warehouse.
- Use programming languages, software development methods, and best practices to develop new data warehouse structures and reports and modify existing ones.
- Unit test and debug code.
- Participate in requirements gathering, analysis, technical design, testing, documentation and project planning.
- Consult with clients to gather information about needs, objectives, and requirements.
- Identify and propose technical solutions to client requests and system problems.
- Follow department standards and create written documentation and diagrams as required.
- Thorough understanding of data warehouse architecture, data structures, and fundamental design principles.
- Ability to work independently with general supervision, which may include providing guidance and support to entry-level professionals or support staff.
- Contribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.
- Responsible for software development, production support, and providing expertise in Data Warehouse and Reporting Applications.
What our client is looking for:
- A relevant tertiary degree would be ideal (Computer Science, IT, Data Science, Information Systems, etc.)
- Strong interest in analytical / dimensional modelling, and data analytics tools. Insurance knowledge is a plus.
- In-depth knowledge of business intelligence tools including data warehousing, and ETL (Extraction, Transformation, and Load). Yellowfin knowledge is beneficial.
- Knowledge and understanding of the software development life cycle.
- Knowledge and experience in relational databases, SQL, PostgreSQL.
- Experience in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms.
- Analytical and troubleshooting skills for complex technical issues and tasks.
- Ability to present and explain complex technical topics, problems, and alternative solutions to others.
- Experience estimating solution development and delivering solutions within those estimations.
- Knowledge of Insurance Systems.
- Experience with or knowledge of most of the following software, languages and tools, or similar products would be preferred: SQL Server DBMS, T-SQL (ANSI), PostgreSQL, Python.
Job ID:
For a more comprehensive list of opportunities that we have on offer, do visit our website - [URL Removed]
Desired Skills:
- ETL
- SQL
- Database Structures
