St. John’s established in 1870, has three New York City campuses; international locations in Rome, Italy; Limerick, Ireland; and Paris, France; and study abroad locations around the world. The Princeton Review and other top rankings consistently recognize the University’s outstanding academics, diverse student body, dynamic internship and volunteer opportunities, focus on student life, and diverse study abroad offerings. St. John’s University offers more than 100 undergraduate and graduate programs in its six colleges and schools, with a growing number of programs offered online. The University is accredited by the Middle States Commission on Higher Education and 12 other major academic and professional associations.

A dedication to diversity, equity and inclusion is at the heart of our mission. As a Catholic and Vincentian university, St. John’s is committed to institutionalizing practices of inclusive excellence to ensure that we welcome and celebrate the intrinsic worth of all members of our community. We will become an even stronger university as we enhance equity at every level of our institution. Our graduates will excel in the competencies and values required for leadership and service in a rapidly evolving world.

Title: Junior Data Engineer

Department: Office of the Provost

Reports to: Chief Data Officer

Campus: Queens

Description:

The Chief Data Officer is looking for a Junior Data Engineer to join the Office of the Provost to assist with a variety of data related activities. This role will primarily be responsible for managing and developing data sets and products along with the quality and cleanliness of the data lake and warehouse. Further, the Junior Data Engineer will assist with the upkeep and quality of the universities Data Lake and Data Warehouse. The Junior Data Engineer will also help assist with in the identification, analysis, and dissemination of business data and logic into usable tables, views, and products to be consumed by the institution.

Responsibilities include but not limited to:

Use an analytical mind to assist with in translating business questions and concerns into views and data sets for entire university. Own and assist with the development of data sets and data stores that will be key in the development of data products and reports.

Assist with the synthesis of critical data in a format that is immediately useful to answering specific questions or improving operational performance. Explore/analyze data and work with Research Engineers, other Data Engineers, and Product Managers to understand behaviors, spot system defects, and benchmark our ability to serve our students.

Using past experiences, deep dive into our data assets to discover and fix anomalies, build meaningful views and data sets that would provide insight and valuable decisions for senior member of the team. Assist with the development of SQL stored procedures, views, jobs and other data products that will feed our dashboards and other data products.

Qualifications:

• A bachelor’s degree in data science, statistics, or a closely related field.
• A minimum of 2 years' experience with hands-on SQL Development.
• Ability to collect, analyze and present data in a cohesive manner.
• Ability to work collaboratively with other team members, staff, administrators, and other stakeholders.
• Strong and effective organizational, time management, and interpersonal skills.
• Ability to handle multiple projects simultaneously.
• Be able to master higher education-specific data sets.
• Advanced knowledge of data lake and warehouse environments.
• Ability to perform analyses on complex and disparate data sets.
• Fluency with data visualization platforms such as Tableau, Power BI or other data presentation layer tools.
• Database Administration (Oracle, MS SQL, NoSQL) platforms.
• Knowledge of Snowflake and Snowflake development a big plus.
• Advanced level SQL development skills.
• A keen eye for details and aptitude for working with multiple types of data.

In compliance with NYC’s Pay Transparency Act, the annual/hourly salary range for this position is $74,300 - $90,000 . St. John’s University considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as market and organizational considerations when extending an offer.

This position may be relocated to any of St. John’s University’s physical locations at any time.

St. John’s offers a competitive compensation program which is commensurate with your qualifications, experience, and contingent upon the departmental budget. We also offer an extremely comprehensive benefits program to meet the diverse needs of our workforce. Along with exceptional benefits such as medical, dental, life insurance, long term disability insurance, tuition remission, generous 403(b) employer contribution, employee assistance program, and liberal paid time off policies, faculty and staff can also enjoy St. John’s performing arts, libraries, bookstores, dining facilities, campus recreation and sporting events

Any offer of employment is subject to receipt by St. John’s University of satisfactory references, verification of employment and education.

St. John’s University is an Equal Opportunity Employer and encourages applications from women and minorities. All qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, or any other characteristic protected by law.

Required Skills

Required Experience