Skip to content
mimi

Database Developer, Information Technology (Remote)

Signal49 Research

Remote · Canada Full-time Mid Level CA$67k – CA$79k/yr 2w ago

About the role

About Signal49 Research

Signal49 Research, formerly operating as The Conference Board of Canada, 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. Signal49 Research 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 experienced and results‑driven Database Developer to join our dynamic Information Technology team. In this key role, you will be responsible for managing all enterprise SQL databases, agents, and jobs used across various departments for functions including big data, reporting, sales, marketing, and client‑facing economic forecasts and data products. You will support innovation and technology transformation initiatives for both new and existing projects, transitioning from on‑premise systems to Microsoft Azure, Microsoft Fabric, Databricks, the Dataverse (CRM and Business Central), and other modern data platforms. This includes future data migrations and ongoing process improvements.

Our ideal candidate… is highly motivated and analytical, with a growth mindset. You possess data engineering skills that support database administration, automation of data integrations, and maintenance of ETL processes between applications. You have a passion for technology and continuous learning, and you excel at troubleshooting and resolving complex issues.

We are a virtual organization and as a remote worker you must be comfortable and able to work 100 % 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

Key Responsibilities

  • Maintain, monitor, and support our Microsoft SQL databases for sales, marketing and research data.
  • Manage existing SQL Agent jobs, SSIS integration packages and stored procedures.
  • Conduct performance tuning of SQL queries for automated job primarily backup and mirroring.
  • Support database setup for Power BI and SQL reporting dashboards used by internal users.
  • Assist in setup and ongoing maintenance of big data environment for our research team.
  • Prep monthly report on database utilization, capacity usage, tracking sheet for issues.
  • Support IT Roadmap project assignments.
  • Assist in the design and management of secure solutions for both current and future state data systems.
  • Setup, configure and support Microsoft Fabric for enterprise use and data governance.
  • Create ETL between on‑prem databases and the Dataverse for CRM, ERP and Microsoft SaaS.
  • Develop a technology data model and schema to support new systems.
  • Setup and configure cloud‑based database setup from MS SQL to Azure.
  • Automate database processes, tasks, and procedures using SQL, Azure and Power Automate.
  • Support role‑based access to safeguard the security and integrity of databases and applications.
  • Collaborate with business units to collect requirements for new applications.
  • Demonstrate a strong commitment to delivering high‑quality and professional values.

About You

Required Skills and Qualifications

  • Post‑secondary degree – Bachelor of Science, Computing / Engineering, or a related field.
  • 3‑5 years of relevant experience in database management and data engineering.
  • SQL Expertise: Knowledge of data extraction from legacy systems (e.g., SQL Server, e‑data), cloud databases and Dataverse for Azure Cloud. Write queries for reporting dashboards; develop stored procedures to perform business processes, automate tasks using jobs and agents.
  • ETL Tools (SQL SSIS): Hands‑on experience supporting SSIS packages to extract data from ERP systems and load into Azure Fabric and Databricks for analytics. Working knowledge of star schema.
  • Cloud Data Services (Azure Cloud): Configure backups and proactive monitoring agents and jobs.
  • Scripting (PowerShell, Python, Notebooks): Experience automating maintenance tasks and enable advanced analytics. Create PowerShell scripts for nightly backups; use Python for data validation scripts.
  • Soft Skills (Communication): Ability to communicate effectively through MS Teams, Email and SP collaboration tools. This includes being responsive, reaching out when assistance is required, seeking feedback in alignment with growth mindset.
  • Availability to work outside of regular hours/occasional weekends is required.

Nice To Haves

  • Azure DevOps or Git for tracking changes to database objects and scripts, managing stored procedures and schema changes.
  • Experience working with CD/CI pipelines, AI/ML, security tools and frameworks.
  • Microsoft and ITIL Certification.
  • Bilingualism in English and French.

Benefits

  • 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. Recognition programs acknowledge exceptional talent.
  • 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: 20 days annual vacation, closure between Christmas Day and New Year’s Day, 13 holidays per year, and Friday afternoon closures.
  • A modern, defined benefit (DB) pension plan with a 5 % match from Day One.
  • Employee Family Assistance Program (EFAP) to support you and your family during difficult times.
  • Maternity and parental leave top‑up plan.

Compensation

The salary for this position ranges from $67,320 – $79,200 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.


Inclusion & Accommodation

We value the unique skills, experiences, and insights that each employee brings to Signal49 Research. 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 recruitment@signal49.ca and we will work with you to meet your needs.

We wish to thank all applicants for their interest in Signal49 Research. Please note that only those selected for an interview will be contacted.

Requirements

  • Post-secondary degree – Bachelor of Science, Computing /Engineering, or a related field
  • 3-5 years of relevant experience in database management and data engineering.
  • SQL Expertise: Knowledge of data extraction from legacy systems (e.g., SQL Server, e-data), cloud databases and Dataverse for Azure Cloud. Write queries for reporting dashboards; develop stored procedures to perform business processes, automate tasks using jobs and agents.
  • ETL Tools (SQL SSIS): Hands on experience supporting SSIS packages to extract data from ERP systems and load into Azure Fabric and Databricks for analytics. Working knowledge of star schema.
  • Cloud Data Services (Azure Cloud): Configure backups and proactive monitoring agents and jobs.
  • Scripting (PowerShell, Python, Notebooks): Experience automating maintenance tasks and enable advanced analytics. Create PowerShell scripts for nightly backups; use Python for data validation scripts.
  • Soft Skills (Communication): Ability to communicate effectively through MS Teams, Email and SP collaboration tools. This includes being responsive, reaching out when assistance is required, seeking feedback in alignment with growth mindset.
  • Availability to work outside of regular hours/occasional weekends is required

Responsibilities

  • Maintain, monitor, and support our Microsoft SQL databases for sales, marketing and research data.
  • Manage existing SQL Agent jobs, SSIS integration packages and stored procedures
  • Conduct performance tuning of SQL queries for automated job primarily backup and mirroring.
  • Support database setup for Power BI and SQL reporting dashboards used by internal users.
  • Assist in setup and ongoing maintenance of big data environment for our research team.
  • Prep monthly report on database utilization, capacity usage, tracking sheet for issues
  • Support IT Roadmap project assignments
  • Assist in the design and management of secure solutions for both current and future state data systems.
  • Setup, configure and support of Microsoft Fabric for enterprise use and data governance.
  • Create ETL between on prem databases and the Dataverse for CRM, ERP and Microsoft SaaS.
  • Develop a technology data model and schema to support new systems
  • Setup and configure cloud based database setup from MS SQL to Azure.
  • Automate database processes, tasks, and procedures using SQL, Azure and Power Automate.
  • Support role-based access to safeguard the security and integrity of databases and applications.
  • Collaborate with business units to collect requirements for new applications
  • Demonstrate a strong commitment to delivering high-quality and professional values

Benefits

home office budgetRecognition programsHealthcare benefitsPsychologist, Social Worker or Psychotherapist services20 days annual vacationChristmas Day and New Year’s Day closure13 holidays per yearFriday afternoon closuresdefined benefit (DB) pension plan5% pension matchEmployee Family Assistance Program (EFAP)Maternity and parental leave top-up plan

Skills

AzureAzure CloudAzure FabricDatabricksDataverseETLGitMicrosoft FabricMS SQLNotebooksPower BIPower AutomatePowerShellPythonSQLSQL ServerSSIS

Don't send a generic resume

Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.

Get started free