Business Intelligence Engineer

On behalf of UKRI, we are looking for a Business Intelligence Engineer (Inside IR35) for a 12 Month contract based REMOTELY with occasional travel to Swindon and nationally.

The Organisation
Operating across the whole of the UK with a combined budget of more than £6BN, UK Research and Innovation is a new entity that brings together nine partners to create an independent organisation with a strong voice for research and innovation, and a vision to ensure the UK maintains its world-leading position in research and innovation.

The business intelligence engineer will be responsible to develop and support reports and dashboards for critical business functions. The engineer is expected to have good proficiency with the tools/technology such as Power BI, SQL, DAX query, AWS Athena, Postgres DB, data modelling, and incident management tools. The engineer is expected to have moderate proficiency with tools such as GitHub and Python.

Key Responsibilities and Accountabilities:

The business intelligence engineer will be a hands-on Power BI developer to develop and construct complete solution designs to complex reporting requirements across business verticals and data sources:

1. Power BI development
   Development and Maintenance of Power BI reports, dashboards, dataflows.
2. Development and Maintenance of data models within Power BI and exposure to DAX query language.
3. Knowledge of admin activity across Power BI tools such as access management, role-based data access, subscription, Power BI gateway set up etc.
4. Experience migrating reports to Power BI dashboards from Jaspersoft.

1. SQL Proficiency
   Development and Maintenance of SQL development with backend engine such as Postgres RDS, MySQL and AWS Athena.
2. Experience migrating queries from MySQL and Postgres to AWS Athena.

1. Collaboration
   Collaborate with cross-functional teams to participate in requirement gathering and creating user stories.

To Achieve this, you will have the following skills:

1. Comfortable working in an Agile rapidly changing environment.
2. You will be an accomplished developer, with excellent Power BI and SQL skills.
3. Experience working with AWS Athena, Postgres, MySQL and Power BI.
4. Experience performing admin activity around Power BI such as access management, Power BI gateway set up etc.
5. Experience maintaining code repo over GitHub.
6. Moderate proficiency with Python programming.
7. Communicate effectively with stakeholders to gather requirements and create user stories.

Experience:

1. Comfortable working in an Agile rapidly changing environment.
2. You will be an accomplished developer, with excellent Power BI and SQL skills.
3. Experience working with AWS Athena, Postgres, MySQL and Power BI.
4. Experience performing admin activity around Power BI such as access management, Power BI gateway set up etc.
5. Experience maintaining code repo over GitHub.
6. Communicate effectively with stakeholders to gather requirements and create user stories.

Skills:

1. Excellent User engagement/management, good communicator.
2. Power BI development and administration experience.
3. AWS tools such as Athena, Postgres RDS, MySQL, EC2.
4. SQL experience on various platforms such as PostgreSQL, Athena, MySQL etc.
5. Moderate proficiency with Python programming.
6. Experience maintaining code repo over GitHub.

Qualifications:

1. Computing/Engineering/Numerate degree.

Please be aware that this role can only be worked within the UK and not Overseas.