Database and Reporting Developer
Technology is reinventing higher education and at OCAS we play a vital role in helping shape this evolving landscape. We deliver dependable technology systems and business services to support our industry partners and create new pathways for learners exploring and applying to Ontario’s public colleges.
Recently named a Waterloo Area Top Employer for the ninth consecutive year, we’re looking for innovators who can bring their expertise and passion to our growing team.
At OCAS, we’re looking for a passionate and experienced Database and Reporting Developer to join our team in a hybrid role, combining responsibilities as a SQL database developer and Power BI developer.
In your role as Database and Reporting Developer, you’ll be a member of the Data Solutions team, working with and reporting to the Team Lead, Data Solutions. With well-developed problem-solving abilities, you can organize and manage multiple priorities, meet deadlines, and work well under pressure. A confident self-starter with excellent interpersonal and communication skills, you’re most comfortable working with peers across the organization to deliver high-quality data solutions.
As a member of the OCAS team, you’ll work with remarkable individuals and teams who support each other in achieving high performance.
Why OCAS?
- We offer a hybrid work environment that gives you the flexibility to work in our Guelph office, remotely, or a combination of both.
- Your team is passionate about technology and encouraged to explore new ways of working.
- You’ll start off with 22 vacation days, as well as paid company breaks in the summer and during the holiday season.
- We offer a corporate pension plan to help you prepare for your next stage of life.
- We provide generous benefits that include vision and dental care, extended health care, life insurance, and more.
- We understand the importance of lifelong learning, with a generous professional development allowance, as well as other initiatives to help you ‘skill up’.
- We support several local charities and offer paid time off to volunteer in your community.
In this role, you will:
- Develop the technologies and services that deliver data to internal and external data analysts through SQL and Power BI Solutions
- Develop MS-SQL and Stored Procedures
- Participate in a cross-functional team with members from our Product Management, Software Development, Project Management, and Testing teams to successfully deliver data solutions in an agile development environment
- Generate data sets from disparate data sources, automating both their creation and data quality and integrity checks
- Interact with stakeholders and present the findings
You should have:
- A diploma, a degree, or broad experience in data science, computer science, or software development
- 3+ years of experience as a database and reporting developer
- Hands-on experience with database programming languages (e.g., T-SQL, PL/SQL) and database development tools (e.g., SQL Server Management Studio)
- Write and optimize SQL queries to retrieve and manipulate data efficiently
- Experience in transforming raw data into meaningful insights through data visualization and analysis
- Code and release management tools such as GitHub, Azure DevOps, or similar
- Strong MS Excel skills, especially using pivot tables, macros, and ODBC data sources
- Experience building and deploying data solutions to the Azure Cloud using Data Factory, Data Lake, and SQL Managed Instances
- Familiarity with data preparation tasks such as data cleansing, transformation, and aggregation using Power Query
- Experience in implementing row-level security (RLS) and role-based access control (RBAC) in Power BI solutions
- A resume that includes the word "chocolate" to demonstrate your attention to detail
Nice to haves:
- Experience with natural language processing tools and techniques
- Understanding of Ontario's post-secondary education system
- Understanding of open data systems, particularly in education and government
- Understanding of the concepts of data governance and knowledge management
- Writing and presentation experience with an ability to convey technical and statistical information to a non-technical audience
Salary: $75,000 – $90,000
Position Reports to: Team Lead, Data Solutions
OCAS is committed to fostering a diverse and inclusive workplace. We welcome and encourage applications from diverse candidates, including people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. While we thank all respondents for their interest, only those candidates being invited to interview for this position will be contacted.
