We are looking for a BI Developer who will play a key role in the evolution of this new company’s growth, given its start-up nature, you will see the impact your work is having on the wider business. This role is truly well-rounded with responsibilities including database maintenance and improvement, stakeholder interaction and report/dashboard production, refining and developing BI systems and report migration.
Responsibilities:
Responsible for defining, delivering high quality scalable and maintainable Data Warehouse and BI solutions to meet business objectives
Provide expert guidance on BI skills and the latest Microsoft BI tools and technologies
Develop security and authentication standards
Perform performance optimization, maintenance and troubleshooting activities on all aspects of the Azure Data Platform
working with a highly evolved and complex data warehouse which refreshes automatically every day from a large variety of clinical and non-clinical data sources. Working on routine maintenance tasks for updates to the data warehouse and other development and documentation tasks
Design and develop Global Reports and Analytics using modern data visualization tools
Understand and prioritize business requirements while managing the expectations of stakeholders
Visualize and present Global Analytics to key stakeholders to identify areas of opportunity
Define and advocate analytics best practices in the areas of data modelling, data wrangling, data visualization and data storytelling.
Required Qualifications:
SQL: you should have advanced skills in T-SQL querying and have a good conceptual understanding of the T-SQL language and its logic.
Experience in full life cycle BI projects, from consulting and needs analysis gathering through to development and delivery. With proven design, delivery and deployment experience of Business Intelligence projects.
Extract Load Transform: Data extraction and transformation is a large part of the role. Strong extract transform and load skills, with the ability to summarize and prepare data to feed BI models using PaaS services on the cloud.
Data modelling: AAS (Azure Analysis Services) or Power Query in Power BI experience is essential with a high level of proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area.
Ideally the candidate would have experience in creating data services such as SQL databases or data warehouses on PaaS offerings
Power BI Reports and Gateway: Experience installing, maintaining, and provisioning gateways across multiple geographical regions. Power BI report building using bookmarks and selection. Knowledge of Power BI online services including report schedule, endorsement and discovery and data source credentials
DevOps in Azure: Build and release experience using yaml files and ARM templates
Code and programming languages: T-SQL, DAX, JSON, and Power Query M formula language
Skills Set:
4 years of T-SQL and MS BI Stack (SSIS, SSRS, SSAS) experience
4 years of Azure Azure AAS, Power Query and DAX experience
3 years of TFS/Azure DevOps
3 years of Power BI experience
1-2 Years Data Migration project experience