New Role: BI Developer x 2 (Oracle experience)
Location: Manchester (Hybrid)
Salary: Up to £55,000 per annum
Skills: ETL Development, Data Warehouse Development, Oracle Data Integrator, API Integration, Power BI
New exciting opportunity, for a BI Developer to join a data driven organisation during a period of transformation following significant investment.
Whether it's producing data reporting on the performance of security checkpoints mining the data lake for insights on car parking and retail or working across the IT and Operations teams to find better ways of visualizing real-time data to help to manage operations - the BI developers at this organisation are hands on with data in a truly meaningful way.
Responsibilities:
- Production of the right BI to enable informed revenue generating decision making feeding
business strategic initiatives.
- Ownership of the production of quality BI reporting and visualisation for Exco, SLT and
senior stakeholders.
- Design and develop new ETL process to add new data sources to the data warehouse and transform through to the dimensional model.
- Optimisation and continuous improvement of BI environment to meet the growing
business demand ensuring no impact on performance, recommending aggregation and
materialised views to enable this.
- Work with BI Intelligence Lead and commercial stakeholders in running user acceptance
testing initiatives.
- Maintenance and improvement of existing ETL loads to move from batch window loads to
real-time streaming of data.
- Design and develop Power BI dashboards delivering insight and actionable intelligence
Key Skills:
- As a successful individual, you will have experience working as a BI developer within ETL and data warehousing, ideally with use of Oracle Data Integrator (ODI) in an AWS S3/Redshift cloud environment, or similar ETL tools (Informatica, SSIS).
- In-depth practical database development and performance tuning experience using SQL
(required) and materialised views.
- Demonstrable experience of ingesting and transforming complex disparate datasets within a warehouse solution usage of web APIs desirable. Additionally, Python skills advantageous.
- Understanding of dimensional data modelling (Kimball) and key principles.
- In-depth knowledge and experience creating Power BI reports/dashboards/apps in a
collaborative environment with internal/external users.
- Knowledge of the wider BI marketplace in particular real-time data streaming technologies.
- Exposure to requirements gathering and interpretation, with proven ability to understand
complex business ideas, and deliver the desired solution proving incremental ROI to the
organisation.
New Role: BI Developer x 2 (Oracle experience)
Location: Manchester (Hybrid)
Salary: Up to £55,000 per annum
Skills: ETL Development, Data Warehouse Development, Oracle Data Integrator, API Integration, Power BI