Note: The job is a remote job and is open to candidates in USA. Wiley is a global leader in science, education, and publishing, and they are seeking a highly skilled Data Analyst with Power BI Specialty to join their marketing team. The role involves developing shared data models, extracting data using SQL, and providing insights that influence strategic decision-making and campaign performance.
Responsibilities
- Develop and maintain shared semantic models in Power BI using star schema design
- Develop SQL queries to extract and manipulate data from our BigQuery database for use in Power BI
- Define and implement best practice report/data management through Microsoft Fabric integrations
- Review and maintain reports for performance optimizations, style consistency, and best practice improvements
- Consult on and support building a data model and structure that enables efficient and accurate reporting and analysis
- Consult on wireframe design during the early stages of building new reports to provide guidance on effective visualization and user experience
- Consult on the development of strategically insightful reporting dashboards with actionable insights to support key stakeholder decision-making processes
Skills
- Experience (4+ years) in Data Modelling, Data Analysis, or similar
- Demonstrated experience with Power BI, semantic models, and other Microsoft Fabric tools
- Demonstrated proficiency creating SQL queries to manipulate large datasets
- Strong analytical and problem-solving skills, with a focus on best practice and data governance
- Strong attention-to-detail, with the ability to organize and maintain datasets using meticulous, self-determined methods
- Strong communication skills, with the ability to define requirements and explain technical concepts to both technical and non-technical stakeholders
- Experience with BigQuery or other data warehousing platforms
Benefits
- Fully remote opportunity for candidates based in the UK or the U.S.
- We offer meeting-free Friday afternoons allowing more time for heads down work and professional development
- A comprehensive benefits package
- A robust body of employee programing we facilitate a wide range of opportunities to foster community, learn, and grow
Company Overview