Business Analytics Developer (CL)

What you'll do

Responsibilities

What you will be doing…

Reporting to the Senior Manager, Institutional Research and Effectiveness and as part of the Business Analytics Team, you will:

• Develop a strong understanding of business processes for Academic Operations & Planning, Institutional Research, Finance, and HR in order to be able to better support their Business Intelligence needs for the College through an understanding of how reports and information can enable them to perform their role more effectively.
• Analyze Information and reporting business requirements, explore and evaluate various options, develop prototypes using reporting and dashboard tools up front in the project life cycle thereby validating the requirements, eliminating ambiguity and providing early visibility to business on the final solution.
• Participate as a contributor in the design of the data warehouse data model.
• Assist in translating the business requirements to a design and build technical specification document that will drive the development activities.
• Work closely with the team in designing and developing reports, dashboards and implementing report security solutions.
• Participate and assist in User Acceptance testing, train users on usage of the tool and the solution.
• Provide production support of all reports and dashboards to ensure the availability and performance of developed reports and dashboards for customers.
• Working collaboratively with the team to perform administrative functions with our BI tools including Cognos BI, Microsoft Power BI, and Microsoft Fabric tools and capabilities. This will include setting up and maintaining report security, scheduled jobs, automated report delivery, and report migration between environments.
• Build and maintain collaborative relationships with Business Analytics Team members, Office of Learning and Transformation and Digital Innovation & Technology personnel and with business stakeholders.

What you'll need

Qualifications

Qualifications and Occupational Experience:

• The minimum educational qualification for this position is a relevant university degree or College diploma in an area such as Information Technology, Business Administration, Statistics, Computer Science or related field.
• This is an entry level position. While extensive professional experience is not required, candidates must demonstrate:an understanding of IT system development methodologiesexperience developing Analytics solutions specifically with Microsoft Power BIunderstanding of business analysis activities to gather required reporting and dashboard requirements
• Srong understanding of relational databases with hands on experience in SQL programming, specifically MS SQL Server T-SQL would be considered an asset.
• Proficiency with use of Microsoft Office applications including, Word, MS Project, Excel and Visio and other tools that facilitate documenting requirements and solution design.
• Knowledge of Administrative ERP systems (HR, Finance, and Student Admin) would be considered an asset.
• Experience with ETL development tools within Microsoft Fabric would be considered an asset.
• Knowledge of programming languages such as Python or .NET that could be used to leverage Cloud software API's to ingest data would be considered an asset.
• Strong understanding of dimensional modelling principles for data warehouses is a plus.
• You are comfortable working in a digital environment; you take responsibility for acquiring knowledge about advancing technology, and you are committed to using technology to create an exceptional student experience.

Relevant Skills and Knowledge:

• You demonstrate a commitment to inclusion, diversity, equity, accessibility and anti-racism.
• Possess a curiosity and interest in data and analytics.
• A positive, self-starter that will seek out opportunities to learn and add business value to the Analytics team and the organization.
• Ability to translate business requirements to develop report prototypes that lead to business buy-in and refinement of the final deliverables.
• Experience gathering and documenting detailed business requirements for reporting solutions.
• Excellent Analytical skills and strong attention to detail.
• Excellent communication skills and presentation skills.
• Excellent interpersonal and collaborative skills.