Power BI Consultant

At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It’s why we’re coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we’re headed. We’re proud to share our story and Make Amazing Happen at CDW.

 

CDW has a mission to become the leading B2B integrated technology solutions provider in the markets that we serve. Enabling, supporting, and accelerating our ambitious plans to grow rapidly by understanding the needs of our business customers, partners & co-workers through redefining & optimizing our data and information and supporting the changes in operating models, modernization and business systems.

CDW UK’s Enterprise Data team is responsible for driving and accelerating Data, reporting and analytics use, understanding and transformation across people, process, and systems.

Simplistically put its role is to:

  • Provide meaningful and clear metrics to measure, support and predict business activity.
  • Drive change initiatives to ensure best practice and value focused outputs.
  • Ensure clear governance, security and protection of data, its use and meaning.
  • Evolve the way of thinking and activity to being a data driven organization

As Enterprise Data continue to roll out our data and analytics platform, and we are looking for an expert to join a growing team to support the data journey. You will have the knowledge and skills to understand business requirements, work closely with senior stakeholders to become and be recognized as an SME within the business, build / develop analytics and insights to add critical business value so we can make informed business decisions.

The job is varied but here are some of the things you can expect to drive and be involved in:

  • Business Analysis
  • Conduct thorough investigations, document findings, and collaborate on optimizing processes, systems, and methodologies.
  • Strategically define problems, evaluate solutions, and present well-considered recommendations.
  • Engage with stakeholders to identify key objectives and drive the realization of business benefits.
  • Cultivate a deep understanding of products, processes, and desired business outcomes.
  • Author comprehensive Functional Requirements and detailed User Stories for the Data Enterprise Team.
  • Perform advanced data analysis for field mapping and data type evaluation.
  • Facilitate estimation and strategic planning to transform requirements into actionable User Stories.
  • Serve in a quasi-project/product management capacity to ensure the delivery of successful project outcomes.

  • Data Skills;
  • Oversee the querying, analysis, and interrogation of data.
  • Develop comprehensive data profiles and assess quality metrics.
  • Manage and measure data cleansing and enhancement initiatives.
  • Establish and document controls, ensuring data quality and structure for all operations.
  • Architect data models for Power BI.
  • Facilitate testing processes, endorse user adoption, conduct training sessions, and manage communication strategies.

  • Technical Skills
    • Power BI platform expertise
    • Power BI modeling
    • Report & Dashboard building
    • MS Azure ADO & Data Bricks

Must Have:

  • A minimum of 3 years of experience as an Analyst in a data environment.
  • Proven ability to work with stakeholders to:
    - assess potential data insights
    - document data & definitions
    - define quality, security, and controls.
  • Experience in Data profiling and Quality measurement activities.
  • Experience in data cleansing.
  • Experience with ERP or CRM Solutions and ERP or CRM Data.
  • Expertise in Power BI and an in-depth understanding of how the Power BI Service and Desktop works.
  • Applying effectively the navigation features in Power BI (e.g., bookmarks, drill-through) to guide readers through a compelling data-driven story.
  • Ingesting data from a variety of sources and performing required transformations in the Power BI query editor using a mixture of utilizing the UI and writing M code.
  • Developing calculations in DAX which are accurate and performant on large datasets. Proficient in writing SQL, MDX and M.
  • Advanced tabular modelling and model administration via the XMLA endpoint, including knowledge of advanced tools, such as Tabular Editor and DAX Studio.
  • Data Modelling and a good understanding of Kimball methodologies.
  • Provide technical support and guidance through prototyping, testing, build, and launch of Power BI products.
  • Experience of good Source Control methodology ideally with DevOps Repos.
  • Experience of writing custom visuals.
  • Able to implement row level security on data and understand application security layer models in Power BI.
  • Knowledge and experience in prototyping, designing, and requirement analysis.
  • Undertaking data analyses to support decision making
  • Develop user manual / training documentation or videos.
  • Be a key member of the SCRUM team and create or contribute to, backlog refinement, story writing, sprint planning, demonstrations and retrospectives.
  • Interpret user requirements into technical requirements including complexity estimation, implement in sprint cycles, collaboration into process improvement, etc.
  • DevOps approach to software; create high quality code using traditional software practices, such as building, linting, unit testing, source control, CI/CD, peer reviews, etc.
  • High-level written and verbal communication skills.
  • Problem-solving skills
  • Accuracy and attention to detail.
  • Conduct interviews and facilitate workshops to capture functional and non-functional requirements and User Stories.
  • Working with teams to identify and recommend process improvements.
  • A demonstrable track record of getting stuff done whilst managing competing pressures and deadlines and retaining an eye for detail and quality.
  • A passion for technology and its ability to have a positive impact on business.

Nice to have:

  • B2B supply chain experience.

We make technology work so people can do great things.     

CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive.

CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law.      

Job Information

Related vacancies