Trabajo de Programador SQL Sr / Jr en Confidencial, Ciudad de México - México
search
tune

Filtros

close

Rango de salario (MXN)

Tipo de empleo

Fecha de publicación

Programador SQL Sr / Jr

Confidencial

DESCRIPCION:

·          Experiencia en la estructura de base de datos relacional y uso de consultas SQL para analizar datos.

·          Conocimiento en programación de SQL (Funciones, ETLs, Scripts, Stored Procedures, Triggers, Consultas complejas, BackEnd de SQL).

·          Conocimiento en análisis y extracción de datos para creación de bases de datos para su posterior uso y explotación por las unidades de negocio como finanzas y mercadeo.

·          Conocimiento en optimización, desarrollo y mejora de Código SQL / SAS. Código de Automatización de procesos de Datos.

·          Conocimiento en operaciones de soporte a procesos de datos.

·          Deseable: conocimientos de Data Mining, DWH o BI.

·          Deseable: conocimientos en diseño, desarrollo e implementación de ETLs y herramientas de calidad de datos.

Deseable: conocimiento en el uso de la plataforma SAS.

Primary Responsibilities

 

1) Solution Maintenance

● Effectively transfers and absorb knowledge through documentation and processes management

● Automate and strengthen data management controls

● Proven experience in maintaining complex data management solutions from requirements through design and implementation

● Identifies and remediates issues through “root cause analysis"

 

2) Data Quality

● Ensure data solutions include the activities and deliverables required to achieve high data quality.

● Able to manage security mechanisms that enable data access restrictions

● Knowledge and use of tools to monitor data quality

● Review source system to determine accuracy, audit data for discrepancies, correct errors where appropriate

 

3) Data Operations & Governance

● Knowledge and understanding of data quality & data management principles including metadata, lineage and business definitions

● Evaluate processes for gaps, inefficiencies and additional opportunities and provide recommendations for improvement

·          Desirable knowledge in Mapping Business Processes

·          Desirable experience in Control areas

 

4) Data Strategy

● Ability to grasp new technologies rapidly as needed to progress varied initiatives.

● Takes ownership for understanding of their respective data areas

● Demonstrates understanding of the use of data to solve/augment a business use case

● Highly effective at balancing risk with business need

 

5) Prioritization & Value

● Able to describe stakeholder value of data management solutions and activities throughout a project lifecycle

● Be able to influence decision makers on the outcome of an initiative or activity based on its perceived value.

 

6) Leadership

● Set expectations for owned deliverables; knowledge of Agile techniques

● Maintains close working relationship with data providers and partners

● Expected to embrace company core capabilities and values, drive team culture, and contribute within a team and to the broader data community.