SQL Analyst

Wiley

4d • Remote

About The Position

We believe in bold ideas, diverse perspectives, and the drive to transform knowledge into impact. Here, your curiosity fuels progress, your voice shapes innovation, and your ambition helps redefine what’s possible within science and learning. We are a culture that obsesses over impact, challenges, and drives what’s next to power infinite possibilities for our customers, colleagues and society at large. At Wiley, we welcome you for who you are, the background you bring, and embrace individuals who get excited about learning whether online or by book. Learning is for everyone, and so is our workplace. Bring your experiences, your perspectives, and your passion. It’s in our differences that we empower the way the world learns. We are seeking a highly skilled and experienced SQL Analyst 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 SQL Analyst in the Wiley Marketing team, you will play a crucial role developing strategically important datasets 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 validate and connect disparate data tables into valuable information for use in reporting and analysis. We have rich data landscape at our fingertips, this role is a key advocate in its practical use and constant exploration to benefit marketing effectiveness.

Requirements

• Experience (2+ years) in Data Modelling, Data Analysis, or similar.
• Demonstrated proficiency in using complex SQL queries to validate and manipulate large datasets.
• Strong analytical and problem-solving skills, with a focus on best practice and data governance.
• Strong data comprehension skills, capable of reviewing complex documentation and applying it to the requirements of reporting use cases
• Strong communication skills, with the ability to explain technical concepts to both technical and non-technical stakeholders.
• Experience with BigQuery or other data warehousing platforms.

Responsibilities

• Develop SQL queries to extract and manipulate data from our BigQuery database for use in Power BI semantic models and ad-hoc analyses.
• Update database structure to support star schema models consisting of fact and dimension tables, in close consultation with team lead and data engineering.
• Review documentation and define data requirements for new source data to communicate team needs and enable the data engineering team to build fit-for-purpose data pipelines.
• Test and validate new and existing source data to ensure accuracy of the foundational database and support the team’s position as a “Source of Truth” in a complex data landscape.
• Create and maintain documentation on the team’s database and dataflows to enable all stakeholders to understand, use, and communicate about the data the team provides.

Benefits

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

What This Job Offers

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