You will use your expertise to design data warehouse and business intelligence solutions, including secure inter-organisation data services, complex data warehouses and analytical toolsets for end users.
Your role will include the following responsibilities:
Work with business stakeholders and developers to identify and document current and future requirements
Specify and design end to end data warehouse, data mart and reporting solutions
Select appropriate BI solution design standards, methods and tools, in line with the IT architecture policy and strategy
Review existing system designs to ensure a selection of technology and solution architectures are applied effectively
Manage the investigation of data requirements, co-ordinate the data analysis and modelling activities, in order to establish and understand the data classification, information flow, logic and relationships to facilitate the design of effective data management solutions
Coordinate design activities, promoting the discipline to ensure solution consistency
Evaluate new services, vendors, applications and security tools, from a solution perspective and architectural fit
Assess the systems architecture currently in place and working with technical staff to recommend solutions to improve it
Lead Design elaboration workshops with various vendors
Inform various stakeholders about risks/issues/mitigations linked to individually assigned solutions
You should have the following skills and experience:
Strong Data Modelling for business intelligence solutions
Knowledge of financial industry data is preferred
Strong understanding and experience with specific BI technologies including Microsoft SQL - SSIS, SSAS, SSRS
Knowledge of Azure is highly desirable (AWS experience will also be considered)
Strong understanding of data modelling and design concepts such as data vault, dimensional modelling, and general data modelling skills
Strong understanding of data integration and transformation patterns such as ETL, ELT and associated technologies
To be considered for the role click the 'apply' button or for more information about this and other opportunities please contact Nicola Mc Glinchey on 02 94645661 or email: email@example.com and quote the above job reference number.
Paxus values diversity and welcomes applications from Indigenous Australians, people from diverse cultural and linguistic backgrounds and people living with a disability. If you require an adjustment to the recruitment process please contact me on the above contact details.