At Crest Nicholson we build quality of life by creating places and spaces people want to spend time in.
To deliver that, those within Crest need information they can trust. Information that paints pictures and help us determine the future direction and decisions our business takes. That is only possible when our supporting IT systems are reliable and make it easy for our colleagues to input and extract the information they need.
That’s why we are now looking to strengthen the stability, accuracy and accessibility of our data warehouse and Group reporting by recruiting an additional Business Information Developer.
About you and the skills you will need for this role:
You will have systems and reporting background and will use your expertise to support a management information step change during a planned period of systems change.
You will have a strong knowledge of Anaplan, PowerBI and experience with Cognos Analytics or related software. You will work primarily with these applications, alongside any other application-specific reporting tools that ensure timely reporting and better decision making to drive our business forward. The role will cover all BI aspects, from design and build, Extract Transfer Load (ETL) and all BI associated reporting outputs.
You will be a strong, pragmatic, communicator. You will work closely with our systems accountant and throughout the organisation to identify and drive better business information enabling others to make better decisions.
Your principal duties:
Support and develop business reporting, modelling, and data integration systems.
Maximise the value of enterprise information assets and analytics to provide better decision-making insights – clearly linked to business strategy.
Help transition the business to a new ERP (Coins) and forecast modelling (Anaplan) in relation to associated reporting and data integration
Oversee business information compliance related to storage and reporting.
Identify and prioritise business requirements, ensuring products are successfully embedded and monitored upon implementation.
Act as super user for all Business Information related projects, representing IT where required.
Maintain documents related to the data warehouse and business logic - used in semantic data models.
Support the ongoing stability of the ETL tool, Informatica, and the Cognos data warehouse - as part of day-to-day running and upgrades/developments.
The Successful Candidate:
Must have 2 years’ experience of Anaplan model/dashboard development. Ideally with the new Anaplan reporting functionality
Ideally 3 years’ experience ofCognos including SQL Data Warehouse management and development experience
Informatica ETL
SQL SSIS / SSRS
Ideally 1 years’ experience of working with Microsoft Power BI
Ability to develop complex BI reports, using a multi data layer toolset (Anaplan and Cognos)
Experience workingin a structured environment with change control delivery, with and managing a range of stakeholders.
with a range of development methodologies and tools
Ideally experience of Cognos including Framework Manager, Reporting, Dashboarding, Data Modules or related software
Understanding of the need for comprehensive formal technical documentation such as User Requirements, Functional Specifications, able to translate these into the creation of technical specifications, programming, test and UAT scripts.
Job Type: Full-time