Database Developer, Information Technology (Remote) jobs in United States
cer-icon
Apply on Employer Site
company-logo

The Conference Board of Canada · 22 hours ago

Database Developer, Information Technology (Remote)

The Conference Board of Canada is the nation’s largest independent applied research organization, providing unbiased information and analysis. They are seeking an experienced Database Developer to manage enterprise SQL databases and support technology transformation initiatives, including migrating systems to cloud platforms.

AssociationNon Profit

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

Qualification

SQL ExpertiseETL Tools (SQL SSIS)Cloud Data Services (Azure)Scripting PowerShellScripting PythonAzure DevOpsGitMicrosoftITIL CertificationBilingualism in EnglishFrenchSoft Skills (Communication)

Required

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

Preferred

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. 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

Company

The Conference Board of Canada

twittertwittertwitter
company-logo
The Conference Board of Canada is a Canadian not-for-profit think tank dedicated to researching and analyzing economic trends.

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Susan Black
President and CEO
linkedin
Company data provided by crunchbase