描述
Vacancy Status: This posting is for a new vacancy within the organization and is open to new applications.
AI Disclosure: As part of the application process, Artificial Intelligence will be used in the hiring process for this role
This role is categorized as hybrid. This means the successful candidate is expected to report to the Markham Elevation Centre or the Oshawa Elevation Centre at least three times per week.
The Team & Opportunity
The Enterprise Data team is responsible for supporting and modernizing the data platforms that enable analytics, artificial intelligence, customer engagement, strategic planning, and other enterprise capabilities across GM.
We are building a new team to support the existing legacy environment while migrating and transforming the architecture to a cloud-based platform. This role will help establish the engineering standards, reusable platform capabilities, delivery automation, and operational practices required for a secure, scalable, governed, and reliable cloud data ecosystem.
The ideal candidate combines strong data quality and validation fundamentals with a focus on automation and continuous improvement. They are comfortable working closely with data engineering, business analysis, governance, and business stakeholders to define quality expectations, detect and resolve data issues, and ensure enterprise data is complete, accurate, consistent, and aligned with schema requirements across legacy and cloud environments.
The Role
As a Data Validation & Data Quality Analyst, Enterprise Data, you will continuously monitor and assess the quality of data within the enterprise data warehouse. You will help ensure that data is complete, accurate, consistent, timely, and compliant with defined schema and business requirements.
This role focuses on designing, automating, and maintaining data validation and quality controls across data pipelines and warehouse environments. You will work closely with the Data Engineering team to embed checks into data workflows and with the Business Analyst to understand business rules, data definitions, and stakeholder expectations. You will investigate exceptions, coordinate issue resolution, and provide clear visibility into data quality and remediation status. The role supports both the existing legacy environment and its migration to a cloud-based implementation, which may be Azure/Databricks or Google Cloud Platform.
Key Responsibilities
- Develop, automate, and maintain data-quality checks to monitor completeness, accuracy, validity, consistency, uniqueness, and timeliness across enterprise data.
- Define and implement schema validation controls to confirm that data structures, formats, data types, required fields, and constraints meet agreed requirements.
- Build automated validation into data ingestion, transformation, and publishing workflows in partnership with data engineers.
- Create repeatable checks for record counts, null values, duplicates, referential integrity, domain values, business rules, and cross-source reconciliation.
- Monitor data-quality results and pipeline outputs on an ongoing basis; identify anomalies, unexpected changes, and emerging quality trends.
- Establish alerting and exception-management processes so that data issues are detected, prioritized, communicated, and resolved promptly.
- Investigate data-quality incidents by tracing issues across source systems, transformations, schemas, and downstream consumers.
- Partner with data engineers to identify root causes, define corrective actions, and prevent recurring defects through improved controls and automation.
- Work with the Business Analyst and business stakeholders to translate business rules, data definitions, and quality expectations into clear, testable validation criteria.
- Support data migration and modernization by defining and executing validation and reconciliation plans for legacy-to-cloud data, including parallel-run comparisons where appropriate.
- Verify that migrated data conforms to target schemas, transformation logic, and agreed business rules while supporting continuity of existing data services.
- Maintain data-quality dashboards, scorecards, exception reports, and operational metrics that provide clear visibility into quality levels and remediation progress.
- Document validation rules, test results, defects, root causes, remediation actions, and quality standards.
- Support data governance practices by helping maintain data definitions, quality thresholds, ownership, lineage, and control documentation.
- Contribute to sprint planning, backlog refinement, estimation, defect prioritization, demos, and continuous improvement with the data delivery team.
- Participate in incident reviews and recommend improvements to validation coverage, monitoring, processes, and operational readiness.
Required Qualifications and Skills
- Bachelor’s degree in Computer Science, Engineering, Information Systems, Data Management, or a related discipline, or equivalent practical experience.
- Demonstrated experience in data quality, data validation, data analysis, quality assurance, data engineering, or a related field.
- Strong SQL skills and experience analyzing data in relational databases or enterprise data warehouse environments.
- Experience creating and executing data validation, reconciliation, and quality tests for production or business-critical data.
- Experience automating repetitive data checks using Python, SQL, or comparable scripting and programming tools.
- Understanding of relational data structures, schemas, data types, keys, constraints, and data integration concepts.
- Ability to translate business rules and data requirements into measurable and repeatable validation criteria.
- Strong analytical and troubleshooting skills, including the ability to identify patterns, isolate root causes, and assess downstream impacts.
- Experience tracking data defects, documenting findings, coordinating resolution, and verifying corrective actions.
- Familiarity with data pipelines and ETL/ELT processes, including how data is ingested, transformed, and delivered to consumers.
- Strong communication and collaboration skills, with the ability to work effectively with technical teams and business stakeholders.
- Strong attention to detail and organizational skills, with the ability to manage multiple quality issues and priorities.
Preferred Qualifications
- Experience supporting data quality in an enterprise data warehouse, especially in an Oracle-based environment.
- Experience supporting data warehouse modernization or migration to Azure, Databricks, Google Cloud Platform, or comparable cloud platforms.
- Familiarity with data-quality automation frameworks such as Great Expectations, Soda, Deequ, dbt tests, or equivalent tools.
- Experience using Python libraries and automation patterns to build repeatable data testing and monitoring solutions.
- Familiarity with Databricks, Delta Lake, BigQuery, Synapse, or equivalent cloud data and lakehouse platforms.
- Experience with data observability, anomaly detection, automated alerting, and data-quality dashboards.
- Familiarity with data governance concepts including data ownership, metadata, lineage, classification, and quality thresholds.
- Experience defining and monitoring data-quality metrics, scorecards, service targets, or operational controls.
- Experience with Git, code review, CI/CD, or integrating automated tests into data pipeline delivery.
- Familiarity with Jira, Confluence, or comparable tools for defect tracking and documentation.
- Experience working in a large, matrixed, or regulated organization with enterprise data, security, or privacy requirements.
Compensation:
The salary range for this role is $76,100 to $114,300. The actual base salary a successful candidate will be offered within this range will vary based on factors relevant to the position.
Renseignements sur la diversité
General Motors est résolue à être un lieu de travail qui est non seulement exempt de discrimination illégale, mais aussi un endroit qui favorise véritablement l'inclusion et l'appartenance. Nous sommes convaincus que la diversité de la main-d'œuvre permet de créer un environnement dans lequel nos employés peuvent s'épanouir et développer de meilleurs produits pour nos clients. Nous encourageons les candidats intéressés à consulter les principales responsabilités et compétences requises pour chaque rôle et à postuler à tout poste qui leur correspond. Dans le cadre du processus de recrutement, les candidats peuvent devoir, le cas échéant, réussir une évaluation liée au poste ou une présélection d'emploi avant d'être embauchés. Pour en savoir plus, consultez notre processus de recrutement.
Déclaration concernant l'égalité d'accès à l'emploi (É.-U.)
General Motors est fière d'être un employeur souscrivant au principe de l'égalité d'accès à l'emploi. Tous les candidats qualifiés seront pris en compte, sans égard à la race, à la couleur, à la religion, au sexe, à l'orientation sexuelle, à l'identité de genre, à l'origine ethnique, aux situations de handicap ou au statut protégé d'ancien combattant.
Aménagements (É.-U. et Canada)
General Motors offre des occasions à tous les chercheurs d'emploi, y compris les personnes handicapées. Si vous avez besoin d'un accommodement raisonnable pour vous aider dans votre recherche d'emploi ou la soumission de votre candidature, envoyez-nous un courriel à l'adresse [email protected] ou appelez-nous au 800 865-7580. Veuillez inclure dans votre courriel une description spécifique du type d'accommodement demandé, ainsi que le titre d'emploi et le numéro de demande du poste auquel vous postulez.
