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 entrylevel 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.
- Indepth 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 TSQL (ANSI) PostgreSQL Python.
Job ID: