Descrição
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.
A GM não fornece patrocínio relacionado à imigração para esta função. Não se candidate a esta função se você precisar de patrocínio de imigração gm agora ou no futuro.
Esta função é classificada como híbrida. Isso significa que o candidato selecionado deverá trabalhar no escritório/fábrica da GM pelo menos 3 vezes por semana {ou outra frequência ditada por seu gerente}.
Esta posição não é elegível para benefícios de relocação. Quaisquer custos de relocação serão de responsabilidade do candidato selecionado.
Informações sobre diversidade
A General Motors está comprometida em ser um local de trabalho que não só é livre de discriminação ilegal, como estimula verdadeiramente a inclusão e integração. Acreditamos enfaticamente que a diversidade na força de trabalho cria um ambiente no qual nossos colaboradores podem crescer e desenvolver melhores produtos para nossos clientes. Incentivamos os candidatos interessados a analisar as principais responsabilidades e qualificações de cada função e a se candidatar a qualquer cargo que corresponda a suas habilidades e capacidades. Os candidatos no processo de recrutamento podem, quando aplicável, ser solicitados a concluir com sucesso uma ou mais avaliações relacionadas à função e/ou uma seleção pré-emprego antes de iniciar o emprego. Para saber mais, acesse Como contratamos.
Declaração de Igualdade de Oportunidades de Emprego (EUA)
A General Motors tem orgulho de ser um empregador que oferece oportunidades iguais. Todos os candidatos qualificados serão considerados para o emprego, independentemente de raça, cor, religião, sexo, orientação sexual, identidade de gênero, origem nacional, deficiência ou status como veterano protegido.
Adaptações (EUA e Canadá)
A General Motors oferece oportunidades a todos os candidatos a emprego, incluindo pessoas com deficiências. Se você precisa de uma adaptação razoável para ajudá-lo na sua pesquisa de cargos ou solicitação de emprego, fale conosco pelo e-mail [email protected] ou pelo telefone 800-865-7580. No seu e-mail, inclua uma descrição da adaptação específica que você está solicitando assim como o nome do cargo e o número de requisição do cargo ao qual está se candidatando.
