We're a fast-growing lead generation firm who are part way through implementing Power BI to replace Excel/Google sheets reporting systems. We have an internal staff member who is leading the project, who has a decent understanding of Power BI but lacks the experience to create the more complex Power Query and Dax commands.
We seek a commercially astute freelancer who can work at least 5 hours per week, between 9am-5pm Wednesday to Friday GMT to enable team collaboration. However we're actively looking to grow our team in the coming months - so if everything goes well, and you like our passion and ethos, there is every possibility that this could become a permanent role with higher weekly hours.
Ideally you will have experience in the lead gen, digital marketing, or CRM space so you have a basic understanding of how we track our product (lead) through its lifecycle. This is not essential.
Under direction, you will provide specific Power BI expertise, including but not limited to:
- Offer advice on the Data Source connection/sync based on your past experiences: - GSheets v's .csv v's third party sync - Replicate dataset pivot actions currently performed in Excel in Power BI to reduce the pre-BI preparation currently undertaken - Custom DAX measures to display averages of dynamic totals in a Matrix visualisation (as opposed to an average of each individual instance in matrix column/row) - Custom DAX measure to display matrix data as percentage of column total (not grand total) rather than sum - Workshop and implement a process for the management of maturing data. - The aim is to replaced previously received product data with new data based on business rules (i.e. length of useful historical data will differ between clients) whilst being able to track the maturity with a specific 'days since sale' column (or similar) - Review existing BI Reports and provide advise on best practice to optimise for speed and accuracy - Review custom date table and data model and offer opinion on robustness
As we have intermediate Power BI skills in the team already we are seeking an expert so please only apply if you are comfortable with the above calibre of tasks.
Applicants with a highly developed commercial grasp will be well regarded.
*Pay*
We will offer a fair hourly rate based on your experience and needs. It's not fixed, can be negotiated and even increased with good performance.
