MSIGHTS, founded in 2004, 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 usable 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 Responsible for the ETL process which includes the different marketing channels, validations, and preparation of the data for reporting or system-to-system interconnection.Understand data models, how to normalize data, and prepare information in the form of views and report sets.Implement solutions in different database engines that incorporate data 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.Document, generate ideas, follow coding standards, and adhere to coding patterns.Qualifications and Skills 2+ years of experience working on cloud computing in AWS services.Working knowledge of 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 communication skills - both written and verbal - and the ability to work well with an internal team.Detail-oriented, committed to quality, and client-focused, while being flexible and entrepreneurial in a fast-paced international work environment.
#J-18808-Ljbffr