Senior Database Analyst & Developer (Information Technology) (Remote)

The Conference Board of Canada (CBoC) is the nation’s largest independent applied research organization offering unbiased, evidence-based information and analysis to both industry, NGOs and federal/provincial governments. We have one of the country’s largest private economic analysis and forecasting teams and are widely recognized for expert economic forecasting, modeling, and leading analysis. CBoC undertakes research to address the most pressing issues in Innovation and Technology, Human Capital, Sustainability, Immigration, Indigenous and Northern Communities, Education and Skills, and Health. Our social science research provides actionable pathways to solutions. Simply put, we deliver insights that help Canada’s leaders cut through the noise and make informed decisions.

We are seeking an accomplished Senior Database Analyst and Developer to join the Information Technology team. In this role, you will lead the development of new and existing technology initiatives including day-to-day operations, transformation projects, continuous process improvements and optimization.

Our Ideal Candidate is… highly motivated, analytical and has entrepreneurial growth mindset, making you a natural in leading key activities, such as administering and supporting our databases, automating data integrations, maintaining data integrations between the applications, supporting 3rd party enterprise applications. You are exceptionally successful at troubleshooting and resolving issues. You constantly look for proactive solutions that ensure quality, efficiency as well as effectiveness. We are looking for someone who has had multiple success and played a key role in implementing best practices for performance, optimization and security of databases and enterprise level applications and have consistently demonstrated strong relationship management with clients and vendors. You enjoy new challenges and working in a collaborative, team environment.

We are a virtual organization and as a remote worker you must be comfortable and able to work 100 per cent of the time from a home office in Canada. To be successful as a remote worker you need to have a self-starter attitude, possess strong organizational and time management skills and be a proactive communicator. Having a home office environment that provides for a productive, professional, and safe work environment during regular working/business hours is a requirement of this role.

About The Role

Some of the things you will do every day:

• Maintain, monitor, and support databases and applications across all Microsoft environments.
• Provide technical administration and support for business-critical enterprise systems
• Produce and manage end-to-end solution design of data system current and future state.
• Lead the development of technical controls to ensure the security of databases and applications.
• Perform capacity planning, performance optimization, monitoring and troubleshooting
• Design and develop conceptual, logical and physical data models and data governance.
• Design, develop, test automations of application and database processes, tasks, and procedures
• Develop Integration scripts and utilize software development tools to design capabilities such as data import/export or similar data migration routines.
• Design and implement database and application backup/recovery procedures following ITIL.
• Work with the lines of business to identify application and database requirements through evaluation providing practical recommendations for proposed systems.
• Commitment to producing high quality work and continuous improvement
• Commitment to producing high quality work and demonstrating professional values in all aspects of work and interactions with colleagues and customers.
  
  

About You

Required Skills and Qualifications:

• Post-secondary degree – Bachelor of Science, Computing /Engineering, or a related field
• Minimum 5 years of relevant experience working on Database Administration and data products.
• Expert level experience working with Microsoft SQL Server, Azure SQL Database and Data Warehouse technologies, SaaS databases.
• Experience working with large data sets and knowledge of data management tools,
• Experience working with Windows server 2008-2022, Azure cloud environment.
• Strong experience with SQL, Python, Spark, Java, C sharp or other development language.
• Ability to work independently, build and maintain relationships and develop robust documentation.
• Experience with power platform to automate system integrations data import and processes.
• Strong understanding of data architecture, security, monitoring and disaster recovery.
• Expert Experience creating data models, database design, database schema and integrations.
• Excellent oral and written communication skills combined with strong interpersonal skills.
• Availability to work outside of regular hours/occasional weekends is required.
• Sound organizational, analytical, judgement, decision making and problem solving skills.
• Having a home office environment that provides for a productive, professional, and safe work environment during regular working hours is a requirement of this role. This includes internet service and a reliable connection.
  
  

Nice to Haves: (optional)

• Experience with MS Purview and cybersecurity tools and frameworks.
• Microsoft and ITIL Certification
• Bilingualism in English and French
  
  

Benefits

At CBoC, we believe that putting People First is key to our success and attracting the best people. We are committed to providing a supportive and inclusive work environment where everyone can thrive and we are proud to offer a comprehensive benefits package that includes:

• Virtual First – work from home anywhere across Canada with a budget to set up your home office.
• A workplace where your hard work is not just valued, but actively celebrated. We take pride in our commitment to recognizing and rewarding the exceptional talent that drives our success through our Recognition programs.
• Healthcare benefits from Day One to support your physical and mental wellbeing, including a $2,500 benefit for Psychologist, Social Worker or Psychotherapist services
• Work/Life Balance: In addition to 20 days annual vacation, we close between Christmas Day and New Year’s Day, observe 13 holidays per year and offer Friday afternoon closures.
• A modern, defined benefit (DB) pension plan: We care about your future and offer a pension plan with a 5% match from Day One
• Employee Family Assistance Program (EFAP): We understand that life can be unpredictable and challenging and EFAP supports you and your family during difficult times.
• Maternity and parental leave top-up plan
  
  

At the Conference Board of Canada, we are more than an organization – we are a collective of thinkers, analysts, and problem solvers. part of our remote workforce, you will play a crucial role in navigating the complexities of Canada’s economic landscape. Your expertise can lead the way in understanding and anticipating the nation’s economic trends. If you’re ready to make an impact where insights meet innovation, we want to hear from you.

The salary for this position ranges from $80,793 to $109,308 annually for candidates from any Canadian province or territory. Salaries are based upon candidate experience, qualifications, specific skillsets, as well as market and business considerations. The recruiter can share more information about the salary range for the position during the hiring process. This job posting is for an existing vacancy within CBoC. We are actively seeking to fill this role with a qualified candidate.

We value the unique skills, experiences, and insights that each employee brings to The Conference Board of Canada. We are committed to fostering an inclusive and accessible work environment where everyone feels valued, respected, and supported and welcome members of all backgrounds and perspectives to apply. If you require an accommodation at any point during the recruitment process, please email [email protected] and we will work with you to meet your needs.

We wish to thank all applicants for their interest in The Conference Board of Canada. Please note that only those selected for an interview will be contacted.