SQL & Reporting Developer

at  Yorkville University

About Us:
We are looking for the visionaries, the change-makers, the self-starters who are seeking more from their career. Change begins with the small decisions we make, each day, to support each other and strive to create inspiring incredible educational experiences for all students, no matter where they are or how they learn. This concept connects deeply to the idea that, in choosing a career with Yorkville University, you will have the opportunity to push boundaries, flex your creativity and inspire positive change for so many people. It’s also a call-back to the transformative power of education itself. Seek a career that will challenge you to make a meaningful difference through work with a passionate, empowered team in an environment where your voice matters and your ideas are always important.
If you want to shine a light on academic excellence, be empowered to make an impact on the transformation of the Canadian post-secondary education landscape, and work collaboratively beyond levels, join us.
Who we need:
Reporting to the Director, IT Architecture, the SQL & Reporting Developer is responsible to build new SQL query, stored procedures and functions to support business requirements using SSRS, PowerBI and/or Tableau. Responsible for auditing and approving any externally developed code or integrations prior to implementation; primary expert with decision-making responsibility on all developed code and systems as well as code repository use and functionality.
This is a 7 month maternity leave contract.

What you will do:

• Build new SQL query, stored procedures and functions to support business requirements
• Develop new report objects to support both one-time and ongoing business requirements suing SSRS, PowerBI and/or Tableau
• Enable automated report generation and distribution for critical reporting objects
• Conduct a high-level audit of all existing custom reports in key platforms, including Anthology Student, Moodle, WordPress and FreshService systems
• Provide recommendations for improving existing custom reports, query, stored procedure and functions to increase security, stability and usability
• Implement approved recommendations with detailed test, release and rollback plans
• Build and maintain a reporting catalog based on that ensures data quality and governance
• Assist in implementation of change controls with respect to customized code, tied into code repository
• Develop query, procedure, function and report revisions on approved change requests
• Prepare test data, plan and conduct feature testing through UAT cycles
• Research, recommend and deploy a suitable code version management repository to house all custom SQL and report based code, objects and related documentation

What you bring:

• A degree in information technology, systems engineering or a related specialized area
• A minimum of 3 years of relevant experience in a data management and report development capacity
• Proven strength in Microsoft SQL, MySQL, MariaDB, SSRS and PowerBI environments
• Expertise in Microsoft SQL, MySQL, SSRS, PowerBI and Tableau
• Proficient with UI/UX design for dashboards and reports suited for consumption on web, desktop, mobile and distributable formats
• Proven strength in documentation and code/object repository management
• Experience with API integrations, ODATA and REST would be a strong asset
• Experience with other reporting systems, particularly related to SalesForce systems would be a strong asset
• Demonstrated experience in developing and managing custom report object repositories with version and release management

What’s in it for you:

We provide a transformative, accessible and flexible higher education environment, our team shares a passion for learning, teaching, and growing. We nurture an inclusive, supportive, and diverse work environment throughout our three campus locations.

• Health Benefits
• Dental Coverage
• Retirement Savings Plan
• Competitive Salary
• Fun, competitive, and challenging work environment
• Incentives and rewards
• Career growth
• Free Tuition for all Yorkville University Programs
• Employee and Family Assistance Program

What does the best of all worlds mean at Yorkville University:

• An atmosphere that successfully blends an entrepreneurial culture with education. We value innovation and continuously look towards expanding our programming, working with the latest research, tools, and solutions. As a private school with government approval of our offerings, we have the opportunity to do more, stay current, and be future-forward.
• The chance to accelerate your career and disrupt education by responding to the needs you see and purposefully challenging the status quo. Everything we do here is about delighting and engaging our employees - and ultimately our students- from mentorship to teaching, from creative outlets to analytical ones.
• A place where all individuals feel welcomed in the academic and workplace environments and can bring their authentic selves to the educational and work spheres. We celebrate the full range of human diversity, and we acknowledge that equal access to opportunities and services may require the removal of barriers that equity-seeking communities experience in trying to obtain this access.
• The opportunity to grow with access to free courses, certifications, and programs - right up to our Doctorate offerings.
• An appreciation for the insights and skills you bring to work with a competitive salary and comprehensive benefits, including a wide breadth of wellness services, and a work-life balance.

Join us:
We welcome and appreciate candidates with a range of backgrounds and experiences. If you have 70% of the qualifications we are looking for, express your interest now.
Diversity, equity and inclusion are a critical component of life at Yorkville Education Company and we are committed to making these values an integral part of our culture. We encourage applications from all qualified applicants, including women, persons with disabilities, Black, Indigenous, and People of Colour (BIPOC), people from the Lesbian, Gay, Bisexual, Transgender, Transsexual, Queer, Questioning, Two-Spirit, Intersex, Asexual + (LGBTQ2SIA+) community, and other equity-seeking groups.
Yorkville University is committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act (’AODA’). If you require accommodation for disability, please notify our People Team at 1-866- 467-0661

• Build new SQL query, stored procedures and functions to support business requirements
• Develop new report objects to support both one-time and ongoing business requirements suing SSRS, PowerBI and/or Tableau
• Enable automated report generation and distribution for critical reporting objects
• Conduct a high-level audit of all existing custom reports in key platforms, including Anthology Student, Moodle, WordPress and FreshService systems
• Provide recommendations for improving existing custom reports, query, stored procedure and functions to increase security, stability and usability
• Implement approved recommendations with detailed test, release and rollback plans
• Build and maintain a reporting catalog based on that ensures data quality and governance
• Assist in implementation of change controls with respect to customized code, tied into code repository
• Develop query, procedure, function and report revisions on approved change requests
• Prepare test data, plan and conduct feature testing through UAT cycles
• Research, recommend and deploy a suitable code version management repository to house all custom SQL and report based code, objects and related documentatio