The Conference Board

Senior Database Developer

The Conference Board

full-time

Posted on:

Origin:  • 🇨🇦 Canada

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 CA$80,793 - CA$109,308 per year

Job Level

Senior

Tech Stack

AzureCloudERPETLMS SQL ServerPythonSQLSSIS

About the role

  • Maintain, monitor, and support our on-premise 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 website database replica for Power BI and SQL reporting used by internal users.
  • Assist in setup and ongoing maintenance of big data environment for our research team.
  • Design and manage end-to-end solutions for both current and future state data systems.
  • Setup, configure and manage 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
  • Propose path forward for Cloud based database setup from MS SQL to Azure.
  • Automate database processes, tasks, and procedures using SQL, Azure and power automate.
  • Setup role-based access to safeguard the security and integrity of databases and applications.
  • Prepare monthly report on database utilization, capacity usage and actionable recommendations.
  • Manage tracking sheet of all database issues, status and how we plan to mitigate.
  • Develop technical workplans for roadmap project assignments.
  • Collaborate with business units to collect application and database requirements for new applications
  • Conduct Proof of Concepts for new database technology and provide recommendations to the Director, IT.
  • Demonstrate a strong commitment to delivering high-quality and professional values

Requirements

  • Post-secondary degree – Bachelor of Science, Computing /Engineering, or a related field
  • Minimum of 5 years of relevant experience in database management and data engineering.
  • SQL Expertise: Strong knowledge of efficient data extraction from legacy systems (e.g., SQL Server, e-data) and cloud databases 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): Seamless data movement from transactional systems to the data warehouse.
  • Build SSIS packages to extract data from ERP systems and load into Azure Fabric for analytics.
  • Data Modeling & Design: Normalize and optimize schemas for scalability and performance.
  • Design star schemas for BI reporting; refactor legacy schemas to reduce redundancy.
  • Cloud Data Services (Azure Cloud): Support hybrid cloud architecture, migrate on-prem SQL databases to Azure Cloud where feasible; configure backups and proactive monitoring.
  • Scripting (PowerShell, Python, Notebooks): Automate maintenance tasks and enable advanced analytics.
  • Create PowerShell scripts for nightly backups; use Python for data validation scripts.
  • Soft Skills (Communication, Mentoring): 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