Salary 45,000 - 70,000 GBP per year
Requirements:
- We are looking for two BI Developers with experience in ETL and data warehousing, ideally using Oracle Data Integrator (ODI) in a cloud environment such as AWS S3/Redshift or similar ETL tools like Informatica or SSIS. You should possess in-depth practical experience in database development and performance tuning using SQL, and have familiarity with materialized views. Experience in ingesting and transforming complex disparate datasets within a warehouse solution, as well as usage of web APIs, is desirable. Python skills will be considered advantageous. A solid understanding of dimensional data modeling (Kimball) and its key principles is important. You should also have extensive experience in creating Power BI reports/dashboards/apps in collaboration with both internal and external users. Knowledge of the broader BI marketplace, particularly around real-time data streaming technologies, and experience in requirements gathering and interpretation will be essential.
Responsibilities:
- As a BI Developer, you will be responsible for producing the right business intelligence to enable informed revenue-generating decision-making that supports our strategic initiatives. You will own the production of high-quality BI reporting and visualization for our executive committee, senior leadership team, and other key stakeholders. Your role will involve designing and developing new ETL processes to incorporate new data sources into the data warehouse and transforming that data into a dimensional model. You will optimize and continuously improve our BI environment to meet growing business demands while ensuring no performance impacts, recommending aggregation and materialized views as necessary. Collaboration with our BI Intelligence Lead and commercial stakeholders will be crucial in running user acceptance testing initiatives. Additionally, you will be tasked with maintaining and improving existing ETL loads, transitioning from batch processing to real-time data streaming, and designing Power BI dashboards that deliver actionable insights.
Technologies:
- API
- AWS
- Cloud
- Data Warehouse
- ETL
- Informatica
- ODI
- Oracle
- Power BI
- Python
- SQL
- Security
- SSIS
- Web
More:
We are a data-driven organization undergoing a period of transformation following significant investment. Our BI Developers play a crucial role in this journey, working hands-on with data to extract meaningful insights. Whether it’s producing reports on the performance of security checkpoints, mining our data lake for insights on car parking and retail, or collaborating across IT and Operations teams to enhance real-time data visualization for operational management, you will be at the forefront of our data initiatives. This is an exciting opportunity for you to contribute to our ongoing success while developing your skills in a dynamic and supportive environment. The position is hybrid based in Manchester, with a competitive salary of up to £55,000 per annum.