Database Engineer (Mexico)

MSIGHTS; Monterrey; Presencial; MXN 371,000 - 558,000; Jornada completa

Descripción de la vacante

A leading company in cloud-based marketing data integration services is seeking a Data Transformation Engineer to develop and execute automatic data collection and integration processes. This role requires strong initiative, a passion for data, and a commitment to delivering high-quality service. The ideal candidate will have experience with AWS and various database services, as well as strong communication skills to effectively collaborate within the team.

Formación

• 2+ years of experience in Cloud Computing with AWS.
• Familiarity with various databases like Redshift, SQL Server, and PostgreSQL.
• Detail-oriented, client-focused, and able to innovate.

Responsabilidades

• Responsible for the ETL process, including validations and data preparation.
• Implement solutions in various database engines and monitor performance.
• Deliver applications using Agile and Scrum methodologies.

Conocimientos

Cloud Computing

Data Normalization

Data Flows

Data Streams

Data Sanitization

SQL

PostgreSQL

Communication

Educación

Bachelor's Degree or equivalent

Herramientas

AWS

SQL Server

Redshift

Athena

Descripción del empleo

MSIGHTS Founded in 2004, MSIGHTS (msights.com) provides cloud-based marketing data integration services to some of the world’s most sophisticated global advertisers. As marketing channels proliferate, so do the data sources marketers must examine in order to quantify results and guide strategy. MSIGHTS services make marketers more efficient and successful by providing a single view of overall marketing performance with actionable insights on what works and what doesn’t. The MSIGHTS Platform automatically collects and reconciles disparate data, making it immediately available to fuel a wide variety of analytical and visualization tools. The Database Engineer Position is offered in our Monterrey, Nuevo León office.

Position Overview
The Data Transformation Engineer plays a key role in the development and execution of automatic data collection and integration processes. This position focuses on the importing of data from a variety of sources into the Platform for reporting. The Data Transformation Engineer is part of the Database team which is dedicated to providing clean and useable marketing data to our clients. As part of the MSIGHTS team, this position requires a great capacity to take initiative, an ability to consistently deliver above expectation, a passion for continuous improvement, and a willingness to work hard and be rewarded.

Responsibilities and Duties

• Position is responsible for the ETL process which includes the different marketing channels, validations, and preparation of the data for Reporting or System to System interconnection.
• Responsible for understandingData models, how to normalize data and prepare information in the form of views and report sets.
• Implement Solutions in different Database engines that incorporate Dat Flows and/or Data Streams.
• Implement Client Business Rules to use and group data.
• Monitor and improve query execution, performance for all clients.
• Using Agile and Scrum methodologies, deliver a plan and follow it to successfully release the applications.
• The candidate is required to document, generate ideas, follow coding standards, and follow coding patterns.

Qualifications and Skills

• 2+ years of experience working on Cloud Computing in AWS services.
• Working knowledge in any of the following database services Redshift, Athena, In -memory database, SQL Server, PostgreSQL.
• Experience with Data Models, Data Normalization, Automatic,Data Sanitization, Data Flows, Data Streams, and Data Maps.
• Must be a self-starter, willing to take the initiative and propose innovation in MSIGHTS products and/or processes.
• Fluent in the English Language with strong communications skills -both written and verbal — and the ability to work well with an internal team.
• Must be detail-oriented, committed to quality, and client-focused, all while being flexible and entrepreneurial in a fast-paced international work environment.

How many years of experience do you have?*

What is the highest level of education you have completed?*

Are you eligible to work in the country associated with this position?* Yes No