Database Administrator

Insight Global (United States)

Toronto

On-site

CAD 70,000 - 110,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Insight Global is seeking a meticulous Data Analyst to oversee the data ingestion pipeline, enforce quality checks, and guard production data from corruption in a live database environment. Your work will focus on loading extracts, validating integrity, and generating outbound data packages.

You will use strong SQL skills, data profiling, and standard ETL tools to identify anomalies, reconcile datasets, and document data reconciliations for the team, ensuring compliance with data governance and

Qualifications

  • Strong SQL skills with complex queries to join, filter, and compare large data sets.
  • Experience with data profiling and data validation frameworks.
  • Proven experience safely managing production data without disrupting end-user activity.
  • Familiarity with data ingestion, ETL processes, and data reconciliation workflows.

Responsibilities

  • Load and process data extracts from internal and external sources into staging systems.
  • Review and audit incoming extracts for completeness, accuracy, and formatting compliance.
  • Map and compare external extracts against production schemas to ensure alignment before ingestion.
  • Enforce quality and integrity checks during the staging phase to prevent bad data from affecting production.
  • Profile data to identify anomalies, formatting errors, duplicates, and missing constraints using SQL.
  • Identify bad, redundant, or corrupted data to perform safe deletion and cleanup operations without impacting production users.
  • Generate outbound data extracts and manifest files to verify row counts and data completeness for delivery packages.
  • Document data reconciliation workflows and report systemic data quality issues to the team.

Skills

SQL proficiency
Data profiling
Data quality
Production data handling

Education

Oracle DBA certs

Tools

SQL*Loader
SSMS
Oracle

Job description

Job Description

We are seeking a meticulous Data Analyst (Data Quality & Integration) to oversee our data ingestion pipeline. Your primary responsibility will be loading data extracts into our existing database while enforcing strict quality and integrity checks. You will act as the first line of defense against bad data—proactively finding data anomalies, identifying corrupted records for deletion and cleanup, and generating outbound data extracts and manifest files using native database tools and standard queries. A critical component of this role involves working directly in a live database environment, requiring the utmost care and optimization to ensure operations do not impact active users.

Skills and Requirements
  • Compare and reconcile data sets to identify discrepancies, trends, and anomalies.
  • Load and process data extracts from various internal and external sources into our staging systems.
  • Review and audit incoming extracts for completeness, accuracy, and formatting compliance.
  • Map and compare external extracts against existing production database schemas to ensure alignment before final ingestion.
  • Enforce quality and integrity checks during the staging phase to prevent bad data from polluting production systems.
  • Profile data to find hidden problems, such as formatting errors, orphaned records, duplicates, and missing constraints using pure SQL.
  • Identify bad, redundant, or corrupted data to execute safe deletion and cleanup operations using optimized database commands while ensuring you do not impact production users.
  • Generate outbound data extracts and compile accompanying manifest files to verify row counts, file structures, and data completeness for delivery packages.
  • Document data reconciliation workflows and report systemic data quality issues to team members.
Required Skills & Qualifications
  • Strong SQL skills with experience writing complex queries to join, filter, and compare large data tables.
  • Advanced SQL functionality, specifically in writing safe, highly optimized queries to identify, update, and clean data within a live database environment.
  • Proven experience managing production data safely, demonstrating the technical caution necessary to execute changes without disrupting system performance or end-user activity.
  • Experience with data profiling and implementing data validation frameworks (e.g., handling primary/foreign key integrity, null checks).
  • Proficiency with database export/import utilities and GUI tools (e.g., Oracle, SQL*Loader, SSMS) for loading and extracting flat files.
  • Familiarity with creating flat file extracts and accompanying manifest files used to verify data integrity during transfers, ensuring completeness for down-stream processing by other team members.
  • Strong understanding of database constraints, indexes, and schemas to ensure data migrations don't break dependencies.
  • High attention to detail with a track record of identifying and resolving sensitive data issues without causing data loss.
  • RIS
  • EMR
  • EPIC
  • Cerner
  • Healthcare background
  • Regulated data experience
  • Certificate, Oracle 9i/10G/11G/12c DBA / OCA , MS SQL 10.5/11/12/13

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Integration Analyst
Data Integration Analyst

ASEBP • Edmonton

Hybrid
CAD 82,000 - 92,000
Hybrid workforce program
Sr. Data Analyst | Canada | Remote
Sr. Data Analyst | Canada | Remote

Sutherland Company • Windsor

Remote
CAD 90,000 - 130,000
Database Administrator
Database Administrator

Eizie • Kitamaat

On-site
CAD 90,000 - 120,000
Competitive salary
Health benefits
Professional development
+5
Database Administrator
Database Administrator

Sotera Health Company • Ottawa

On-site
CAD 90,000 - 130,000
Data Analyst
Data Analyst

850 Cardinal Health Canada, Inc. • Vaughan

Hybrid
CAD 81,000 - 119,000
Senior Data Analyst
Senior Data Analyst

tealbook • Canada

On-site
CAD 90,000 - 120,000
Sr. BI & Data Analyst | Remote | Canada
Sr. BI & Data Analyst | Remote | Canada

Sutherland Company • Windsor

Remote
CAD 90,000 - 120,000
Sr. BI & Data Analyst | Remote | Canada
Sr. BI & Data Analyst | Remote | Canada

Sutherland • Canada

Remote
CAD 90,000 - 130,000
Senior Database Developer / Administrator
Senior Database Developer / Administrator

Reelcruit • Toronto

Hybrid
CAD 90,000 - 130,000
Inclusive workplace
Growth opportunities
Flexible work arrangements
+3
Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)
Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)

Astra-North Infoteck Inc. • Toronto

On-site
CAD 90,000 - 130,000