SQL Analyst

Job Description

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 have a rich data landscape at our fingertips; this role is a key advocate in its practical use and constant exploration to benefit marketing effectiveness.

• Develop SQL queries to extract and manipulate data from our Big Query 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.

• 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 Big Query or other data warehousing platforms.

70,400 USD to 98,533 USD#LI-SC

Remote, NJ, USA

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