SQL Analyst

SQL Analyst

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.

How you will make an impact:

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

We are looking for people with:

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

For more than 200 years, we've transformed knowledge into discoveries that shape the world. Today, our global team of innovators, creators, and experts is driving what's next in science, education, and publishing—creating impact that reaches everywhere.

We're not just observers of progress. We're the ones accelerating scientific breakthroughs, advancing learning, and sparking innovation that redefines entire fields and improves lives.

Here, your talent matters. Your ideas have room to grow. And your work creates breakthroughs that can change everything. Wiley is an equal opportunity/affirmative action employer. We evaluate all qualified applicants and treat all qualified applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, protected veteran status, genetic information, or based on any individual's status in any group or class protected by applicable federal, state or local laws. Wiley is also committed to providing reasonable accommodation to applicants and employees with disabilities. Applicants who require accommodation to participate in the job application process may contact View email address on click.appcast.io for assistance.

We are proud that our workplace promotes continual learning and internal mobility. Our values support courageous teammates, needle movers, and learning champions all while striving to support the health and well-being of all employees. 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. The range below represents Wiley's good faith and reasonable estimate of the base pay for this role at the time of posting roles either in the United Kingdom, Canada or USA. It is anticipated that most qualified candidates will fall within the range, however the ultimate salary offered for this role may be higher or lower and will be set based on a variety of non-discriminatory factors, including but not limited to, geographic location, skills, and competencies.

Salary Range:

73,400 USD to 102,600 USD