Job description
Whilst powerful, impactful KPIs are hard to find, the insightful data is extremely valuable to powering our customers’ solutions and decisions. We have a fantastic opportunity for a Power BI Engineer to help us overcome the challenges inherent in delivering standout dashboards and report suites.
This is the ideal position for a data-driven, inquisitive, and investigative individual who thrives in finding pragmatic solutions.
Your role in the team…
- Creating new or updating dashboards and interactive visual reports using Power BI…
- This may include custom charts, calculations, and measures for any need. Usage of non-DAX languages, such as, R & Python may be needed (training provided)
- Managing and maintaining the creation, publishing, efficiency, and security aspects of Power BI Reports during delivery
- Modelling data within Power BI according to industry best practices
- Creating query processes to ingest data effectively from various SQL/NoSQL data sources
- Shaping KPIs in a manner which is easy to understand, clear to view, and effective for data-driven stories
- Designing and developing complex calculations in DAX which are accurate and performant on datasets
- Understanding the data flow and lifecycle for clients and articulating stages and changes in data to help BI teams
- Analyse current ETL processes and define new target processes
- Documentation of delivered solutions
- Continuous learning…
- Keeping skills up to date, including keeping abreast of the industry and working towards Certifications pertinent to the role
What we need from you…
Must-have skills and experience
- Significant experience with Power BI and data visualisation
- Some knowledge and experience with Azure native data services, for example, Synapse, Azure SQL, or Data factory
Desirable skills and experience
- Strongly favouring certification
- Understanding of IaaS, SaaS & PaaS services in the cloud
- Other knowledge
- Experience in working with SQL databases and data warehouses (ETL/ELT) for BI purposes.
- Knowledge of other Power Platform tools and the Dataverse.
- Coding - Python or equivalent programming language sufficient to enhance an existing script to ingest data from Excel into SQL Server and also Power BI
- Experience in using SSRS for reporting and SSAS for data modeling (Tabular or Multidimensional)
- Experience with DAX and MS SQL
- Ways of working
- Experience with dealing directly with stakeholders and customers
- Agile way in working and delivering projects, with knowledge and exposure of managing project task backlog using Azure DevOps (ADO) or similar tools (Jira, Microsoft Planner)
- Experience in gathering and refining requirements in enterprise environments.
Why work for ANS?
At ANS, we’ve created a place where everyone can be themselves, and we empower our people to get the job done. Openness, ambition, honesty, and passion are what drive us every day. We are bold, courageous, and innovative – and we do it like no other. We invest in our people. In training, development, health and more – we give you the benefits and flexibility to maintain a happy work-life balance.
We’re proud of the inclusive, fun, dynamic environment we’ve created. It’s a safe space that works for all. You don’t have to be a techie to work in tech. Bring your authentic self and find your dream role here. Find out more at LinkedIn pages.
What’s in it for you?
With fantastic benefits, an inclusive culture, and a cool office space, we’re your kind of workplace.
Company benefits
- As standard: 25 days’ holiday, plus you can buy up to 5 more days
- A little extra: we’ll give you your birthday off, and an extra celebration day for whatever you want! Tying the knot? You get 5 days’ additional holiday in the year you get married. Oh, and 5 volunteer days!
- Private health insurance
- Pension contribution match and 4 x life assurance
- Flexible working and work from anywhere for up to 30 days per year
- Maternity: 16 weeks’ full pay, Paternity: 3 weeks’ full pay, Adoption: 16 weeks’ full pay
- Company social events – get ready for a jam-packed calendar
- Electric car scheme
- 12 days of personal growth development time
ANS are an equal opportunities employer. We encourage diversity and anyone applying for a role at our organisation can be assured that their application will be treated fairly, regardless of age, disability, gender reassignment, gender expression, marriage and civil partnership, pregnancy and maternity, race, religion or belief and sex or sexual orientation. We sometimes ask for information relating to individuals for equal opportunities monitoring purposes only.