JOB SUMMARY

The BI Developer role will involve developing standardised solutions to meet the needs of a rapidly evolving company. The successful candidate will be required to build and improve frontend reports, qc/validate outputs, and support in optimising company data models.
The role will report to the International Systems Director and will work with several senior stakeholders across the business. The successful candidate will be provided every opportunity to develop their knowledge and experience across the data modelling lifecycle through eliciting user requirements, prioritising work, data modelling, writing high quality SQL/DAX, to designing and improving user-facing dashboards.

QUALIFICATIONS AND KEY SKILLS

• Must have experience developing reports, data modelling, and column/measure definition in Power BI
• Good working knowledge of DAX
• Good working knowledge of SQL
• Skilled in data management and data transformation
• Have knowledge of general database architectures or a specific architecture
• Be fully Microsoft Office literate
• Strong analytical and problem-solving skills
• Must have good written and verbal communication skills.
• Previous experience designing data models and structures.
• Excellent time management skills, be organised and detail oriented.
• Able to establish and maintain effective working relationships with strategic partners, operational teams and internal technical resources ensuring reliability, credibility and trust.
• Have some experience using JIRA or other ticket management applications.
• Ideally have some experience within the Logistics, Freight Forwarding or Transport industries
• Ideally have experience working with cloud database environments
• Ideally have experience of database performance tuning approaches
  Job Types: Full-time, Permanent

Benefits:

• Company pension
• Cycle to work scheme
• Enhanced maternity leave
• Enhanced paternity leave
• Free parking
• Health & wellbeing programme
• Life insurance
• On-site parking
• Private medical insurance
• Referral programme

Schedule:

• Monday to Friday

Work authorisation:

• United Kingdom (required)

Work Location: In perso

• Work with users and other members of the global project team to fully understand new requests, including eliciting requirements from end users for small changes
• Build Power BI datasets/dashboards/visualizations per specification provided by both project delivery teams and ad hoc requests
• Ancillary systems development (e.g., queries/reports/user tools/interfaces) based upon internal/external requirements – especially where it relates to Power BI builds
• Adhere to in-house design principles and ensure the data model maintains cardinality and data integrity
• Validate report output against source systems/reports and analyse/compare data between systems or from users (manual) to ensure model robustness
• Consider design approaches to convey KPIs and increase adoption
• Work with data engineering team to deploy data model changes
• Consider how data will be consumed and where applicable create a few proof-of-concepts and select the most widely accepted for production
• Periodically review the overall data model, table joins, as well as any identified pockets of poor performance
• Provide internal communication of new features
• Identification of opportunities to enhance/reengineer systems
• Support stakeholder training and adoption
• Ensure collaboration with other SEKO regions when delivering modelling changes and report designs