We are looking for a BI Developer – Integration and Applications to be integral part of the business intelligence function. If you have a passion for using data, here you will be part of a culture where data and analytics are the foundation for a solid decision-making process.
Responsibilities for the role will evolve but will likely include:
- Design, build, deployment and maintenance of business intelligence applications, database and reporting solutions.
- Build and Manage C# Applications using EF and Design Patterns
- Build and Use Rest API or Web API’s to integrate various systems.
· Design and Develop secure and highly maintainable solutions and integrations using with Azure functions, Web Apps, Services, APIM, Azure Event Grid, Logic Apps
- Creation of specialised and tailored code to expand our global Data Warehouse using SSIS and streaming technologies.
- Provide support as required to ensure the availability and performance of company Business Information data and reporting.
- Collaborate with teams to design integrated systems and data pipelines (eg auto loading POS data to ERP)
- Implement end-to-end data analytics solutions (from data ingestion through visualization) for large-scale, complex data ecosystems
· Build Datawarehouse solution using Azure Integration Services - Azure Logic Apps, Azure Functions, Azure Data Factory, Azure API management, Event Grid and Micro Services.
- Work with complex Data Models and translate into ETL ingestion pipelines for Data Warehouses and Data Marts.
· Design, development of REST API’s over multiple formats like XML, JSON and associated transformations
- Design/Update Tables, Views, Stored Procedures
· Deliver front-end solutions in Blazor/React
- Analyse data and confidently present findings and insights.
- Design Tables, Views, Tabular Cube Measures, Calculated Measures, Dimensions, Dimension Hierarchies for Reporting
- Design and developing data reconciliation & metadata driven data processing frameworks.
· Aid and support the Business Intelligence Manager and Senior Developer to version and support modern ETL systems using cloud-based tools and connectors
· Provide ongoing development and support as required to ensure the availability and performance of company Business Information data, systems and reporting.
- A positive and collaborative approach to problem solving
So if you have:
- Tertiary qualification in computer science or relevant field with a strong academic record
- At least 5 years of experience in ETL, Advanced SQL.
- Good understanding of SOLID principles, design patterns and dependency injection
- Experience in developing solutions using Web API's or Restful API's.
- Recent hands-on experience with Azure Integration Services - Azure Logic Apps, Azure Functions, Azure Data Factory; Azure API management, Event Grid and Micro Services.
- A good understanding of different integration patterns such as messaging, pub/sub, ETL and APIs, and how to implement them;
- Previous DBA experience (preferred).
- Demonstrated, recent experience with design and development of SSIS ETL;
- Demonstrated and recent hands-on experience with SSAS Tabular Cubes and DAX queries or Power BI;
- Strong data modelling concepts, ability to design and deliver greenfield Data Warehouse projects.
- Experience applying enterprise integration patterns using SOA, API’s, Microservices, message-based, and file-based approaches.
- Functional knowledge of Azure DevOps Services including Azure Repository and Azure Pipelines for CI/CD;
· Experience or high degree of familiarity with integration technologies locate in Microsoft Azure and Dynamics 365 platform such as common data services
- Excellent technical skills with Microsoft BI stack (SSIS, SSAS, SSRS) and Advanced SQL (customized queries, automating scripts, ensuring job completion, resolving errors).
- Previous experience of ETL tools, data warehouse design, data modelling and visualization.
· CMS and mobile development experience are advantageous, but not mandatory: Umbraco
- Excellent written, communication and interpersonal skills with an ability to articulate and describe technical solutions in a clear business context.
- Innovative thinker with the ability to learn new concepts quickly
Comments
Post a Comment