Tagcor

SQL Server database SSIS SSAS SSRS Power BI SQL MDX DAX Azure

Working closely with clients, gathering requirements and translating them.

• Ingesting data from a variety of corporate data sources and performing required transformations in Power BI query editor

• Data modelling capabilities including designing effective BI data models in line with the Kimble methodology and CDM.

• Developing calculations in DAX which are accurate and performing on large datasets.

• Designing effective layouts using themes and report grids, working closely with our UX design team.

• Utilizing the navigation features in Power BI (e.g. bookmarks, drill-through) to guide readers through a compelling data-driven story.

• Working with our clients to manage User Acceptance Testing (UAT) processes and fixing any defects identified.

• Publishing reports via the Power BI service, managing them through distribution of apps and monitoring usage/data refreshes/security access.

• Shaping an approach for governance and deployment of Power BI in mid-size organizations

Key Skills Required

• 3+ years’ experience as a Business Intelligence developer using the Microsoft BI stack e.g. SQL Server database, SSIS, SSAS, SSRS, Power BI

• Very strong SQL skills for querying and creation of views/tables, functions and stored procedures

• Experience in designing ETL processes including knowledge of data warehousing strategies and theories

• Build dashboards, reports and cubes using SQL, MDX, DAX, Power BI or other visualisation tools

• Develop new or maintain and improve existing ETL processes

• Articulate and document architectural solutions and processes

• Attend technical and business meetings and act as a subject matter expert

• Establish and maintain collaborative relationships with stakeholders

• Understanding dimensional modelling ideally for Financial Services and Public Sector

• Knowledge of cloud computing, preferably on Azure