Lead Power BI Developer

at  dotdigital

ABOUT US

The Company: Dotdigital is a thriving global community of passionate, dedicated professionals, committed to the collective success of the organization and its clients. Our core principles of innovation, teamwork, and client-focused solutions drive us to approach challenges with a growth mindset and take ownership of our work. At Dotdigital, collaboration and curiosity pave the way for meaningful connections and learning opportunities with diverse peers. Our work environment encourages knowledge sharing, fosters exploration, and cherishes creative ideas. Combined, these guide us towards a shared vision in which brands around the world exceed customer expectations through the adoption of responsible marketing practices.
The Product: Dotdigital is an all-in-one customer experience and data platform (CXDP) that empowers marketing teams to exceed customer expectations with highly personalized cross-channel journeys. With Dotdigital, marketers can seamlessly unify, enrich, and segment customer data. Breaking down data silos, Dotdigital streamlines decision-making and paves the way for marketing creativity that delivers customer engagement at scale. With powerful AI capabilities, Dotdigital makes it easy to automate deeply personalized experiences across web, email, SMS, WhatsApp, chat, push, social, ads, and more.

ABOUT YOU

To be successful in the role, you must have an appreciation for our team values:

• We respond with a positive, can-do attitude
• We take ownership
• We collaborate, communicate and enable each other
• We are innovators
• We make things scalable, repeatable and robust
• We digitalise and eliminate manual processes
• We care about data quality (a lot!)
• We always operate with integrity
• We celebrate quick wins and our success
• We have fun!

We are also looking for candidate to meet the following:

• Problem solving and good analytical skills
• Attention to detail
• A passion for all things BI
• At least 3 years experience in a similar role
• Experience working in a SaaS company
• Strong understanding and experience of reporting needs for commercial teams in a SaaS company.
• Strong knowledge of Microsoft Dynamics
• Experience creating robust data models in Power BI, including writing DAX
• Experience ingesting data & performing data transformations using Power Query (including M Language)
• Experience using SQL to write queries, create SQL Views
• Strong analytical skills & a problem solver
• Knowledge of and experience with Power BI Dataflows
• Knowledge of and experience with Power BI Distribution/Security
• Knowledge of and experience of Power Apps and Power Automate

ABOUT THE ROLE

This is an exciting opportunity to join the newly formed Business Operations team here at Dotdigital. With a strong focus on being bold and getting stuff done, you will be joining at a pivotal moment where you can put your own stamp on things. Utilising your knowledge of data best practices and strategy and years of Power BI experience, you will be able to hit the ground running with some truly business changing projects which will make a huge difference to how we report and operate within the SaaS space. Pulling data together from a variety of data sources you will be able to directly impact our go to market strategy, customer adoption and retention as well as reporting on our financial success.
You will be responsible for designing and transforming data into business information through interactive dashboards and reports. You will serve as an evangelist for predictive analytics, employing innovative methods to draw insights from data and showcase the art of the possible with thought-provoking visualisations.

Main responsibilities include:

• Develop strong relationships with the business and key stakeholders to ensure analytics support provided reflects business needs.
• Convert business requirements into technical specifications and implement them through reports that support decision-making.
• Utilise your extensive experience of the reporting needs of SaaS commercial teams to define standardised reporting packs across the business.
• Implement data quality improvements across all departments to increase confidence that data can be used to inform decision making.
• Continuously seek opportunities to enhance data quality and reliability of data.
• Design, develop and deploy reports and dashboards in Power BI using multiple data sources.
• Develop Power BI Premium models with dimensional modelling techniques.
• Develop consistent documentation for data products – eg: Data Dictionary.
• Manage and coach an existing PowerBI developer, identifying training and growth opportunities.
• Provide Power BI training and develop training materials for end users.
• Deliver services and data products as part of the Power Platform using the suite of Microsoft’s PowerApps.

To be successful in the role, you must have an appreciation for our team values:

• We respond with a positive, can-do attitude
• We take ownership
• We collaborate, communicate and enable each other
• We are innovators
• We make things scalable, repeatable and robust
• We digitalise and eliminate manual processes
• We care about data quality (a lot!)
• We always operate with integrity
• We celebrate quick wins and our success
• We have fun