Job Title
Senior Business Intelligence Developer
Job Description Summary
The GOS Global Technology Service group, is a team of dedicated IT consultants, project managers and business analysts that support our client technology solutions through best-in-class software systems utilizing a service delivery model to deliver value within a clear, consistent and measurable framework. Additionally, we provide assessment, technology roadmap, transition and integration services as well as a continuous improvement-based support model to ensure an ongoing technology investment for the duration of our client relationships.
In support of Global Occupier Services, our team also provides business development support including solution definition, pricing, technology demonstration and delivery for Strategy and Portfolio Administration Services, Transaction & Project Management Transaction, Facilities Management, Space & Occupancy, and Financial Management.
Job Description
Core Responsibilities:
We are looking for an experienced BI Developer to help build and improve a global BI platform built primarily on the Microsoft stack in Azure. You will use your data modelling, DAX and M coding, data analysis and report design skills to create, maintain and enhance our reporting platform as part of a structured software development lifecycle. There will also be an element of requirements gathering and documentation around building new solutions and enhancing existing ones. Ultimately, you will help develop end-to-end BI solutions using Power BI, which include Data modelling, Power Query and report development, to ensure company information is presented securely and accurately.
1. BAU BI platform support â“ troubleshoot and fix data model issues; such as complex business logic implemented in Power Query (M) and/or calculations in DAX. Resolving other issues with existing Power BI reports, SQL views and daily data refreshes in the semantic layer are also part of BAU
2. Reporting platform support and development â“ create and enhance Power BI dashboards and several tabular models as part of planned platform development projects and activities. There is also an element of enhancing and supporting the Power BI embedded portal.
3. Transition Management â“ support the technology components of new client on boarding to include such items as building and testing objects and measures in dashboards and tabular models, etc.
4. Client Project Services â“ carry out technology project related activities to include such items as requirements capture, business rule specification, dashboard and tabular model design, change management routines in Azure Analysis Services and Power BI
5. Collateral development â“ in supporting the BI solutions the role includes activities such as documenting the new implementations and changes in the dashboards to be able to compile for multiple IT and Business standards
Key Performance Indicators:
⢠Development of robust and scalable BI solutions
⢠Delivery to deadlines
⢠Internal and external client satisfaction
⢠Development as per best practice guide
Knowledge & Experience:
⢠3 - 5 years solid Power BI development experience and working with Power BI must have been in a recent role
⢠Must have excellent knowledge of the DAX and M programming languages, data model development and report design and implementation experience.
⢠Hands-on experience designing and implementing tabular models (Power BI or Azure Analysis Services)
⢠Ability to write T-SQL code to query databases
⢠Experience with precise requirements gathering and documentation; which can used to create high-level and low-level design documents for developers
⢠Routine use of source control (example Git), as part of regular BI development activities. This includes branching strategy and CI/CD principles.
⢠Familiar with the use of DevOps to track progress on assigned tasks within a sprint
⢠Excellent communication skills and the ability to create and maintain technical documentation
⢠Experience with front-end development using languages such as JavaScript
⢠Some experience with ETL tools such as Azure Data Factory and/or SSIS is important
Nice to have:
⢠Tabular model development and deployment tools such as Tabular Editor, DAX Studio and ALM Toolkit.
⢠Tabular model performance tuning, partitioning and optimisation experience
⢠Test-driven BI development using a testing framework
⢠Report development experience with other software such as Tableau
⢠Involvement with BI community activities or news groups
⢠Programming with Python and/or R
Qualifications
⢠Degree in IT or Mathematics
Skills & Personal Qualities:
⢠Forward Planning: precise estimation of completion time and resources required on development tasks
⢠Data Security awareness: Always be mindful about data security
⢠Delivery Focus: retains a strong focus on high standards delivery, despite constraints or setbacks
⢠Change Orientation: responds and adapt positively to dynamic work environment
⢠Team Bonding: establishes and nurtures harmonious relationships both externally and internally.