Data & Analytics Officer

Vacancy Status: Existing Vacancy Branch: Technology and Information Management Branch (TIMB) Employment Type: Temporary (Fixed Term), Full time Duration of Term: 18 months/mois Position Linguistic Designation: Bilingual (English, French) Position Global Linguistic Level: B2 Classification Level: Band 11 Annual Salary: $108,837.00 - $122,492.00 + $1,798.58 Bilingual Bonus Union: UNIFOR 2025 Location: Ottawa, ON Search Area: Internal, Membership, Public About the Public Service Alliance of Canada (PSAC) PSAC was created in 1966 and is a union that has proudly represented more than 245,000 workers across Canada and beyond. We stand up for fairness, equity, and better workplaces. We know our strength is in our people. Headquartered in Ottawa with regional offices nationwide, PSAC has led countless successful campaigns for workers’ rights and social justice. We believe in standing together and supporting the people who make our union work every day. For more information about our victories, please visit our website at https://psacunion.ca/ About the role Under the direction of the Manager, Data Solutions and Analytics and as a member of the Information Technology and Information Management Section, the Data and Analytics Officer (DAO) is responsible for developing and executing data strategy, governance and architecture, while leveraging the power of analytics and artificial intelligence (AI) to create an organizational advantage. The position oversees data management, system integration, governance, architecture, analytics and AI across all the Public Service Alliance of Canada’s data systems. What we are looking for Education & Experience: University degree in the field of computer science, mathematics, or statistics, or 8 years equivalent work experience in Data Architecture and Analysis. Demonstrated experience responding strategically and tactically to operational issues with innovative solutions including experience developing and implementing database solutions. Extensive experience with the programing languages: Python, R, VB.net, C#, SQL. In-depth experience with corporate Data Governance. Experience in data strategic planning and initiative designs to develop data strategies that fit in with both the long and short term and be readily adaptable. Experience implementing Data Analytical Systems utilizing historical and real-time data from multiple systems. Demonstrated experience in project management. Experience with data architecting, data mining, large-scale data modeling, and business requirements gathering and analysis of diverse user data and systems needs to develop solutions. Experience implementing data ecosystems with high data volume, high throughput, and various content structures Skills & Knowledge: Strong knowledge of current data privacy practices and laws such as PIPEDA and GDPR. Strong knowledge and experience with reporting tools such as Power BI, SSRS, Crystal Reports. Knowledge of Nintex workflow, Microsoft Power Apps and Microsoft Power Automate is an asset. Strong understanding of relational and non-relational data structures, theories, principles, and practices. (Data Lakes, NoSQL, CosmoDB, MongoDB, MSSQL, etc…) Advanced knowledge of Excel data connections, pivot tables and formulas. Understanding of Web services (SOAP, REST, XML, UDDI, WSDL). Abilities: Ability to anticipate, identify and understand data trends to be leveraged in management strategic decision making. Ability to communicate orally and in writing (according to the position’s requirements) with systems stakeholders and end-users as well as with technical specialists. Ability to work in a political organization with often competing priorities as well as a commitment to union and social justice issues. Personal Suitability: Excellent judgment and demonstrated problem solving, consultative, persuasive and conflict resolution skills to provide technical advice and guidance on complex data related technologies and process issues to all levels of users. What you need to know Second language skills as per the Common European Framework of Reference for Languages (CEFR) will be assessed. Valid federal SLE results may be accepted. A combination of education, experience, and demonstrated performance may substitute for formal academic requirements. PSAC welcomes applications from candidates with diverse and international experience. PSAC does not use Artificial Intelligence (AI) to screen, assess, or select candidates. Interviewed candidates will be notified of the hiring decision within 45 days of their final interview. While we appreciate every applicant’s interest, only those selected for further consideration will be contacted. A full job description is available on request. Please contact PSACStaffing-DotationAFPC@psac-afpc.com Why work with us Should you share PSAC's values and commitment, recognize the significance of the labour movement, and advocate for workers' rights, PSAC extends an invitation to join our team and actively contribute to a community dedicated to social justice, fairness, equity, and the well-being of workers. Below, you will find an overview of our comprehensive rewards and benefits package: Comprehensive group benefits — 100% employer-paid health, dental, life, and disability insurance, a health care spending account (HCSA), plus up to $7,500 per year for mental health services. Flexible work arrangements — with dedicated workstations for hybrid staff. Defined and secure pension plan — shared 50/50 between you and us. Three (3) weeks’ vacation to start, plus extra paid leave for appointments, moving, personal days, sick days, or whatever you need. Professional development support to help you grow. An annual recreation allowance of $800 because your wellness matters. Our commitment to employment equity PSAC is committed to building a workplace that reflects the diversity of our membership and the communities we serve. That’s a workplace that includes women, Indigenous peoples, racialized persons, persons with disabilities, and members of the 2SLGBTQIA+ community. We encourage applicants to self-identify in the application process to help us maintain an inclusive workforce. All information provided will be kept confidential. You may identify with more than one group (e.g., as Indigenous, as a person with a disability, and as a woman). False declarations may result in investigation or further action. If you need the application in an alternate format (e.g., large print) or require accommodation at any stage of the hiring process, please contact us at PSACStaffing-DotationAFPC@psac-afpc.com — we’re here to help. Ready to join the PSAC team? Internal candidates: Indeterminate PSAC employees who meet the qualifications may request a transfer under the relevant collective agreement. Active members of PSAC should provide their membership number to be considered at the membership level of the competition. Thank you for your interest in joining our team. Due to the high volume of applications we have received, we will only be contacting those candidates who have been selected to proceed to the next stage of the hiring process. Welcome to the PSAC Careers Page! Thank you for your interest in pursuing a career with the Public Service Alliance of Canada (PSAC). We're excited that you're considering joining our dedicated team of professionals who work to support and represent our members across Canada. Here, you’ll find information on current job openings, as well as the resources you need to submit your application.