Systems Analyst, Data and Reporting

Acadia University is seeking an analytical collaborative and innovative Systems Analyst Data and Reporting to join our Technology Services team. This is an exciting opportunity for a data professional who enjoys transforming information into meaningful insights that support strategic decision-making across the University.

Working as part of the Data and Reporting team the Systems Analyst will play a key role in designing developing and maintaining the Universitys enterprise data environment. This position supports institutional reporting business intelligence and data integration initiatives by collaborating with stakeholders across campus to ensure reliable accessible and high-quality data.

As the Systems Analyst Data and Reporting you will:

• Design develop and maintain Acadias enterprise operational data store and data warehouse.
• Build and support enterprise data integrations using APIs ETL processes and other integration technologies to facilitate secure data exchange between enterprise applications databases and cloud-based services.
• Develop and maintain reporting solutions dashboards and business intelligence tools that provide timely and actionable information for academic and administrative decision-making.
• Collaborate with Business Analysts and functional leaders across the University to understand business processes identify reporting requirements and improve data quality and governance.
• Lead the integration of current and historical data from multiple enterprise systems into centralized reporting repositories.
• Create and maintain technical documentation system specifications data models and integration designs.
• Work with software vendors and external partners to implement and enhance enterprise solutions.
• Provide second-level technical support for data and reporting systems assisting Service Desk staff and end users with troubleshooting and best practices.
• Deliver user training and consultation to promote effective use of enterprise reporting tools and data resources.
• Stay current with emerging technologies data engineering practices and business intelligence trends while ensuring compliance with university policies and applicable privacy legislation.

• A degree in Computer Science Information Systems Data Analytics Software Engineering or a related discipline or an equivalent combination of education and experience.
• Experience designing developing and supporting enterprise data warehouses operational data stores reporting solutions or business intelligence environments.
• Strong knowledge of relational database management systems including Microsoft SQL Server PostgreSQL Oracle or MySQL with experience in schema design normalization stored procedures and SQL (T-SQL and/or PL/SQL).
• Experience with Microsoft SQL Server Integration Services Analysis Services and Reporting Services.
• Experience developing reports and dashboards using reporting and business intelligence tools such as Power BI Informer or similar platforms.
• Working knowledge of data integration concepts ETL processes APIs web services and data modelling principles.
• Programming experience with modern development practices including version control documentation testing and deployment. Experience with one or more programming languages such as Java JavaScript Python and PowerShell is preferred.
• Practical experience developing and supporting applications in both Linux and Windows Server environments.
• Demonstrated ability to create and maintain clear technical and end-user documentation.
• Strong analytical consultation and problem-solving skills with the ability to translate business requirements into effective technical solutions.
• Excellent organizational and time management skills with the ability to manage multiple priorities and competing deadlines.
• Excellent interpersonal and communication skills with the ability to collaborate effectively with technical and non-technical stakeholders.
• Demonstrated ability to work both independently and as part of a collaborative team.
• Ability to apply policies follow direction and exercise sound judgment when handling confidential information.
• A proactive adaptable and customer-focused approach to problem solving and continuous improvement.

For further information or to request a detailed job description please contact Elektra Papadogiorgaki at emailprotected.

Acadia University located in Mikmaki the ancestral territory of the Mikmaq nation is one of Canadas leading primarily undergraduate institutions. For more than 185 years Acadia has been providing students with a transformative learning environment that supports their success in life and career. Our graduates emerge with the tools required to be global citizens and community leaders. Acadias faculty and staff are key to our institutional success and share a strong commitment to our students by delivering an exceptional post-secondary experience. As a staff member you will be part of a community where innovation is encouraged and your ideas are valued.

Acadia is situated in the Town of Wolfville in Nova Scotias beautiful Annapolis Valley - just one hour from the city of Halifax. Wolfville offers residents an outstanding quality of life including an affordable cost of living vibrant dining experiences abundant recreation and a welcoming sense of community. It is is one of the fastest-growing communities in the province where people find the perfect mix of small-town charm and urban energy. Its a place that people love to live and those who do not live here love to visit.

To see more information on why Acadia is an employer of choice please visit our website at .

TO APPLY: To apply for this opportunity click on the Apply Now button and upload your cover letter resume and professional references.
Acadia University acknowledges that we are in Mikmaki the ancestral and unceded territory of the Mikmaq. This territory is covered by the Treaties of Peace and Friendship which the Mikmaq Wəlastəkwiyik (Maliseet) and Passamaquoddy Peoples first signed with the British Crown in 1726. The treaties did not deal with surrender of lands and resources but in fact recognized Mikmaq and Wəlastəkwiyik (Maliseet) title and established the rules for what was to be an ongoing relationship between nations. Acknowledging the land that we are on means that we are working towards decolonization across campus.

Acadia University is strongly committed to employment equity and diversity in the workplace and welcomes applications from racialized persons / persons of colour Black and African Nova Scotians women Indigenous / Aboriginal People of North America persons living with disabilities 2SLGBTQIA community members and others who may contribute to the further diversification of ideas. As part of your application you are invited to complete a brief Employment Equity Voluntary Self-Identification Form. This form is voluntary.

The University will provide support in its recruitment processes to applicants with disabilities including accommodation that takes into account an applicants accessibility needs. If you require accommodation because of a disability or for any other reason during the interview process please contact emailprotected.

Please be advised that only those invited for an interview will be contacted. The University reserves the right not to fill this position. A six-month eligibility list may be established from this competition to fill future vacancies for identical positions. All qualified candidates are encouraged to apply; however Canadians and permanent residents will be given priority.