Our client has asked DFP Recruitment to source a suitably qualified and experienced Data Warehouse/Reporting Architect for a 6 month opportunity, with the possibility of extension, for a 1st of February 2021 start.

The project is responsible for developing a foundational reporting and analytics solution in support of a new IBM Maximo Enterprise Asset Management (EAM) system. The solution is replacing a long standing legacy SAP PM implementation with an emphasis on developing a modern approach to accessing information through a combination of data lake, data warehousing and data visualisation platforms. The platform combines Amazon S3, Redshift, RDS (SQL) and Microsoft Power BI.

Our client requires an experienced data warehouse architect to assist the creation of a green fields works management data warehouse. Extensive experience in data analysis, data integration technologies and Kimball (Dimensional) modelling techniques is required. The successful candidate should have a strong working knowledge of AWS S3, Redshift, Business Object Data Services (or similar ETL) and Microsoft Power BI. Familiarity with work management systems, specifically SAP PM and/or IBM Maximo, would be advantageous.

The ideal candidate must be a highly motivated, data warehousing and analytics professional. The role requires an ability for the individual to work in a structured Agile framework, be highly organised and able to drive outcomes with stakeholders. This requires them to proactively work with the business and development teams to architect performant solutions that are easily operated by business report authors.

Duties include:

Analysing legacy reporting and new reporting requirements for conversion to a new reporting platform
Identifying and advising technology options for the data pipeline, reporting data marts and report delivery
Documenting solution architecture, technology components and information flows. Presenting these solutions for approval by architectural and operational teams
Defining and documenting logical and physical data models
Documenting data mapping transformation rules through the data pipeline from source to target systems
Work with developers to design ideal solutions and solve technical issues
Work with business analysts to clarify business needs and data transformation rules
Prototype novel solutions for demonstration or implementation
Define and refine user stories for development
Participate in Agile ceremonies such as daily standups, story estimation, sprint planning, retrospectives and showcases

Should you meet the above criteria and wish to apply for this exciting opportunity, please click “apply” now or call Brad on 9287 9801 for further information.

Data Warehouse/Reporting Architect

DFP Recruitment • Perth CBD & Inner Suburbs WA

You may be interested in these jobs

DFP Recruitment
• Perth CBD & Inner Suburbs WA