Data Analyst - Power BI Specialist

Wiley • Hoboken, NJ

4d

About The Position

We are seeking a highly skilled and experienced Data Analyst with Power BI Specialty to join a dynamic team of marketing analysts in driving forward our mission to transform business and ad tech data into valuable marketing insights. As a Data Analyst / Power BI Specialist in the Wiley Marketing team, you will play a crucial role developing strategically important shared data models for reports that influence strategic decision-making, shed light on campaign performance, and ensure the success of our publishing initiatives. We’re looking for a methodical, future-thinker, who can support and guide others in the team to do the same. We have rich data landscape at our fingertips; this role is a key advocate in its practical application to benefit marketing effectiveness.

Requirements

• 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.

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.

Benefits

• We offer meeting-free Friday afternoons allowing more time for heads down work and professional development, and through a robust body of employee programing we facilitate a wide range of opportunities to foster community, learn, and grow.
• We are committed to fair, transparent pay, and we strive to provide competitive compensation in addition to a comprehensive benefits package.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed