Job Search / Business Intelligence & Data Analytics

Data Engineer / BI Developer

Job Details

Job Type
Full Time
Kapil Arora
27 days ago
Our client is looking to appoint an experienced Data Engineer/Business Intelligence Developer to architect, design, build, administer, maintain and support all aspects of their Data Warehouse and System Integrations. The role will be required to provide subject matter expertise and guidance to business users to work with them to understand business requirements and incorporate these requirements into a Data Warehouse. 

Key responsibilities include:
  • Delivery of all aspects of Data Warehouses and System Integrations including architecture and design, tool selection, implementation, development, testing, administration and maintenance, support and troubleshooting.
  • Model the future state of the data and integration architecture and provide data and integration architecture best practices and guidelines.
  • Requirements analysis and preparation of functional and technical documentation.
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
  • Ensuring that the systems deliver consistently on the service-level agreement.
  • Manage the day-to-day running of the Data Warehouse and Integration systems, including enforcing policies, maintaining systems and responding to user requests.
  • Interviewing business users to understand the use cases that the data warehouse or integration solutions must support.
  • Provide advice and support for business and IT staff in how to best use the data structures and data design for Business Intelligence Reporting.
  • Provides advice to and collaborates with the broader IT team and external vendors to determine appropriate solutions.
  • Contributes to and develops business cases or other documentation that promotes and identifies opportunities for improvements.
  • Promote the use of Power BI throughout the business including the provision of training to business users.
Skills, knowledge and experience required:
  • Experience in all aspects of Data Warehouses including theory (Inmon, Kimball), architecture and design, tool selection, implementation, development, administration and maintenance, support and troubleshooting.
  • Advanced SQL, ETL, Data Modelling skills.
  • Experience and knowledge in System Integrations such as API Management, ESB, SOAP, XML.
  • Experience with using Microsoft SQL Server and Microsoft Power BI.
  • Understanding of dimensional modelling, snowflakes, slowly changing dimensions, irregular dimensions, and surrogate, compound and intelligent keys.
  • Ability to see the role of data models in supporting diverse use cases such as business processes, BI, data migration or master data management (MDM).
  • Experience with SSAS, SSRS will be beneficial, but not essential.
If this role is of your interest, please submit your CV by clicking the "Apply for this job" button.